OLAP PivotTable Extensions

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. 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.