how do i query the data in a cube?

  • i know that to query data in a cube you use MDX, but where do i go to type this in so as to query the cube, and how do i select the cube to be queried? i am using sql server2000 with analysis services.

     

    thanks all

  • This was removed by the editor as SPAM

  • This is a rough answer but using excel you can do both mdx and link to the data using pivot tables. That would be under data import and choose MS olap. Tell me if that helps

  • Hi-

    Did anybody find the solution of query data from cube?

    If so then please let me know i am stuck with this:

    query data from data cube. I am using MS SQL server

    2000 with Microsoft Analysis Services.

    Regards,

    Mateen

  •  

    if you just want to query the cube.

    You can use

    SqlServer->Analysis Services->MDX Sample application

    for your test queries.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply