LastPeriods

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 ] )

numeric value expression The number of members to return. If negative, member is treated as the starting point.
member Optional. A member expression.

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:

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

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com