How to Change the Date Range of the Date Dimension to Allow Dates Earlier than Jan-1-1980?
(Doc ID 1948130.1)
Last updated on MARCH 05, 2019
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 22.214.171.124.1 to 126.96.36.199.1 [Release 2.5]
Information in this document applies to any platform.
**Disclaimer:** This KM article may include the following abbreviations:
OUASA - Oracle Utilities Advanced Spatial and Operational Analytics
OWB - Oracle Warehouse Builder
OUBI/BI - Oracle Utilities Business Intelligence
ETL - Extract, Transform, Load
OUA 2.5.0 with Source Applications CCB & MDM.
The Date Dimension is populated using default date range Jan-1-1980 - Dec-31-2050.
How to modify this range to include earlier data, for example dates starting in 01/01/1940?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|The CD_DATE can be customized to populate the data from the required date.|
|ETL Component based on Oracle Data Integrator|
|ETL Component based on Oracle Warehouse Builder|