LastPeriods

The MDX LastPeriods function for Essbase returns a set of members ending either at the specified member or at the current member in the Time dimension.

Syntax

LastPeriods ( numeric value expression [, member [, hierarchy ] ] )

Parameters

numeric value expression: The number of members to return (see MDX Grammar Rules). If negative, member is treated as the starting point.
member: Optional. A member expression.
hierarchy: Optional. A specific hierarchy within the time dimension.

Example

Lastperiods(3, Apr) returns the set {Feb, Mar, Apr}.

Lastperiods(-3, Apr) returns the set {Apr, May, Jun}.

Lastperiods(1, Apr) returns a set of one member: {Apr}.

Lastperiods(0, Apr) returns an empty set.

Lastperiods(5, Apr) returns the set {Jan, Feb, Mar, Apr}. Note that the output set has only four members.

The following query:

WITH MEMBER
 [Measures].[Rolling Sales] AS 
'Avg  (
 LastPeriods 
    (3, [Year].Currentmember
    ), 
 [Measures].[Sales]
 )'
SELECT
 {[Measures].[Sales], [Measures].[Rolling Sales]}
ON COLUMNS, 
 Descendants ([Year].[Qtr2])
ON ROWS
FROM Sample.Basic
WHERE [Product].[Root Beer]

returns the grid:

Table 4-104 Output Grid from MDX Example

(axis)	Sales	Rolling Sales
Qtr2	27401	27014
Apr	8969	8960
May	9071	8997
Jun	9361	9133.667