Wednesday, October 12, 2011

OLAP PivotTable Extensions

This is one of my favourite Excel add-ins when dealing with Analysis Services cubes.  It can pull the MDX out of a pivot table, search cubes, add in calculated measures on the fly, and allow users to share measures.

The latest releases fix some bugs and provide a very useful feature of clearing a pivot table’s cache.  The pivot table cache, a monstrosity of XML code, is known to blow up many an Excel workbook.

Show properties as a caption allows captions to be exposed as real members in the workbook.

Worth downloading if you use OLAP cubes regularly.

OLAP PivotTable Extensions

No comments: