Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Returns the hierarchy that contains a specified member or level.
Syntax
Member expression syntax
Member_Expression.Hierarchy
Level expression syntax
Level_Expression.Hierarchy
Arguments
Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.Level_Expression
A valid Multidimensional Expressions (MDX) expression that returns a level.
Examples
The following example returns the name of the Calendar hierarchy in the Data dimension in the AdventureWorks cube.
WITH
MEMBER Measures.HierarchyName as
[Date].[Calendar].Currentmember.Hierarchy.Name
SELECT {Measures.HierarchyName} ON 0,
{[Date].[Calendar].[All Periods]} ON 1
FROM [Adventure Works]