Business Layer
The business layer consists of three business models:
- OCDM_METADATA provides reports querying OCDM metadata:
- 5 logical tables
- 4 Dimension tables
- 1 Logical Fact tables
- OCDM_OLAP consists of:
- 29 Logical Dimension tables
- 29 Hierarchies (same as Relational)
- 24 Logical fact table
Modeled in form of Dimension/Fact from a Relational View created over OLAP Cube
- ODWT:
- Is the main business model for all relational reports
- Is modeled logically in form of Star Schema, 3NF/Snow Flake Physical Database structure
- Includes Logical Fact/Dimension Table Hierarchies
- Logical Dimensions: Access Method/Account, Product/Product Market Plan, Time
- Logical Fact tables:CDW Wireless; LY (last year), YTD (year-to-date), LY YTD; Cell Statistics; Account Churn Statistics
These 4 metadata reports allow to understand the mapping between entities, measures and KPIs, and Intra-ETLs. It is the starting point for a gap analysis. They should be updated via OWB whenever some customization work is done and put in production.