The Description dot
function returns the name of the hierarchy, level, or member expression
to which it is affixed.
Returns: A string.
Syntax
>>-+-HierarchyExpression-+--.--Description--------------------->< +-LevelExpression-----+ '-MemberExpression----'
Parameters
- HierarchyExpression
- Specifies the hierarchy whose name is to be returned.
- LevelExpression
- Specifies the level whose name is to be returned.
- MemberExpression
- Specifies the member whose name is to be returned.
Example
The following example uses the Description function to retrieve the name of the hierarchy, level, and member of the members of the Store hierarchy.
Query
WITH
MEMBER [Price Analysis].[Measures].[Hierarchy]
AS [Price Analysis].[Store].CurrentMember.Hierarchy.Description
MEMBER [Price Analysis].[Measures].[Level]
AS [Price Analysis].[Store].CurrentMember.Level.Description
MEMBER [Price Analysis].[Measures].[Member]
AS [Price Analysis].[Store].CurrentMember.Description
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 | Hierarchy | Level | Member |
|---|---|---|---|
| All Stores | Store | (All) | All Stores |
| Subdivision 1A | Store | Organization Unit Sub Division Level | Subdivision 1A |
| Region 44 | Store | Organization Unit Region Level | Region 44 |
| District 38 | Store | Organization Unit District Level | District 38 |
| ValueTrend Store 554 | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 554 |
| ValueTrend Store 782 | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 782 |
| District 84 | Store | Organization Unit District Level | District 84 |
| ValueTrend Store 1414 | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 1414 |
| ValueTrend Store 835 | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 835 |
| Region 45 | Store | Organization Unit Region Level | Region 45 |
| District 127 | Store | Organization Unit District Level | District 127 |
| ValueTrend Store 1095 | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 1095 |
| ValueTrend Store 1199 | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 1199 |
| Subdivision 1B | Store | Organization Unit Sub Division Level | Subdivision 1B |
| Region 22 | Store | Organization Unit Region Level | Region 22 |
| District 477 | Store | Organization Unit District Level | District 477 |
| ValueTrend Store 116 | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 116 |
| ValueTrend Store 278 | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 278 |
| Region 24 | Store | Organization Unit Region Level | Region 24 |
| District 226 | Store | Organization Unit District Level | District 226 |
| ValueTrend Store 375 | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 375 |
| ValueTrend Store 681 | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 681 |
| District 490 | Store | Organization Unit District Level | District 490 |
| ValueTrend Store 875 | Store | Organization Unit Store Level (Price Analysis) | ValueTrend Store 875 |
Related functions
The Description dot function is an alias for the Name dot function.