Lead (MDX)

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

NULL

Assertion : MDX Equals

[Geography].[Geo].[Continent].[America].Lead(-1024)

Assertion : MDX Equals

NULL.Lead(1)

Equivalent [Hierarchy].DefaultMember.Lead(index).

Query

[Geography].[Geo].Lead(0)

Result

{ 
  [Geography].[Geo].[All Regions]
}

Assertion : MDX Equals

[Geography].[Geo].DefaultMember

Lead cannot be applied to a dimension with multiple hierarchies.

Query

[Geography].Lead(1)

Result

Error Code    : OLAP_FUNCTION_DIMENSION_WITH_MORE_THAN_ONE_HIERARCHY
Error Message : Lead() : the '[Geography]' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified.

Using invalid parameter type causes an error.

Query

([Geography].[Geo].[Spain],[Product].[Licence].[Personal]).Lead(1)

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : Lead() : argument (0) type mismatch: expected:'member', got:'tuple'

Using invalid parameter type causes an error.

Query

[Geography].[Geo].[Continent].Lead(1)

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : Lead() : argument (0) type mismatch: expected:'member', got:'level'

Using invalid parameter type causes an error.

Query

{[Geography].[Geo].[United States],[Geography].[Geo].[Switzerland],[Geography].[Geo].[Spain]}.Lead(1)

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : Lead() : argument (0) type mismatch: expected:'member', got:'set'

Using invalid parameter type causes an error.

Query

{([Geography].[Geo].[United States],[Product].[Licence].[Personal]),([Geography].[Geo].[Spain],[Product].[Licence].[Personal])}.Lead(1)

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : Lead() : argument (0) type mismatch: expected:'member', got:'set'

Using invalid parameter type causes an error.

Query

"hello".Lead(1)

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : Lead() : argument (0) type mismatch: expected:'member', got:'string'