CUBESET Function Explained
The CUBESET Function in Microsoft Excel is used to create a set of members or tuples by sending a set expression to the cube on an OLAP server. It returns a CUBESET object that can be used in other formulas. It takes three arguments: cube_name, set_expression, and slicer. The cube_name argument is the name of the cube to query. The set_expression argument is a set expression that defines the set of members or tuples to be returned. The slicer argument is an optional argument that is used to filter the set of members or tuples.
CUBESET Function Syntax
CUBESET("cube_name","set_expression","caption","description")
- cube_name: The name of the cube from which the set is to be created.
- set_expression: A valid Multidimensional Expressions (MDX) expression that defines the set.
- caption: A string expression that is used as the caption for the set.
- description: A string expression that is used as the description for the set.