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