fbpx

Lead (MDX)

Returns the member that is at the specified number of positions after the specified member along its level.

Parameters

Name Type Cardinality Default value
  numeric-expression  one   

Return

member

Description

This function allows for 'traveling' forwards in the members' level hierarchy member's list.

The following holds true : Lead(1) = nextMember = Lead(-1).

If the number of specified position is out of bounds, the function returns the null member.

Equivalent to lag(-index)

See Also

Lag PrevMember NextMember

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.