This cube dimension represents return material reason and is based on the IFS
Applications dimension DIM_RETURN_MATERIAL_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.025 Load IFSAppl_DIM_RETURN_MATERIAL_REASON_BI.dtsx |
IFSAppl_FACT_RETURN_MATERIAL_LINE_BI |
T - DW |
2.1.025 Load Dw_DIM_RETURN_MATERIAL_REASON.dtsx |
Dw_DIM_RETURN_MATERIAL_REASON |
L - DM |
3.1.025 Load Dm_DIM_RETURN_MATERIAL_REASON.dtsx |
Dm_DIM_RETURN_MATERIAL_REASON |