Cube Dimension - Cause

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

ATTRIBUTES

Attribute Hierarchy Description
Cause NO Key. Built as DESCR, i.e. the description of the error cause (CODE)
Error Cause Code NO Represents the ERR_CAUSE (also equal to CODE) of the dimension, i.e. maintenance cause code

USED BY CUBE

Cube Name
MAINTENENCE

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_CAUSE_BI WODI Data Mart

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.067 Load IFSAppl_DIM_CAUSE_BI.dtsx IFSAppl_DIM_CAUSE_BI
T - DW 2.1.067 Load Dw_DIM_CAUSE.dtsx Dw_DIM_CAUSE
L - DM 3.1.067 Load Dm_DIM_CAUSE.dtsx Dm_DIM_CAUSE