• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 674
  • Last Modified:

How do I display this - MDX Query

Hi,

I have an MDX query that I have written in the 'MDX Sample Application' that comes with SQL Server 2000.  The data in the data pane is perfect, I just want to browse and use that like I do in Excel with a Pivot Table that is based on a pure cube.  However how do I do it? Can I base a PivotTable in Excel on a MDX expression? If not how else can I display the report?

Mike
0
hydev
Asked:
hydev
  • 2
1 Solution
 
Jokra_the_BarbarianCommented:
From the Excel toolbar, choose:
  Data\Import External Data\New Database Query

Then choose the OLAP Cubes tab. Browse for your MDX file.
0
 
hydevAuthor Commented:
Hi,

Thansks but I can't seem to do what you are recommending.  I am using Excel 2003, if I go to Data\Import External Data\New Database Query it loads Microsoft Query, how do you load the MDX file in that?  It immediatly asks me for a Data Source, if I then select the OLAP server it asks for the cube and then creates a PivotTable.  If I go to the OLAP cubes tabe and browse, all I can do is load a .oqy file not a .mdx.  If I specifiy an .mdx it says it is invalid.

Sorry if I am being stupid here.

Mike
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now