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).
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 .
|
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.
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 |
.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 |