| 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 Office Excel. |
| CUBESETCOUNT function |
Returns the number of items in a set. |
| CUBEVALUE function |
Returns an aggregated value from the cube. |
Post a Comment
Blogger FacebookYour Comment Will be Show after Approval , Thanks