Today

The MDX Today function returns a number representing the current date on the Essbase server computer. This number can be used as input to date-processing functions.

Syntax

Today

Notes

The returned number is a representation of date based on the number of seconds elapsed since midnight, January 1, 1970. The return value can be used as input to other functions listed in the See Also section.

Example

This query returns today's actual sales for the product Cola in the market California. Today() returns today's date. StrToMbr retrieves the day member represented by the date returned by Today.

SELECT
 {[Sales]} 
ON COLUMNS,
 {
  StrToMbr(
        FormatDate( Today(), "Mon dd yyyy")
   )
 } 
ON ROWS
FROM Mysamp.basic;