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 |