Extends the functionality of PivotTables on Analysis Services cubes and helps you create a library that features all the calculations you used. #Pivot Table #Excel Add-in #Cube Analysis #Table #Graph #OLAP
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.
System requirements
- Excel 2013 or Excel 2016 is required
- NET Framework version 4.5.2
- Access to a cube on an Analysis Services server is required.
What's new in OLAP PivotTable Extensions 0.9.7:
- New Features:
- Upgraded to latest ADOMD.NET driver and forced TLS1.2 which fixed support for:
- Azure Analysis Services
- Power BI Analyze in Excel
OLAP PivotTable Extensions 0.9.7
add to watchlist add to download basket send us an update REPORT- PRICE: Free
- runs on:
-
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 - file size:
- 3.6 MB
- filename:
- OLAP.PivotTable.Extensions.Setup.v0.9.7.exe
- main category:
- Office tools
- developer:
- visit homepage