Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

Lead

Returns the member that is a specified number of positions following a specified member along the dimension of the member.

Syntax

«Member».Lead(«Numeric Expression»)

Remarks

Member positions in the dimension are determined by the dimension's natural order. The numbering of the positions is zero-based.

If «Numeric Expression» is zero, «Member» is returned. If «Numeric Expression» is negative, a prior member is returned.

Lead(1) is equivalent to NextMember. Lead(-1) is equivalent to PrevMember.

The «Member».Lag function is similar, except that it looks in the opposite direction. Lead(n) is equivalent to Lag(-n).

Example

If the levels in the Time dimension include Year and Month, the following example returns [1995].February:

[1994].November.Lead(3)