HIERARCHIZE
This documentation is for Kyvos 2026.3.x. To view documentation for other Kyvos versions, click here. |
|---|
Description:
It is used to order the members of a set in a hierarchy.
Syntax:
Hierarchize(Set_Expression [ , POST ])
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Example:
select [Measures].[Internet Average Sales Amount] on columns,
hierarchize(ascendants([Customer].[Geography].[City].&[Australia]&[New South Wales]&[Lane Cove]))
on 1
from [AdventureWorksMF]