What is CUBESET?
Defines a calculated set of members from an OLAP cube. Groups members for aggregation.
Syntax
=CUBESET(connection, set_expression, [caption], [sort_order], [sort_by])
Example
Formula: =CUBESET(\
Result: Set of categories
How It Works
Creates a named set of cube members that can be used in CUBEVALUE or other analysis.