CUBE DIMENSION - WO CONNECTION TYPE

This cube dimension represents the work order connection type and is based on the IFS Applications dimension DIM_WO_CONNECTION_TYPE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute	Hierarchy	Description
Wo Connection Type	NO	Key. Built as CODE + ' - ' + WO_CONNECTION_TYPE_DESC
Wo Connection Type Code	NO	The CODE of the dimension, i.e. WO_CONNECTION_TYPE (same as CODE)
Wo Connection Type Desc	NO	The description of the connection type (WO_CONNECTION_TYPE_DESC)

USED BY CUBE

Cube Name

MAINTENENCE

ETL Information

BI Access View	BI Component	Recommended Source Type
DIM_WO_CONNECTION_TYPE_BI	PCMSDI	Data Mart

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