Returns the members of the level in their natural order (i.e., hierarchized).
Query
[Geography].[Geo].[Country].Members
Result
{
[Geography].[Geo].[Country].[Canada],
[Geography].[Geo].[Country].[Mexico],
[Geography].[Geo].[Country].[United States],
[Geography].[Geo].[Country].[Venezuela],
[Geography].[Geo].[Country].[France],
[Geography].[Geo].[Country].[Spain],
[Geography].[Geo].[Country].[Switzerland]
}
Assertion : MDX Equals
Generate( [Geography].[Geo].[Continent].members, [Geography].[Geo].currentMember.children )
Assertion : MDX Equals
Hierarchize( [Geography].[Geo].[Country].members )
Returns the members of the hierarchy in their natural order (i.e., hierarchized).
Query
[Geography].[Geo].Members
Result
{
[Geography].[Geo].[All Regions],
[Geography].[Geo].[Continent].[America],
[Geography].[Geo].[Country].[Canada],
[Geography].[Geo].[City].[Quebec],
[Geography].[Geo].[City].[Toronto],
[Geography].[Geo].[Country].[Mexico],
[Geography].[Geo].[City].[Mexico],
[Geography].[Geo].[Country].[United States],
[Geography].[Geo].[City].[Los Angeles],
[Geography].[Geo].[City].[New York],
[Geography].[Geo].[City].[San Francisco],
[Geography].[Geo].[Country].[Venezuela],
[Geography].[Geo].[City].[Caracas],
[Geography].[Geo].[Continent].[Europe],
[Geography].[Geo].[Country].[France],
[Geography].[Geo].[City].[Paris],
[Geography].[Geo].[Country].[Spain],
[Geography].[Geo].[City].[Barcelona],
[Geography].[Geo].[City].[Madrid],
[Geography].[Geo].[City].[Valencia],
[Geography].[Geo].[Country].[Switzerland],
[Geography].[Geo].[City].[Geneva],
[Geography].[Geo].[City].[Lausanne],
[Geography].[Geo].[City].[Zurich]
}
Assertion : MDX Equals
// This is the natural order :-)
{ [Geography].[Geo].[All Regions] } +
Generate( [Geography].[Geo].[Continent].members, [Geography].[Geo].currentMember + // continent
Generate( [Geography].[Geo].currentMember.children, [Geography].[Geo].currentMember + // country
[Geography].[Geo].currentMember.children)) // city
Assertion : MDX Equals
Hierarchize( [Geography].[Geo].members )
Members on a dimension with a single hierarchy return the same as the method members on this single hierarchy
Query
Result
{
[Measures].[Amount],
[Measures].[Amount-Min],
[Measures].[Amount-Max],
[Measures].[Amount-Count],
[Measures].[Amount-AvgChildren],
[Measures].[Amount-None],
[Measures].[Amount-Open],
[Measures].[Amount-Close],
[Measures].[Amount-OpenNoEmpty],
[Measures].[Amount-CloseNoEmpty],
[Measures].[Amount-AvgLeaves],
[Measures].[Amount-NoEmpty],
[Measures].[Amount-Unique],
[Measures].[Fx]
}
Assertion : MDX Equals
[Measures].[Measures].members