GetLastDate

The MDX GetLastDate function returns the end date for an Essbase date-time dimension member.

Syntax

GetLastDate ( member )

Parameters

member

A member from a date-time tagged dimension.

Notes

• This function returns #MISSING if the input member is not from a date hierarchy in a Time-Date tagged dimension.

• The return value is a number representing the input date. The number is the number of seconds elapsed since midnight, January 1, 1970.

• This function is applicable only to aggregate storage databases.

Example

The following query returns sales for the last week of April, 2004.

SELECT 
 {[Sales]}
ON COLUMNS,
 {DateToMember(
     GetLastDate ([Apr 2004]), 
         [Time dimension].Dimension, 
         [Time dimension].[Weeks]
  )}
ON ROWS
FROM MySamp.basic;