Advanced Excel - Cube Functions
The Excel Cube functions enable data from OLAP cubes to be brought into Excel to perform calculations. These functions are supported with a connection to Microsoft SQL Server 2005 Analysis Services or later data source.
As PowerPivot creates a data source, which is compatible with OLAP cubes, it can also be used with these functions.
The following table lists all the Cube functions −
|S.No.||Function and Description|
Returns a key performance indicator name, property, and measure, and displays the name and property in the cell.
Returns a member or tuple in a cube hierarchy.
Returns the value of a member property in the cube.
Returns the nth, or ranked, member in a set.
Defines a calculated set of members or tuples by sending a set expression to the cube on the server.
Returns the number of items in a set.
Returns an aggregated value from a cube.