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	The ID of the group of snapshots created to collect the employee information required for various headcount statistical reports
Snapshot Calendar	The ID of the statistical period calendar.
Snapshot Calendar Id	The ID of the statistical period calendar.
Snapshot Category	The description of the statistical snapshot.
Snapshot Category Code	The ID of the group of snapshots created to collect the employee information required for various headcount statistical reports
Snapshot Period	The period within which employee data is required to be valid in order to be included in the headcount snapshot.
Snapshot Year	The year to which selected employee statistical data belongs.
Snapshot Year Period	Combination of Year and Period columns

Hierarchies

Hierarchy	Level
SnapshotHy
	Snapshot Category
	Snapshot Calendar
	Snapshot Year
	Snapshot Period

USED BY MODEL(S)

Model Name

Cash Planning

Employee Analysis

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
SNAPSHOT	DIM_SNAPSHOT_DETAIL_TM	DIM_SNAPSHOT_DETAIL_BI	DIM_SNAPSHOT_DETAIL	On Line