Lead

Using the order of members existing in a database outline, returns a member that is n steps past a given member, along the same generation or level (as defined by layertype).

Syntax

member.Lead (index [,layertype ] )

OR

Lead ( member, index )

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.

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.

Examples

The following expression:

[Jan].lead (11)

returns the member that is 11 steps past Jan:

[Dec]

The following expression:

[Dec].lead (-11)

returns the member that is 11 steps prior to Dec:

[Jan]

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

This query returns the grid:

Actual Budget
Marketing Expected Sales in Next Month
Jan 5223 30000
Feb 5289 30200
Mar 5327 30830
Apr 5421 31510
May 5530 32900
Jun 5765 33870
Jul 5985 33820
Aug 6046 31000
Sep 5491 29110
Oct 5388 29540
Nov 5263 30820
Dec 5509 #Missing

See Also

.LAG, which is the reverse of .LEAD.
.NEXTMEMBER, which is the same as .LEAD(1).

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com