OLAP Server User Guide
MDX Documentation
MDX Functions Reference

LastPeriods

(MDX)

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

Parameters

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

Return

set

Description

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

Examples

Special Examples (errors, null, ...)

XMLA Properties

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