Syntax

member.Lead (index [,layertype ] [, hierarchy ])

or

Lead ( member, index [, hierarchy ] )

Parameters

member

The starting member from which .LEAD counts a given number of following members.

index

A number n representing how many steps away from <member> to count.

layertype

GENERATION or LEVEL.

hierarchy

Optional. A specific hierarchy within the time dimension.

Notes

• If the member specified by the Lead function does not exist, the result is an empty member. For example, using Sample Basic, [Jun].lead (12) returns an empty member.

• When multiple hierarchies are enabled, this function returns NULL when the source member is in one hierarchy and the result member belongs to a different hierarchy.

Examples

The following expression returns [Dec], which is 11 steps past Jan:

[Jan].lead (11)

The following expression returns [Jan], which is 11 steps prior to Dec:

[Dec].lead (-11)

For every month, the following query displays the marketing expenses and budgeted sales for the next month:

WITH MEMBER
 [Measures].[Expected Sales in Next month]
AS
 '([Measures].[Sales], [Year].CurrentMember.Lead(1))'
SELECT
 { 
  ([Scenario].[Actual], [Measures].[Marketing]),
  ([Scenario].[Budget], [Measures].[Expected Sales in Next month])
 } 
ON COLUMNS,
[Year].Levels(0).Members 
ON ROWS
FROM Sample.Basic

The above query returns the following output:

See Also

Lag

NextMember