Skip to main content
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Cube functions (reference)
Click one of the links in the following list to see detailed help about the 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.
Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube.
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.
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.
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.
Returns the number of items in a set.
Returns an aggregated value from the cube.
Excel 2010, Excel Web App, SharePoint Online for enterprises, SharePoint Online for professionals and small businesses