A Appendix
This appendix covers the additional information required for the OIPI application.
Tables and List of values
V_FINANCIAL_PERIOD_INDICATOR column in STG_PARTY_FINANCIALS table is expected to have values Q1/Q2/Q3/Q4.
Loading Planned Values in Fact and Profitability Tables
Planned value is an estimation of the amount or number that the business is expected to accomplish in a defined period. The planned values are estimated by the business functions and serve as a baseline, against which the performance can be measured with actual value or number achieved by the company.
Planned values are generally taken from the customer's book. It will be a direct load into the fact table (FCT_POLICY_PROFITABILITY) with V_SCENARIO_CODE as 400.
Data Population in FSI_LOCATION_MAP_COORD Table
Populate the FSI_LOCATION_MAP_COORD based on DIM_LOCATION data itself, but description and codes should come from tables OBIEE_COUNTRY, OBIEE_STATE, OBIEE_CITY (from the DB schema configured for Maps, OBIEE_NAVTEQ for instance in this case) respectively for Country, State and City, and n_location_skey should be the corresponding n_location_skey from DIM_LOCATION.
Table A-1 DIM_LOCATION Table Data
| Column Name | Value |
|---|---|
| N_LOCATION_SKEY | 1 |
| V_LOCATION_CODE | HAW |
| V_COUNTRY_CODE | USA |
| V_COUNTRY_DESC | United States |
| V_STATE_CODE | USA_HI |
| V_STATE_DESC | USA_HI |
| V_CITY_CODE | HAWAII |
| V_CITY_DESC | Honolulu |
| V_ZIP_CODE | 96813 |
Table A-2 FSI_LOCATION_MAP_COORD Table Columns
| Column Name | Value |
|---|---|
| n_location_skey | 1 |
| v_country_code = OBIEE_COUNTRY.ISO_COUNTRY_CODE | USA |
| v_country_code_map = OBIEE_COUNTRY.ISO_COUNTRY_CODE | USA |
| v_country_desc = OBIEE_COUNTRY.NAME | United States |
| v_state_code = OBIEE_STATE.ISO_CTRY_CD_STATE_ABBRV | USA_HI |
| v_state_code_map = OBIEE_STATE.ISO_CTRY_CD_STATE_ABBRV | USA_HI |
| v_state_desc = OBIEE_STATE.STATE_NAME | HAWAII |
| v_city_code = OBIEE_CITY.CTRY_CD3_STATE_ABBRV_CITY | USA_HI_Honololu |
| v_city_code_map = OBIEE_CITY.CTRY_CD3_STATE_ABBRV_CITY | USA_HI_Honololu |
| v_city_desc = OBIEE_CITY.CITY_NAME | HONOLULU |
| v_zip_code | 96813 |
This is a one-time manual activity and the Map tables, columns would change based on the Maps used. The process mentioned here is for NAVTEQ Maps.