This project has moved. For the latest updates, please go here.

Can I execute my MDX query with this extension?

Topics: Resolved
Jun 19, 2008 at 5:04 PM
I have a MDX query, but I don't know how to run it and get the results in Excel. I've installed this extension, but it seems that it is only capable of reading the existing MDX of the imported tables. Need some kind of MDX query ad-hoc, and the results in Excel. Please help me...
Coordinator
Jun 23, 2008 at 4:08 PM
If you already have an MDX query, then you may want to run it in Management Studio (part of the SQL Server installation) then copy and paste to Excel.

This extension is for PivotTables built in Excel (designed from scratch in Excel) to let you see the MDX query it's executing against the server. It doesn't let you modify or specify the MDX query.
Jun 24, 2008 at 1:30 AM
 I have my reports in Excel, using a SSAS project as source. This Excel file updates automatically everytime i open it. I didn't want to copy/paste everytime i update my cubes...

I guess the only way a can execute my own MDX querys is in SSRS... Too bad.

Thanks anyway ;)
Coordinator
Apr 4, 2011 at 9:21 PM

As noted here, the MDX property of a PivotTable is read-only:
http://olappivottableextend.codeplex.com/discussions/56794

One workaround is to use a QueryTable to run any MDX query you want. Chris Webb blogged about this here:
http://cwebbbi.wordpress.com/2009/12/18/binding-an-excel-table-to-the-results-of-an-mdx-query/

Marked as answer by furmangg on 6/10/2014 at 3:56 AM