OLAP PivotTable Extensions

OLAP PivotTable Extensions is a handy Excel add-in that lets you create custom calculations, set up pivot tables, and even make graphs. It's pretty cool because while you can access some features directly in the interface, there’s also an API with extra options. You can configure default settings, search through cubes, and even copy filtered lists right to your clipboard!

Easy Access to Your Calculations

No matter what calculations you're working on, all your defined operations are stored in a special library. This means you can easily find past calculations from a menu whenever you need them. Plus, this library supports importing and exporting, so managing your data is super straightforward.

A Few Limitations to Keep in Mind

However, there are some limitations when it comes to adding private calculated members as part of the Analysis Service cube. Basically, the add-in doesn’t have a built-in user interface for defining MDX calculations. This means that any calculations have to be done on the visible part; otherwise, there's a risk of losing data.

Troubleshooting Tips

On another note, if you're using Excel 2013 and run into issues with creating MDX calculations, don’t worry! It actually has a graphic interface that can help you build those calculations more easily. And if things aren’t going smoothly with the add-in itself, checking out the MDX query could be your best bet for troubleshooting.