4.1 Dimension Data Flow
Dimension Data in the OIPI application is loaded from staging master tables using the Slowly Changing Dimensions (SCD) process.
Data from source systems can be loaded into staging through flat file or source system interfaces. SCD process tracks the changes in the dimensional attributes and loads data into dimension tables. Examples of dimension tables that follow the SCD process are Product, Customer Type, Customer, and so on.
Some dimensions are static or maintained internally within the application and are not expected as a download from the source system. An example of such dimensions is the Reporting Line. These dimensions are maintained through the AMHM (Attribute Member Hierarchy Maintenance) component of OFSAAI or other framework components like DEFI.
Following are the list of Dimensions used in OIPI:
Table 4-1 Dimensions used in OIPI
| Dimension Entity Name | Staging Entity Name(s) | Loading/Maintenance Method |
|---|---|---|
| Acquisition Channel Dimension | Stage Channel Master | SCD |
| Attrition Dimension | Stage Attrition Reason Master | SCD |
| Bands Dimension | AMHM | SCD |
| Billing Account Dimension | Stage Bill Plan Master | SCD |
| Business Class Dimension | Stage Business Class Master | SCD |
| Campaign Dimension | Stage Campaign Master | SCD |
| Catastrophe Events Dimension | Stage Catastrophe Master | SCD |
| Claim Dimension | Stage Claim Details | SCD |
| Country Dimension | Stage Country Master | SCD |
| Coverage Status Dimension | Stage Coverage Status Master | SCD |
| Coverage Type Dimension | Stage Coverage Type Master | SCD |
| Dimension Policy | Stage Property and Casualty Contracts | SCD |
| Dimension Policy Type | Stage PolicyType Master | SCD |
| Dimension Reinsurance Risk Type | Stage Reinsurance Risk Type Master | SCD |
| Dwelling Dimension | Stage Dwelling Master | SCD |
| Employee Dimension | Stage Employee | SCD |
| Geography Dimension | Stage Geography Master | SCD |
| Insurance Coverage Dimension | Stage Insurance Coverage Master | SCD |
| Lines of business Dimension | Stage Lines of business Master | SCD |
| Litigation Dimension | Stage Litigation Master | SCD |
| Loan Product Category Dimension | Stage Product Category Master | SCD |
| Location Dimension | Stage Location Master | SCD |
| Organization Structure Dimension | Stage Organization Structure Master | SCD |
| Party Dimension | Stage Party Master | SCD |
| Policy Deductible Dimensions | Stage Policy Deductible Master | SCD |
| Producer Agent Dimension | Stage Producer Agent Master | SCD |
| Producer Dimension | Stage Producer Master | SCD |
| Product Dimension | Stage Product Master | SCD |
| Product Type Dimension | Stage Product Type Master | SCD |
| Quote Source Dimension | Stage Quote Source | SCD |
| Quote Source Method Dimension | Stage Quote Source Method | SCD |
| Quote Submission Method Dimension | Stage Quote Submission Method | SCD |
| Quotes Declination Type Dimension | Stage Quote Declination Type | SCD |
| Rate Modifier Dimension | Stage Policy Rate Modifier | SCD |
| Rate Plan Dimension | Stage Rate Plan Master | SCD |
| Region Dimension | Stage Region Master | SCD |
| Report Type Dimension | Stage Report Type | SCD |
| Risk Item Dimension | Stage Risk Item Master | SCD |
| Underwriter Dimension | Stage Underwriter Master | SCD |
| Vendor Dimension | Stage Vendor Master | SCD |
| Allocation Expense Type Dimension | Seeded | |
| Band Member Attributes | AMHM | |
| Band Dimension Members | AMHM | |
| Hierarchies for Bands | AMHM | |
| Band Dimension Translation | AMHM | |
| Claim Referral Reason Dimension | Seeded | |
| Dimension Claim Status | Seeded | |
| Claim Transaction Type Dimension | Seeded | |
| Currency Dimension | Seeded | |
| Date Dimension | DT | |
| Generally Accepted Accounting Principles Dimension | Seeded | |
| Location Hierarchy | DT | |
| Dimension Policy Status | Seeded | |
| Policy Transaction Type Dimension | Seeded | |
| Quote Status Dimension | Seeded | |
| Quote Type Dimension | Seeded | |
| Recovery Type Dimension | Seeded | |
| Reporting Line Member Attributes | Seeded | |
| Reporting Line Dimension Members | Seeded | |
| Reporting Line Hierarchies | Seeded | |
| Reporting Line Member Translation | Seeded | |
| Reporting Line Dimension | DT | |
| Scenario Dimension | Seeded |
Some of the stage data can also come from master data management interfaces. In such a case, data from the interface is loaded into staging interface tables and SCD is run on the interface tables. Mapping of dimensional attributes to staging can be obtained by querying SYS_STG_JOIN_MASTER and SYS_TBL_MASTER table in the atomic schema.