Microsoft Office Tutorials and References
In Depth Information
The CUBERANKEDMEMBER() function returns the nth, or ranked, member in a
set. You can use it to return one or more elements in a set, such as the top
sales performer or top 10 students.
The 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. The
function then returns that set to Excel. You can use CUBESET() to build dy-
namic reports that aggregate and filter data by using the return value as a
slicer in the CUBEVALUE() function, the CUBERANKEDMEMBER() function to
choose specific members from the calculated set, and the CUBESETCOUNT()
function to control the size of the set.
The CUBESETCOUNT() function returns the number of items in a set.
The CUBEVALUE() function returns an aggregated value from a cube.
The CUBEKPIMEMBER() function returns a key performance indicator (KPI)
name, property, and measure, and it displays the name and property in the
cell. A KPI is a quantifiable measurement, such as monthly gross profit or
quarterly employee turnover, used to monitor an organization ’ s perform-
To use this function, you must have SQL Server Analysis Services
2005 or later.