This cube dimension represents the Time Types in Organization Basic Data and is based on the IFS Applications dimension DIM_TIME_TYPE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Hierarchy | Description |
Calendar Id | NO | Calendar Code |
Sales Part No | NO | The ID of the Sales Part |
Last Loaded | NO | Last Data warehouse update time |
Modified By User | NO | Responsible user data warehouse update |
Site | NO | Site Code |
Time Type | NO | Site + Time Type Code + Time Type description |
Time Type Code Desc | NO | Time Type Code + Time Type description |
Time Type Desc | NO | Time Type Description |
Cube Name |
MAINTENANCE |
BI Access View | BI component | Recommended Source Type |
DIM_TIME_TYPE_BI | MSCODI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.147 Load IFSAppl_DIM_TIME_TYPE_BI.dtsx | IFSAppl_DIM_TIME_TYPE_BI |
T - DW | 2.1.147 Load Dw_DIM_TIME_TYPE.dtsx | Dw_DIM_TIME_TYPE |
L - DM | 3.1.147 Load Dm_DIM_DIM_TIME_TYPE.dtsx | Dm_DIM_TIME_TYPE |