OLAP PivotTable Extensions – extending analysis in Excel

Anyone developing cubes who uses Excel as an analysis/debug tool may find there are a couple of limitations. One of these is knowing what MDX is generated by Excel to query your OLAP cubes.

Yes, you could run a SQL Profiler trace on the SSAS instance and find out that way but its easier to install the OLAP PivotTable Extensions. This will let you view the MDX directly in Excel amongst other things.

Im surprised i only just came to know of this today since this utility has been on Codeplex for some time. Better late than never!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: