Skip to content

Commit 74b0a7a

Browse files
authored
Update hierarchy-mdx.md
Perhaps it should say Date dimension instead of Data.
1 parent 44870c9 commit 74b0a7a

1 file changed

Lines changed: 38 additions & 38 deletions

File tree

docs/mdx/hierarchy-mdx.md

Lines changed: 38 additions & 38 deletions
Original file line numberDiff line numberDiff line change
@@ -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

Comments
 (0)