OLAP PivotTable Extensions OLAP PivotTable Extensions
winget install --id=GregGalloway.OLAPPivotTableExtensions -e OLAP PivotTable Extensions is an Excel add-in which extends the functionality of PivotTables on all types Analysis Services cubes. It supports Analysis Services Tabular, Analysis Services Multidimensional, Azure Analysis Services, and Power BI (both Analyze in Excel and the XMLA endpoint). The Excel API has certain PivotTable functionality which is not exposed in the UI. OLAP PivotTable Extensions provides an interface for some of this functionality. It also adds some new features like searching cubes, configuring default settings, and filtering to a list in your clipboard. The add-in can be launched from the menu option in the right-click menu for PivotTables.
OLAP PivotTable Extensions is an Excel add-in designed to enhance the functionality of PivotTables when working with Analysis Services cubes. It supports a wide range of cube types, including Analysis Services Tabular, Multidimensional, Azure Analysis Services, and Power BI (via Analyze in Excel or XMLA endpoint). The add-in provides advanced features to streamline data analysis and improve efficiency.
Key Features:
- Support for Multiple Cube Types: Works seamlessly with various Analysis Services cubes, enabling consistent functionality across different platforms.
- Private Calculated Members: Allows users to define custom MDX calculations that are specific to individual PivotTables, ensuring flexibility without cluttering server-side cube definitions.
- MDX Query Insights: Reveals the underlying MDX query used by a PivotTable, helping administrators troubleshoot performance or accuracy issues.
- Filtering to Clipboard List: Enables quick filtering of PivotTables based on lists copied from the clipboard, saving time during data exploration.
- Search Functionality: Text search capabilities for fields and dimension members, making it easier to locate specific data within large cubes.
- Default Settings Configuration: Simplifies the process of setting consistent display preferences across new PivotTables, reducing manual adjustments.