HIERARCHIZE
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 Sales Amount] ON COLUMNS,
Hierarchize({[Product].[Product Categories].[Mountain Bikes], [Product].[Product Categories].[Bikes],
[Product].[Product Categories].[Road Bikes]}) ON ROWS
FROM [AdventureWorksMF_ValueBased]