Written by Returns the count of items within a given set.
Creates a calculated set of members or tuples by sending a set expression to the server’s cube, which generates the set and subsequently relays that set to Microsoft Office Excel.
Returns the nth ranked member from a set, useful for identifying top performers, like sales leaders or highest achievers in a list.
Retrieves the value of a specific member property from a cube, confirming the existence of a member name and returning the designated property for that member.
Retrieves a member or tuple from a cube hierarchy, confirming its presence within the cube.
Returns a key performance indicator (KPI) name along with its properties and measures, presenting the name and properties directly in the cell. KPIs are quantifiable metrics that gauge the effectiveness of an organization, such as monthly revenues or annual employee retention rates.