ROOT
1. ROOT (Syntax: ROOT())
Description:
This function is used to return a tuple with the ALL or the default member from each hierarchy in the semantic model.
Syntax:
ROOT()
Return type:
TUPLE
Example:
SELECT {Root()} ON 0 FROM [Adventure Works]2. ROOT (Syntax: ROOT(Dimension_Expression))
Description:
The function is used to return a tuple with the ALL or the default member for all hierarchies of the specified hierarchy's dimension.
Syntax:
ROOT(Dimension_Expression)
Return type:
TUPLE
Parameters:
Parameter | Description |
|---|---|
Dimension_Expression | It is a valid MDX expression specifying a Dimension Expression. |
Example:
SELECT {Root([Date])} ON 0 FROM [Adventure Works]3. ROOT (Syntax: ROOT(Hierarchy_Expression))
Description:
This function is used to return a tuple with the ALL or the default member for all hierarchies of the specified hierarchy's dimension.
Syntax:
ROOT(Hierarchy_Expression)
Return type:
TUPLE
Parameters:
Parameter | Description |
|---|---|
Hierarchy_Expression | It is a valid MDX expression specifying a Hierarchy Expression. |
Example:
SELECT {Root([Date].[Year])} ON 0 FROM [Adventure Works]