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.
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 |