The Hierarchy dot
function returns the hierarchy to which the specified level or member
belongs. You can have multiple hierarchies for one dimension.
Returns: A hierarchy.
Parameters
- LevelExpression
- Specifies the level whose hierarchy is to be returned.
- MemberExpression
- Specifies the member whose hierarchy is to be returned.
Example
The following example shows how to use the Hierarchy function to return the sales amount for the members of the hierarchy to which the All Stores member belongs.
Query
SELECT
{[Price Analysis].[Measures].[Sales Amount]} ON AXIS(0)
, {[Price Analysis].[Store].[All Stores].Hierarchy.Members} ON AXIS(1)
FROM [Price Analysis]
Result
| Store | Sales amount |
|---|---|
| All Stores | 2719121.06 |
| Subdivision 1A | 1423778.49 |
| Region 44 | 872423.17 |
| District 38 | 413491.11 |
| ValueTrend Store 554 | 184520.49 |
| ValueTrend Store 782 | 228970.62 |
| District 84 | 458932.06 |
| ValueTrend Store 1414 | 267831.59 |
| ValueTrend Store 835 | 191100.47 |
| Region 45 | 551355.32 |
| District 127 | 551355.32 |
| ValueTrend Store 1095 | 270316.39 |
| ValueTrend Store 1199 | 281038.93 |
| Subdivision 1B | 1295342.57 |
| Region 22 | 520386.42 |
| District 477 | 520386.42 |
| ValueTrend Store 116 | 271528.06 |
| ValueTrend Store 278 | 248858.36 |
| Region 24 | 774956.15 |
| District 226 | 518498.97 |
| ValueTrend Store 375 | 257877.78 |
| ValueTrend Store 681 | 260621.19 |
| District 490 | 256457.18 |
| ValueTrend Store 875 | 256457.18 |