Lag

Returns the member who specify the number of positions before the members are specified at the member level.

Syntax

Lag ( member, index [, hierarchy ] )

Arguments

member

The starting member from which .LAG counts to a given number of previous members.

index

A number n representing how many steps prior to member to count.

layertype

GENERATION or LEVEL. Generation is the default.

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