Lead

The Lead function returns a member that is n steps past a given member, along the same generation or level (as defined by layertype).

Syntax

Lead ( member, index [, hierarchy ] )

Arguments

member

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

index

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

layertype

GENERATION or LEVEL.

hierarchy

Optional. A specific hierarchy within the time dimension.

Notes

Examples


select
{
[Service Type].[ALL].[Business Suite],
( Lag ([Service Type].[ALL].[Business Suite], 0) ),
( Lead([Service Type].[ALL].[Business Suite], 0) )
} on rows,
{
[Aircraft Type].[ALL].Boeing.[Boeing 747],
[Aircraft Type].[ALL].Boeing.[Boeing 777],
[Aircraft Type].[ALL].Boeing.[Boeing 787 Dreamliner]
} on columns
from [Airline Turnover];

	Boeing 747	Boeing 777	Boeing 787 Dreamliner
Business Suite	196776143	289485211	351238403
Business Suite	196776143	289485211	351238403
Business Suite	196776143	289485211	351238403