Cube Functions

Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell

(connection,kpi_name, kpi_property,caption)

Returns a member or tuple in a cube hierarchy; use to validate that the member or tuple exists in the cube

(connection, member_expression, caption)

Returns the value of a member property in the cube; use to validate that a member name exists within the cube and to return the specified property for this member

(connection, member_expression, property)

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 top 10 students

(connection, set_expression,rank, caption)

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

(set)

Returns the number of items in a set

(set)

Returns an aggregated value from a cube

(connection, member_expression1, member_expression2...)