Excel Cube Formulas
Functions for extracting data from OLAP (Online Analytical Processing) cubes.
7 formulas
0 Beginner
0 Intermediate
7 Advanced
CUBEKPIMEMBER
Advanced
=CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])CUBEMEMBER
Advanced
=CUBEMEMBER(connection, member_expression, [caption])CUBEMEMBERPROPERTY
Advanced
=CUBEMEMBERPROPERTY(connection, member_expression, property)CUBERANKEDMEMBER
Advanced
=CUBERANKEDMEMBER(connection, set_expression, rank, [caption])CUBESET
Advanced
=CUBESET(connection, set_expression, [caption], [sort_order], [sort_by])CUBESETCOUNT
Advanced
=CUBESETCOUNT(set)CUBEVALUE
Advanced
=CUBEVALUE(connection, [member_expression1], [member_expression2], ...)