CUBESET

Definition: CUBESET is a function that returns a set or tuple from an OLAP cube.

Syntax: =CUBESET(connection, set_expression)

Situation: This formula is suitable when you need to retrieve a set or tuple from an OLAP cube.

Example: If you have an OLAP cube connected to Excel and want to retrieve a set named “Top 10 Customers”, the formula =CUBESET(connection, “{Top 10 Customers}”) can be used.