Returns the next member from the level members list. Same as lag(-index).
In our example, return the second member of the [Continent] level.
Query
[Geography].[Geo].[Continent].members(0).Lead(1)
Result
{
[Geography].[Geo].[Continent].[Europe]
}
Assertion : MDX Equals
[Geography].[Geo].[Continent].members(0).NextMember
Assertion : MDX Equals
[Geography].[Geo].[Continent].members(0).lag(-1)
Assertion : MDX Equals
[Geography].[Geo].[Continent].members(0 + 1)
If the number of position is negative, returns a previous member from the level members list.
In our example, return the second member of the [Country] level.
Query
[Geography].[Geo].[Country].members(3).Lead(-2)
Result
{
[Geography].[Geo].[Country].[Mexico]
}
Assertion : MDX Equals
[Geography].[Geo].[Country].members(3 + (-2))
Assertion : MDX Equals
[Geography].[Geo].[Country].members(3).Lag(+2)
Assertion : MDX Equals
[Geography].[Geo].[Country].members(3 - 2)
Returns a NULL member if the resulting index is out of bounds. Less than zero or greater than the level number of members.
Query
[Geography].[Geo].[Continent].[America].Lead(1024)
Result
Assertion : MDX Equals
[Geography].[Geo].[Continent].[America].Lead(-1024)
Assertion : MDX Equals
Equivalent [Hierarchy].DefaultMember.Lead(index).
Query
[Geography].[Geo].Lead(0)
Result
{
[Geography].[Geo].[All Regions]
}
Assertion : MDX Equals
[Geography].[Geo].DefaultMember