Derived Dates in Workbooks

Oracle Analytics automatically generates derived date columns for any Date, Time, or Timestamp columns in both datasets and subject areas.

Derived dates are columns with different levels of granularity such as Year, Quarter, Month, and Day. They're treated as attributes by default. You can use derived date columns the same as you would any other date or time column.

For example, for a date column called Ship Date, Oracle Analytics provides additional derived date columns such as Year, Quarter, Quarter of Year, Month, Month of Year, and so on, all the way down to days.

Description of the illustration derived_dates_example.png