Cube Dimension - Snapshot

This cube represents the human resouces dimension snapshot and is based on the IFS Applications dimension DIM_SNAPSHOT_DETAILS.

ATTRIBUTES

Attribute Hierarchy Description
Snapshot NO Refered as CATEGORY_CALENDAR_YEAR_DESCR in dimension (CATEGORY_DESCRIPTION + ' - ' + CALENDAR_DESCRIPTION + ' - ' + cast(YEAR as varchar) + ' - ' + PERIOD as CATEGORY_CALENDAR_YEAR_DESCR).
Snapshot Calender NO Refered as ID in dimension
Snapshot Calender Id NO  
Snapshot Category NO Refered as Category_description in dimension 
Snapshot Category Code NO Refered as Code in dimension
Snapshot Period NO Period for Snapshot
Snapshot Year NO Year for Snapshot
Snapshot Year Period NO Year and Period for Snapshot
Hierarchy YES "Snapshot Category" -> "Snapshot Calendar" -> "Snapshot Year" -> "Snapshot Period"

USED BY CUBE

Cube Name
HUMAN RESOURCES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_SNAPSHOT_DETAILS_BI PERSDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.095 Load IFSAppl_DIM_SNAPSHOT_DETAIL_BI.dtsx IFSAppl_DIM_SNAPSHOT_DETAIL_BI
T - DW 2.1.095 Load Dw_DIM_SNAPSHOT_DETAIL.dtsx Dw_DIM_SNAPSHOT_DETAIL
L - DM 3.1.095 Load Dm_DIM_SNAPSHOT_DETAIL.dtsx Dm_DIM_SNAPSHOT_DETAIL