New release of "OLAP PivotTable Extensions"

Posted by Luca Zavarella on SQL Team See other posts from SQL Team or by Luca Zavarella
Published on Mon, 06 Feb 2012 11:20:16 GMT Indexed on 2012/03/18 18:12 UTC
Read the original article Hit count: 380

Filed under:

For those who are not familiar with this add-in, the OLAP PivotTable Extensions add features of interest to Excel 2007 or 2010 PivotTables pointing to an OLAP cube in Analysis Services. One of these features I like very much, is to know the MDX query code associated with the pivot used at that time in Excel:

AvgTaxMDX2.png

You can find all the details here:

http://olappivottableextend.codeplex.com/

It was recently released a new version of the add-in (version 0.7.4), which does not introduce any new features, but fixes a significant bug:

Release 0.7.4 now properly handles languages but introduces no new features. International users who run a different Windows language than their Excel UI language may be receiving an error message when they double click a cell and perform drillthrough which reads: "XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value". This error was caused by OLAP PivotTable Extensions in some situations, but release 0.7.4 fixes this problem.

Enjoy! Smile

© SQL Team or respective owner