CUBE DIMENSION - ORDER COORDINATOR

This cube dimension represents condition codes and is based on the IFS Applications dimension DIM_ORDER_COORDINATOR. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Order Coordinator YES Key. Built as CODE + ' - ' + NAME
Order Coordinator Code NO Represents the CODE of the dimension, i.e. the order coordinator code.
Order Coordinator Name NO Represents the NAME of an order coordinator.
Order Coordinator Group YES Represents the order coordinator  group.

USED BY CUBE

Cube Name
PROCUREMENT

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_ORDER_COORDINATOR_BI MPCCDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.046 Load IFSAppl_DIM_ORDER_COORDINATOR_BI.dtsx IFSAppl_DIM_ORDER_COORDINATOR_BI
T - DW 2.1.046 Load Dw_DIM_ORDER_COORDINATOR.dtsx Dw_DIM_ORDER_COORDINATOR
L - DM 3.1.046 Load Dm_DIM_ORDER_COORDINATOR.dtsx Dm_DIM_ORDER_COORDINATOR