Cube Dimension - Cust Order Type

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

ATTRIBUTES

Attribute	Hierarchy	Description
Customer Order Type	NO	Key. Defined as CODE + ' - ' + DESCRIPTION represented by the ETL column CODE_DESCRIPTION
Customer Order Type Code	NO	The dimension CODE, i.e. customer order type
Customer Order Type Descr	NO	The description of the customer order type (DESCRIPTION)

USED BY CUBE

Cube Name

SALES

ETL Information

BI Access View	BI Component	Recommended Source Type
DIM_CUST_ORDER_TYPE_BI	ORDEDI	On Line

ETL Step	File Name of SSIS Package	Table Name
E - Stage	1.1.023 Load IFSAppl_DIM_CUST_ORDER_TYPE_BI.dtsx	IFSAppl_DIM_CUST_ORDER_TYPE_BI
T - DW	2.1.023 Load Dw_DIM_CUST_ORDER_TYPE_BI.dtsx	Dw_DIM_CUST_ORDER_TYPE
L - DM	3.1.023 Load Dm_DIM_CUST_ORDER_TYPE_BI.dtsx	Dm_DIM_CUST_ORDER_TYPE