”;
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.
Cube Functions
The following table lists all the Cube functions −
| S.No. | Function and Description |
|---|---|
| 1 | CUBEKPIMEMBER
Returns a key performance indicator name, property, and measure, and displays the name and property in the cell. |
| 2 | CUBEMEMBER
Returns a member or tuple in a cube hierarchy. |
| 3 | CUBEMEMBERPROPERTY
Returns the value of a member property in the cube. |
| 4 | CUBERANKEDMEMBER
Returns the nth, or ranked, member in a set. |
| 5 | CUBESET
Defines a calculated set of members or tuples by sending a set expression to the cube on the server. |
| 6 | CUBESETCOUNT
Returns the number of items in a set. |
| 7 | CUBEVALUE
Returns an aggregated value from a cube. |
”;