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
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:
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!
© SQL Team or respective owner