OLAP PivotTable Extensions icon

OLAP PivotTable Extensions

  n/a
Certified 100% FREE MS-PL   

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  

Description

changelog

Free Download

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

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
Read the full changelog
User Comments
This enables Disqus, Inc. to process some of your data. Disqus privacy policy

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
  1 screenshot:
OLAP PivotTable Extensions - With the help of OLAP PivotTable Extensions you are able to calculate graphs and insert pivot tables
  main category:
Office tools
  developer:
  visit homepage