Model: Employee Analysis - Specifications for Dimension Table: SNAPSHOT

On this page you will find the specifications regarding the Model: Employee Analysis and Dimension Table: SNAPSHOT.

This model represents the human resouces dimension snapshot and is based on the IFS Cloud dimension DIM_SNAPSHOT_DETAILS.

Attributes

Attribute	Description (where applicable)
Snapshot Category Code	The ID of the group of snapshots created to collect the employee information required for various headcount statistical reports
Snapshot Category	The description of the statistical snapshot.
Snapshot Calendar Id	The ID of the statistical period calendar.
Snapshot Calendar	The ID of the statistical period calendar.
Snapshot Year	The year to which selected employee statistical data belongs.
Snapshot Period	The period within which employee data is required to be valid in order to be included in the headcount snapshot.
Snapshot Year Period	Combination of Year and Period columns
Snapshot	The ID of the group of snapshots created to collect the employee information required for various headcount statistical reports

Hierarchies

Hierarchy	Level
SnapshotHy
	Snapshot Category
	Snapshot Calendar
	Snapshot Year
	Snapshot Period

USED BY MODEL(S)

Model Name

Employee Analysis

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

Additional information can be found in the online documentation of Information Sources.

Model Table	BI Access View	Referenced Information Source	Recommended Access Type
SNAPSHOT	DIM_SNAPSHOT_DETAIL_BI	DIM_SNAPSHOT_DETAIL	On Line