An MDX Question?
OLAP Server User Guide
Configuring icCube
Running icCube
Migrating icCube
Security
Creating Schemas/Cubes
Working with icCube
Reporting Tools Integration
Embedding icCube
Plugins/Extensions
Web Reporting
Installation
Local Settings
Visualization Library
Tutorials
Demos
MDX Documentation
MDX Tutorial (Gentle Introduction)
MDX Functions Reference
MDX Language Reference
Reference
icCube Client Library
XMLA Client Library
Lag (standard MDX)

Returns the member that is at the specified number of positions before the specified member along its level.

Parameters

Name Type Cardinality Default value
  numeric-expression  one   

Return

member

Description

This function allows for 'traveling' backwards in the members' level hierarchy member's list.

The following holds true : Lag(1) = prevMember = Lead(-1).

If the number of specified position is out of bounds, the function returns the null member.

Equivalent to lead(-index)

See Also

Lead PrevMember NextMember

Examples

member.Lag(index)
member.Lag(-1)
member.Lag(index) - out of bounds
hierarchy.Lag(index)

Special Examples (errors, null, ...)

dimension.Lag(index) - dimension with multiple hierarchies
tuple.Lag
level.Lag
memberSet.Lag
tupleSet.Lag
string.Lag

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.

icCube OLAP version: 2.5.1 13-May-2012 02:21:10 GMT