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 DECEMBER 04, 2023
Applies to:
Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.5.0.0.1 to 2.5.0.0.1 [Release 2.5]Information in this document applies to any platform.
Goal
**Examples provided in this article do not represent real life personal/confidential information**
**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
**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?
Solution
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
| Goal |
| Solution |
| 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 |
| References |