Important
The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.
Click one of the links in the following list to see detailed help about the function.
| Function | Description |
|---|---|
| CUBEKPIMEMBER function | Returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization's performance. |
| CUBEMEMBER function | Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube. |
| CUBEMEMBERPROPERTY function | Returns the value of a member property from the cube. Use to validate that a member name exists within the cube and to return the specified property for this member. |
| CUBERANKEDMEMBER function | Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or the top 10 students. |
| CUBESET function | Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Excel. |
| CUBESETCOUNT function | Returns the number of items in a set. |
| CUBEVALUE function | Returns an aggregated value from the cube. |