Cube Dimension - Time Type

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.

ATTRIBUTES

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

Used By Cube

Cube Name
MAINTENANCE

ETL Information

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