|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
For expressions dimensioned by a dimension of type DAY, WEEK, MONTH, QUARTER, or YEAR, the ENDDATE function returns the final date of the last time period in the dimension status for which the expression has a non-
NA value. For example, when an expression is dimensioned by a dimension of type MONTH, and when
DEC98 is the last dimension value for which the expression has a non-
NA value, ENDDATE returns the date
DATE-only or text
The expression must have exactly one dimension that has the type of DAY, WEEK, MONTH, QUARTER, or YEAR. When all the values of the expression are
NA, ENDDATE returns
Example 7-75 Finding the End Date
The following statements limit the values of the dimensions of the
units variable, then sends the last date associated with a non-
NA value to the current outfile.
LIMIT month TO ALL LIMIT product TO 'Tents' LIMIT district TO 'Chicago' SHOW ENDDATE(units)
These statements produce the following output.