OLAP Server User Guide
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: 3.0.3 03-Mar-2013 14:06:07 GMT