OLAP Server User Guide
MDX Documentation
MDX Functions Reference



Returns the members that stand before the specified member including the specified member itself within the level members.


Name Type Cardinality Default value
index  numeric-expression  one   
  member-expression  one   




This function returns the (index-1) members that are before the specified member including the member itself within the list of members of the level of the specified member.

a) if the index is positive, returns { member.lag(index), member.lag(index-1),... member}
b) if the index is negative, returns {member, member.lead(1),... member.lead(-index) }

If the index is 0, an empty set is returned.

See Also

Lag Lead


Special Examples (errors, null, ...)

XMLA Properties

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