Cube Dimension - Statistic Period

This cube dimension represents Statistic Period and is based on the IFS Applications dimension DIM_STATISTIC_PERIOD. All cubes that refers to this dimension will have the attributes described below.

ATTRIBUTES

Attribute Hierarchy Description
Statistic Period NO Key. Built as STAT_YEAR_NO - STAT_PERIOD_NO as STAT_YEAR_PERIOD.
Statistic Period Begin Date NO This is the first date in the period. The same day may not be included in more than one period.
Statistic Period Description NO Represents the description of the statistic period.
Statistic Period End Date NO The last date in the period. The same day may not be included in more than one period.
Statistic Period - Last Loaded NO Represents the last ETL process date.
Statistic Period Period Closed NO Represents the period is open or closed.
Statistic Period Period Closed Description NO Represents the information of which month the period have been closed.
Statistic Period Stat Period No NO Represents the period for begin and end date.
Statistic Period Stat Year No NO Represents the year for begin and end date

USED BY CUBE

Cube Name
INVENTORY

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_STATISTIC_PERIOD_BI MPCCDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.109 Load IFSAppl_DIM_STATISTIC_PERIOD_BI.dtsx IFSAppl_DIM_STATISTIC_PERIOD_BI
T - DW 2.1.109 Load Dw_DIM_STATISTIC_PERIOD.dtsx Dw_DIM_STATISTIC_PERIOD
L - DM 3.1.109 Load Dm_DIM_STATISTIC_PERIOD.dtsx Dm_DIM_STATISTIC_PERIOD