The Dimension dot
function returns the hierarchy to which the specified level or member
belongs. You can have multiple hierarchies for one dimension.
Returns: A dimension.
Parameters
- LevelExpression
- Specifies the level whose dimension is to be returned.
- MemberExpression
- Specifies the member whose dimension is to be returned.
Example
The following example uses the Dimension function to retrieve the name of the dimension, hierarchy, level, and member of the members of the Store dimension.
Query
WITH
MEMBER [Price Analysis].[Measures].[Dimension]
AS [Price Analysis].[Store].CurrentMember.Dimension.Name
MEMBER [Price Analysis].[Measures].[Hierarchy]
AS [Price Analysis].[Store].CurrentMember.Hierarchy.Name
MEMBER [Price Analysis].[Measures].[Level]
AS [Price Analysis].[Store].CurrentMember.Level.Name
MEMBER [Price Analysis].[Measures].[Member]
AS [Price Analysis].[Store].CurrentMember.Name
SELECT {[Price Analysis].[Measures].[Dimension],
[Price Analysis].[Measures].[Hierarchy],
[Price Analysis].[Measures].[Level], [Price Analysis].[Measures].[Member]}
ON AXIS(0),
{[Price Analysis].[Store].Members}
ON AXIS(1)
FROM [Price Analysis]
Result
| Store | Dimension | Hierarchy | Level | Member |
|---|---|---|---|---|
| All Stores | Store | Store | (All) | All Stores |
| Subdivision 1A | Store | Store | Organization Unit Sub Division Level | Subdivision 1A |
| Region 44 | Store | Store | Organization Unit Region Level | Region 44 |
| District 38 | Store | Store | Organization Unit District Level | District 38 |
| ValueTrend Store 554 | Store | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 554 |
| ValueTrend Store 782 | Store | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 782 |
| District 84 | Store | Store | Organization Unit District Level | District 84 |
| ValueTrend Store 1414 | Store | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 1414 |
| ValueTrend Store 835 | Store | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 835 |
| Region 45 | Store | Store | Organization Unit Region Level | Region 45 |
| District 127 | Store | Store | Organization Unit District Level | District 127 |
| ValueTrend Store 1095 | Store | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 1095 |
| ValueTrend Store 1199 | Store | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 1199 |
| Subdivision 1B | Store | Store | Organization Unit Sub Division Level | Subdivision 1B |
| Region 22 | Store | Store | Organization Unit Region Level | Region 22 |
| District 477 | Store | Store | Organization Unit District Level | District 477 |
| ValueTrend Store 116 | Store | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 116 |
| ValueTrend Store 278 | Store | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 278 |
| Region 24 | Store | Store | Organization Unit Region Level | Region 24 |
| District 226 | Store | Store | Organization Unit District Level | District 226 |
| ValueTrend Store 375 | Store | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 375 |
| ValueTrend Store 681 | Store | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 681 |
| District 490 | Store | Store | Organization Unit District Level | District 490 |
| ValueTrend Store 875 | Store | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 875 |