Analyzing Time-Based Metrics with MDX

Table 202 lists the MDX functions that are provided for analysis of date hierarchies. For a complete description of these functions, see the Oracle Essbase Technical Reference.

Table 202. MDX Functions for Analyzing Date Hierarchies

Function

Description

DateDiff

Returns the difference between two input dates.

DatePart

Returns the date part (Year/Quarter/Month/Day/DayOfYear/Weekday) as a number.

DateRoll

To the given date, rolls (adds or subtracts) a number of specific time intervals, returning another date.

DateToMember

Returns the date-hierarchy member specified by the input date.

FormatDate

Returns a formatted date-string.

GetFirstDate

Returns the start date for a date-hierarchy member.

GetLastDate

Returns the end date for a date-hierarchy member.

Today

Returns a number representing the current date on the Essbase computer.

ToDateEx

Converts any date string to a date that can be used in calculations.