How do I display this - MDX Query

Posted on 2005-04-18
Last Modified: 2013-11-16

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?

Question by:hydev
    LVL 11

    Expert Comment

    From the Excel toolbar, choose:
      Data\Import External Data\New Database Query

    Then choose the OLAP Cubes tab. Browse for your MDX file.

    Author Comment


    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.

    LVL 11

    Accepted Solution


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    Introduction If you are not already aware of what you could use a table with sequential integer values for in SQL, you can read Delimited String Parsing in SQL Server 2005 or later ( by BrandonGalderisi (h…
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now