Provides information about customizing the access layer of Oracle Communications Data Model.
DWD_
prefix.Provides information about customizing the Oracle Communications Data Model access layer.
The access layer of Oracle Communications Data Model provides the calculated and summarized ("flattened") perspectives of the data needed by business intelligence tools. Access layer objects are populated using the data from the foundation layer 3NF objects.
The access layer objects in the ocdm_sys
schema include: derived and aggregate tables and OLAP cube views. This layer also contains data mining models. The results of these models are stored in derived tables. The models themselves are also defined in the ocdm_sys
schema.
When designing and customizing access layer objects:
Follow the general guidelines for customizing physical objects.
Design access layer objects to support business intelligence reports and queries that your business end-users require.