This Tabular Model is used for: Salary Review Analysis. There is a list of Tabular Models pre-packaged and delivered as a part of IFS Analysis Models, and you can refer to them here.
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| COMP AND BEN MEASURES | FACT_SAL_REVIEW_BUDGET_INFO_TM | FACT_SAL_REVIEW_BUDGET_INFO_BI | FACT_SAL_REVIEW_BUDGET_INFO | Data Mart |
Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| BUDGET INFO RLS ID | BUDGET_INFO_RLS_ID | FACT_SAL_REVIEW_BUDGET_INFO_BI, SAL_REVIEW_BUDGET_INFO_RLS | BUDGET_INFO_RLS_ID | On Line |
| COMPANY | DIM_COMPANY_TM | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| COMPENSATION TYPE | DIM_COMPENSATION_TYPE_TM | DIM_COMPENSATION_TYPE_BI | DIM_COMPENSATION_TYPE | On Line |
| EMPLOYEE | DIM_EMPLOYEE_PERSON_TM | DIM_EMPLOYEE_PERSON_BI | DIM_EMPLOYEE_PERSON | On Line |
| EMPLOYEE CATEGORY | DIM_EMPLOYEE_CATEGORY_TM | DIM_EMPLOYEE_CATEGORY_BI | DIM_EMPLOYEE_CATEGORY | On Line |
| JOB DETAILS | DIM_JOB_DETAILS_TM | DIM_JOB_DETAILS_BI | DIM_JOB_DETAILS | On Line |
| ORGANIZATION CODE | DIM_ORGANIZATION_CODE_TM | DIM_ORGANIZATION_CODE_BI | DIM_ORGANIZATION_CODE | On Line |
| POSITION | DIM_POSITION_TM | DIM_POSITION_BI | DIM_POSITION | On Line |
| SAL REVIEW BUDGET INFO | FACT_SAL_REVIEW_BUDGET_INFO_TM | FACT_SAL_REVIEW_BUDGET_INFO_BI | FACT_SAL_REVIEW_BUDGET_INFO | Data Mart |
| SAL REVIEW BUDGET INFO RLS | SAL_REVIEW_BUDGET_INFO_RLS | SAL_REVIEW_BUDGET_INFO_RLS | SAL_REVIEW_BUDGET_INFO_RLS | On Line |
| SAL REVIEW COMP DETAIL | FACT_SAL_REVIEW_COMP_DETAIL_TM | FACT_SAL_REVIEW_COMP_DETAIL_BI | FACT_SAL_REVIEW_COMP_DETAIL | Data Mart |
| SAL REVIEW COMP DETAIL EMP RLS | DIM_EMPLOYEE_PERSON_TM | DIM_EMPLOYEE_PERSON_BI | DIM_EMPLOYEE_PERSON | On Line |
| SAL REVIEW COMP DETAIL RLS | SAL_REVIEW_COMP_DETAIL_RLS | SAL_REVIEW_COMP_DETAIL_RLS | SAL_REVIEW_COMP_DETAIL_RLS | On Line |
| SALARY REVIEW INFO | FACT_SALARY_REVIEW_INFO_TM | FACT_SALARY_REVIEW_INFO_BI | FACT_SALARY_REVIEW_INFO | Data Mart |
| SALARY REVIEW INFO EMP RLS | DIM_EMPLOYEE_PERSON_TM | DIM_EMPLOYEE_PERSON_BI | DIM_EMPLOYEE_PERSON | On Line |
| SALARY REVIEW INFO RLS | SALARY_REVIEW_INFO_RLS | SALARY_REVIEW_INFO_RLS | SALARY_REVIEW_INFO_RLS | On Line |
| SALARY REVIEW PERIOD | ||||
| WORK LOCATION | DIM_WORK_LOCATION_TM | DIM_WORK_LOCATION_BI | DIM_WORK_LOCATION | On Line |
The following table lists the relationships between tables and columns in the model.
| Relationship: Table (column) - Table (column) |
| SALARY REVIEW INFO (DIM_COMPANY_ID) - COMPANY (ID) |
| SALARY REVIEW INFO (DIM_EMPLOYEE_CATEGORY_ID) - EMPLOYEE CATEGORY (ID) |
| SALARY REVIEW INFO (DIM_EMP_NO) - EMPLOYEE (ID) |
| SALARY REVIEW INFO (DIM_EMP_NO_RLS) - SALARY REVIEW INFO EMP RLS (ID) |
| SALARY REVIEW INFO (DIM_JOB_ID) - JOB DETAILS (ID) |
| SALARY REVIEW INFO (DIM_ORG_CODE) - ORGANIZATION CODE (ID) |
| SALARY REVIEW INFO (DIM_POS_CODE) - POSITION (ID) |
| SALARY REVIEW INFO (DIM_REVIEW_PERIOD_ID) - SALARY REVIEW PERIOD (ID) |
| SALARY REVIEW INFO (DIM_WORK_LOCATION) - WORK LOCATION (ID) |
| SALARY REVIEW INFO RLS (SALARY_REVIEW_INFO_EMP_NO) - SALARY REVIEW INFO EMP RLS (ID) |
| SAL REVIEW BUDGET INFO (DIM_COMPANY_ID) - COMPANY (ID) |
| SAL REVIEW BUDGET INFO (DIM_REVIEW_PERIOD_ID) - SALARY REVIEW PERIOD (ID) |
| SAL REVIEW BUDGET INFO (DIM_SALARY_SETTING_MANAGER_ID) - EMPLOYEE (ID) |
| SAL REVIEW BUDGET INFO (DIM_SALARY_SETTING_ORG_CODE) - ORGANIZATION CODE (ID) |
| SAL REVIEW BUDGET INFO (ID) - BUDGET INFO RLS ID (ID) |
| SAL REVIEW BUDGET INFO RLS (SAL_REVIEW_BUDGET_INFO_ID) - BUDGET INFO RLS ID (ID) |
| SAL REVIEW COMP DETAIL (DIM_COMPANY_ID) - COMPANY (ID) |
| SAL REVIEW COMP DETAIL (DIM_COMPENSATION_TYPE_ID) - COMPENSATION TYPE (ID) |
| SAL REVIEW COMP DETAIL (DIM_EMPLOYEE_CATEGORY_ID) - EMPLOYEE CATEGORY (ID) |
| SAL REVIEW COMP DETAIL (DIM_EMP_NO) - EMPLOYEE (ID) |
| SAL REVIEW COMP DETAIL (DIM_EMP_NO_RLS) - SAL REVIEW COMP DETAIL EMP RLS (ID) |
| SAL REVIEW COMP DETAIL (DIM_JOB_ID) - JOB DETAILS (ID) |
| SAL REVIEW COMP DETAIL (DIM_ORG_CODE) - ORGANIZATION CODE (ID) |
| SAL REVIEW COMP DETAIL (DIM_POS_CODE) - POSITION (ID) |
| SAL REVIEW COMP DETAIL (DIM_REVIEW_PERIOD_ID) - SALARY REVIEW PERIOD (ID) |
| SAL REVIEW COMP DETAIL (DIM_WORK_LOCATION) - WORK LOCATION (ID) |
| SAL REVIEW COMP DETAIL RLS (SAL_REVIEW_COMP_DETAIL_EMP_NO) - SAL REVIEW COMP DETAIL EMP RLS (ID) |