Analysis Services
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)