@@ -24,42 +24,42 @@ manager: "erikre"
2424# Hierarchy (MDX)
2525[ !INCLUDE[ tsql-appliesto-ss2008-xxxx-xxxx-xxx_md] ( ../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md )]
2626
27- Returns the hierarchy that contains a specified member or level.
28-
29- ## Syntax
30-
31- ```
32-
33- Member expression syntax
34- Member_Expression.Hierarchy
35-
36- Level expression syntax
37- Level_Expression.Hierarchy
38- ```
39-
40- ## Arguments
41- * Member_Expression*
42- A valid Multidimensional Expressions (MDX) expression that returns a member.
43-
44- * Level_Expression*
45- A valid Multidimensional Expressions (MDX) expression that returns a level.
46-
47- ### Examples
48- The following example returns the name of the Calendar hierarchy in the Data dimension in the AdventureWorks cube.
49-
50- ` WITH `
51-
52- ` MEMBER Measures.HierarchyName as `
53-
54- ` [Date].[Calendar].Currentmember.Hierarchy.Name `
55-
56- ` SELECT {Measures.HierarchyName} ON 0, `
57-
58- ` {[Date].[Calendar].[All Periods]} ON 1 `
59-
60- ` FROM [Adventure Works] `
61-
62- ## See Also
63- [ MDX Function Reference ( ; MDX) ; ] ( ../mdx/mdx-function-reference-mdx.md )
64-
27+ Returns the hierarchy that contains a specified member or level.
28+
29+ ## Syntax
30+
31+ ```
32+
33+ Member expression syntax
34+ Member_Expression.Hierarchy
35+
36+ Level expression syntax
37+ Level_Expression.Hierarchy
38+ ```
39+
40+ ## Arguments
41+ * Member_Expression*
42+ A valid Multidimensional Expressions (MDX) expression that returns a member.
43+
44+ * Level_Expression*
45+ A valid Multidimensional Expressions (MDX) expression that returns a level.
46+
47+ ### Examples
48+ The following example returns the name of the Calendar hierarchy in the Date dimension in the AdventureWorks cube.
49+
50+ ` WITH `
51+
52+ ` MEMBER Measures.HierarchyName as `
53+
54+ ` [Date].[Calendar].Currentmember.Hierarchy.Name `
55+
56+ ` SELECT {Measures.HierarchyName} ON 0, `
57+
58+ ` {[Date].[Calendar].[All Periods]} ON 1 `
59+
60+ ` FROM [Adventure Works] `
61+
62+ ## See Also
63+ [ MDX Function Reference ( ; MDX) ; ] ( ../mdx/mdx-function-reference-mdx.md )
64+
6565
0 commit comments