MDX Documentation
Lead (standard 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.

icCube OLAP version: 2.5.1 13-May-2012 02:21:10 GMT