CUBE DIMENSION - WT CONNECTION TYPE

This cube dimension represents Work Task Connection Type and is based on the IFS Applications dimension DIM_WO_CONNECTION_TYPE. There exists two types, Actuel and Reported which have the suffixes Actual and Reported respectively. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute	Hierarchy	Description
WT Conn Type	NO	Key. Built as CODE+ ' - ' + DESC
WT Conn Type <Type> Code	NO	Represents the code of WT Connection Type
WT Conn Type <Type> Desc	NO	Represents the description of the WT Connection Type

USED BY CUBE

Cube Name

MAINTENANCE

ETL Information

BI Access View	BI Component	Recommended Source Type
DIM_WO_CONNECTION_TYPE_BI	PCMSDI	On Line

ETL Step	File Name of SSIS Package	Table Name
E - Stage	1.1.039 Load IFSAppl_DIM_WO_CONNECTION_TYPE_BI.dtsx	IFSAppl_DIM_WO_CONNECTION_TYPE_BI
T - DW	2.1.039 Load Dw_DIM_WO_CONNECTION_TYPE.dtsx	Dw_DIM_WO_CONNECTION_TYPE
L - DM	3.1.039 Load Dm_DIM_WO_CONNECTION_TYPE.dtsx	Dm_DIM_WO_CONNECTION_TYPE