CUBE DIMENSION - ORDER CANCEL REASON

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

ATTRIBUTES

Attribute Hierarchy Description
Order Cancel Reason NO Key. Built as CODE + ' - ' + DESCRIPTION
Order Cancel Reason Code NO Represents the CODE of the dimension, i.e. the order cancel reason.
Order Cancel Reason Name NO Represents the DESCRIPTION of an order cancel reason.

USED BY CUBE

Cube Name
PROCUREMENT
SALES

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.045 Load IFSAppl_DIM_ORDER_CANCEL_REASON_BI.dtsx IFSAppl_DIM_ORDER_CANCEL_REASON
T - DW 2.1.045 Load Dw_DIM_ORDER_CANCEL_REASON.dtsx Dw_DIM_ORDER_CANCEL_REASON
L - DM 3.1.045 Load Dm_DIM_ORDER_CANCEL_REASON.dtsx Dm_DIM_ORDER_CANCEL_REASON