Menu Close

OLAP PivotTable Extensions 0.9.6 for Windows

OLAP PivotTable Extensions icon

App Preview

App Name

OLAP PivotTable Extensions

Description:Extends the functionality of PivotTables on Analysis Services cubes and helps you create a library that features all the calculations you used
Version:OLAP PivotTable Extensions 0.9.6
File name:OLAP.PivotTable.Extensions.Setup.v0.9.6.exe
File size:
3 MB
Operating System:Microsoft Windows
Requirements:Windows 10 32/64 bit
Windows 8 32/64 bit
Windows 7 32/64 bit
Windows Vista 32/64 bit
Windows XP 32/64 bit
Updated on:November 25, 2021
Downloaded:2,950 times
License:MS-PL
Developer:Greg Galloway

Overview:

OLAP PivotTable Extensions is a useful Excel add-in that enables users to define custom calculated measures, insert pivot tables, generate graphs and more. While the add-in provides some of its functions in the interface, take note that there are extra options available in the API. Some examples in this sense would be configuring default settings, searching cubes and filtering to a list to the clipboard.
Regardless of the calculations users intend to perform, all defined operations are included in a dedicated library. Therefore, users can pick up any past calculations used from a dedicated menu. It goes without saying that the library supports import, export and delete.
The add-in includes a limitation when it comes with adding private calculated members as part of the Analysis Service cube. Simply put, the utility does not feature a built-in UI to define MDX calculations and the calculations need to be operated on the visible part, as otherwise there is a risk that the data is wiped out.
On a side note, for the first limitation, take note that Excel 2013 includes the graphic interface for building MDX calculations. In the eventuality that the add-in is performing poorly, then troubleshooting the MDX query might be a solution.

Click to rate this App!

More Apps

Leave a Reply

Your email address will not be published.