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.
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 |