Returns a tuple with the ALL or the default member for all hierarchies of the cube.
Query
Result
{
( [Geography].[Geo].[All Regions], [Geography].[Economy].[ALL], [Geography].[Letter].[All Letters], [Product].[Prod].[Company].[Crazy Development], [Time].[Calendar].[Year].[2010], [Currency].[Currency].[World], [Stats].[Stats-Dim].[L-Stats-Dim].&[Value], [Stats].[Stats-MA].[L-Stats-MA].&[Value], [Stats].[Stats-Time].[L-Stats-Time].&[Value], [Calendar].[Calendar].[All-M], [Measures].[Amount] )
}
Assertion : MDX Equals
{(
[Geography].[Geo].DefaultMember,
[Geography].[Economy].DefaultMember,
[Geography].[Letter].DefaultMember,
[Product].[Prod].DefaultMember,
[Time].[Calendar].DefaultMember,
[Currency].[Currency].DefaultMember,
[Stats].[Stats-Dim].DefaultMember,
[Stats].[Stats-MA].DefaultMember,
[Stats].[Stats-Time].DefaultMember,
[Calendar].[Calendar].DefaultMember,
[Measures].DefaultMember
)}
Returns a tuple with the ALL or the default member for all hierarchies of the specified dimension.
Query
Result
{
( [Geography].[Geo].[All Regions], [Geography].[Economy].[ALL], [Geography].[Letter].[All Letters] )
}
Assertion : MDX Equals
{([Geography].[Geo].defaultMember,[Geography].[Economy].defaultMember,[Geography].[Letter].defaultMember)}
Returns a tuple with the ALL or the default member for all hierarchies of the specified hierarchy's dimension.
Query
Root( [Geography].[Geo] )
Result
{
( [Geography].[Geo].[All Regions], [Geography].[Economy].[ALL], [Geography].[Letter].[All Letters] )
}
Assertion : MDX Equals
{([Geography].[Geo].defaultMember,[Geography].[Economy].defaultMember,[Geography].[Letter].defaultMember)}
Returns a tuple completed with the with the ALL or the default member of the missing hierarchies.
In our example, the tuple ([Geography].[Geo].[Europe],[Product].[icCube].[Personal]) is completed with [Geography].[Economy].defaultMember and [Geography].[Letter].defaultMember.
Query
Root( ([Geography].[Geo].[Europe],[Product].[icCube].[Personal]) )
Result
{
( [Geography].[Geo].[Continent].[Europe], [Geography].[Economy].[ALL], [Geography].[Letter].[All Letters], [Product].[Prod].[Licence].[Personal] )
}
Assertion : MDX Equals
{([Geography].[Geo].[Europe],[Geography].[Economy].defaultMember,[Geography].[Letter].defaultMember,[Product].[icCube].[Personal])}
Returns a tuple completed with the missing hierarchies.
In our example, the member [Geography].[Geo].[Europe] is completed with [Geography].[Economy].defaultMember and [Geography].[Letter].defaultMember.
Query
Root( [Geography].[Geo].[Europe] )
Result
{
( [Geography].[Geo].[Continent].[Europe], [Geography].[Economy].[ALL], [Geography].[Letter].[All Letters] )
}
Assertion : MDX Equals
{([Geography].[Geo].[Europe],[Geography].[Economy].defaultMember,[Geography].[Letter].defaultMember)}