Cube
OLAP cube functions allow to analyze data from multiple perspectives. Read more in https://en.wikipedia.org/wiki/OLAP_cube
CUBEKPIMEMBER
CUBEKPIMEMBER(connection, kpi_name, kpi_property, ...)
CUBEMEMBER
CUBEMEMBER(connection, member_expression, ...)
CUBEMEMBERPROPERTY
CUBEMEMBERPROPERTY(connection, member_expression, property)
CUBERANKEDMEMBER
CUBERANKEDMEMBER(connection, set_expression, rank, ...)
CUBESET
CUBESET(connection, set_expression, ...)
CUBESETCOUNT
CUBESETCOUNT(set)
CUBEVALUE
CUBEVALUE(connection, [member_expression], ...)
CUBEKPIMEMBER
CUBEKPIMEMBER(connection, kpi_name, kpi_property, ...)
CUBEMEMBER
CUBEMEMBER(connection, member_expression, ...)
CUBEMEMBERPROPERTY
CUBEMEMBERPROPERTY(connection, member_expression, property)
CUBERANKEDMEMBER
CUBERANKEDMEMBER(connection, set_expression, rank, ...)
CUBESET
CUBESET(connection, set_expression, ...)
CUBESETCOUNT
CUBESETCOUNT(set)
CUBEVALUE
CUBEVALUE(connection, [member_expression], ...)