Excel Cube Functions

FUNCTIONSYNTAX
CUBEKPIMEMBERCUBEKPIMEMBER(connection, kpi_nam, kpi_property, caption)
CUBEMEMBERCUBEMEMBER(connection, member_expression, caption)
CUBEVALUECUBEVALUE(connection, member_expression1, member_expression2…)
CUBEMEMBERPROPERTYCUBEMEMBERPROPERTY(connection, member_expression, property
CUBESETCUBESET(connection, set_expression,
caption, sort_order, sort_by)
CUBERANKEDMEMBERCUBERANKEDMEMBER(connection, set_expression, rank,caption)
CUBESETCOUNTCUBESETCOUNT(set)