OUA: WORK_DAY_IND Column Population Logic In CD_DATE table

(Doc ID 2318788.1)

Last updated on OCTOBER 18, 2017

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.6.0.0.6 and later
Information in this document applies to any platform.

Goal

On : 2.6.0.0.6 version, Customer Analytics
,
We have to extend CD_DATE dimension to meet business requirement.
Currently CD_Date is a static table.We are adding some customization to it. We have requirement to update holiday list and accordingly we have to update WORK_DAY_IND column as 0 for holiday and 1 for working day.
How currently OOTB WORK_DAY_IND column is getting populated in CD_DATE?


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms