IFS Analysis Model: Employee Analysis

This Analysis Model is used for: Employee Analysis. There is a list of Analysis Models pre-packaged and delivered as a part of Analysis Models - Power BI, and you can refer to them here.

Contents

• Usage/Purpose
• Fact Tables
• Dimension Tables
• Configurations
• Limitations
• Relationships

Usage/Purpose

Main analysis scenarios are:

• Number of headcount analysis over time, Employed and FTE
• Age analysis and age distribution over time
• Gender Diversity
• Headcount analysis by Job, Position, Work Location
• Work Experience analysis by Work Location, Age Group, Gender, Job Title
• End employment over time with reason for leaving.

Fact Tables

Model Table	BI Access View	Referenced Information Source	Recommended Access Type
EMPLOYMENT ANALYSIS MEASURES	FACT_EMPLOYEE_ANALYSIS_BI	FACT_EMPLOYEE_ANALYSIS_PQ	On Line

 Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources

Dimension Tables

Model Table	BI Access View	Referenced Information Source	Recommended Access Type
JOB	DIM_JOB_DETAILS_BI	DIM_JOB_DETAILS	On Line
CODE B	DIM_CODE_B_BI	DIM_CODE_B	On Line
CODE C	DIM_CODE_C_BI	DIM_CODE_C	On Line
CODE D	DIM_CODE_D_BI	DIM_CODE_D	On Line
CODE E	DIM_CODE_E_BI	DIM_CODE_E	On Line
CODE F	DIM_CODE_F_BI	DIM_CODE_F	On Line
CODE G	DIM_CODE_G_BI	DIM_CODE_G	On Line
CODE H	DIM_CODE_H_BI	DIM_CODE_H	On Line
CODE I	DIM_CODE_I_BI	DIM_CODE_I	On Line
CODE J	DIM_CODE_J_BI	DIM_CODE_J	On Line
ACCOUNTING PERIOD	DIM_ACCOUNTING_PERIOD_BI	DIM_ACCOUNTING_PERIOD	On Line
COMPANY	DIM_COMPANY_BI	DIM_COMPANY	On Line
COMPANY WORK LOCATION	DIM_COMPANY_WORK_LOCATION_BI	DIM_COMPANY_WORK_LOCATION	On Line
EMPLOYEE CATEGORY	DIM_EMPLOYEE_CATEGORY_BI	DIM_EMPLOYEE_CATEGORY	On Line
EMPLOYMENT	DIM_EMPLOYMENT_BI	DIM_EMPLOYMENT	On Line
POSITION	DIM_POSITION_BI	DIM_POSITION	On Line
SNAPSHOT	DIM_SNAPSHOT_DETAIL_BI	DIM_SNAPSHOT_DETAIL	On Line
ORGANIZATION CODE	DIM_ORGANIZATION_CODE_BI	DIM_ORGANIZATION_CODE	On Line
EMPLOYEE ANALYSIS	FACT_EMPLOYEE_ANALYSIS_BI	FACT_EMPLOYEE_ANALYSIS_PQ	On Line
AGE GROUP	DIM_AGE_GROUP_BI	DIM_AGE_GROUP_PQ	On Line
EMPLOYMENT DURATION	DIM_CURR_EMP_DURATION_GROUP_BI	DIM_CURR_EMP_DURATION_GROUP_PQ	On Line
ANALYSIS STRUCTURE-ALTERNATIVE	DIM_ORGANIZATION_CODE_BI	DIM_STRUCT_ORG_CODE_ALT_PQ	On Line
ANALYSIS STRUCTURE-CURRENT	DIM_ORGANIZATION_CODE_BI	DIM_STRUCT_ORG_CODE_CURR_PQ	On Line
REPORTING DATE	DIM_BI_TIME_BI	DIM_BI_TIME	On Line
EMPLOYEE_ANALYSIS_RLS	NOT APPLICABLE	NOT APPLICABLE	On Line

Configurations

The Headcount Analysis model only supports one Age Group Class. It is necessary to define the Age Group Class in IFS Cloud

Limitations

n/a

Relationships

The following table lists the relationships between tables and columns in the model.

Relationship: Table (column) - Table (column)

EMPLOYEE ANALYSIS (ALT_STRUCT_ORG_CODE) - ANALYSIS STRUCTURE-ALTERNATIVE (ID)

EMPLOYEE ANALYSIS (DIM_ACC_PERIOD_ID) - ACCOUNTING PERIOD (ID)

EMPLOYEE ANALYSIS (DIM_AGE_GROUP_ID) - AGE GROUP (ID)

EMPLOYEE ANALYSIS (DIM_CODE_B_ID) - CODE B (ID)

EMPLOYEE ANALYSIS (DIM_CODE_C_ID) - CODE C (ID)

EMPLOYEE ANALYSIS (DIM_CODE_D_ID) - CODE D (ID)

EMPLOYEE ANALYSIS (DIM_CODE_E_ID) - CODE E (ID)

EMPLOYEE ANALYSIS (DIM_CODE_F_ID) - CODE F (ID)

EMPLOYEE ANALYSIS (DIM_CODE_G_ID) - CODE G (ID)

EMPLOYEE ANALYSIS (DIM_CODE_H_ID) - CODE H (ID)

EMPLOYEE ANALYSIS (DIM_CODE_I_ID) - CODE I (ID)

EMPLOYEE ANALYSIS (DIM_CODE_J_ID) - CODE J (ID)

EMPLOYEE ANALYSIS (DIM_COMPANY_ID) - COMPANY (ID)

EMPLOYEE ANALYSIS (DIM_CURRENT_DURATION_GROUP_ID) - EMPLOYMENT DURATION (ID)

EMPLOYEE ANALYSIS (DIM_EMPLOYEE_CATEGORY) - EMPLOYEE CATEGORY (ID)

EMPLOYEE ANALYSIS (DIM_EMPLOYMENT_ID) - EMPLOYMENT (ID)

EMPLOYEE ANALYSIS (DIM_HEADCOUNT_DATE_ID) - REPORTING DATE (ID)

EMPLOYEE ANALYSIS (DIM_JOB_ID) - JOB (ID)

EMPLOYEE ANALYSIS (DIM_ORG_CODE_ID) - ORGANIZATION CODE (ID)

EMPLOYEE ANALYSIS (DIM_POSITION_ID) - POSITION (ID)

EMPLOYEE ANALYSIS (DIM_SNAPSHOT_DETAIL_ID) - SNAPSHOT (ID)

EMPLOYEE ANALYSIS (DIM_WORK_LOCATION_ID) - COMPANY WORK LOCATION (ID)

EMPLOYEE ANALYSIS (STRUCT_ORG_CODE) - ANALYSIS STRUCTURE-CURRENT (ID)