GetLastDate

The MDX GetLastDate function returns the end date for an Essbase date-time dimension member in an aggregate storage (ASO) cube.

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, 2024:

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