Cube Dimension - Symptom

This cube dimension represents the work order symptom code and is based on the IFS Applications dimension DIM_SYMPTOM. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Error Symptom Code NO Represents the ERR_SYMPTOM (also equal to CODE) of the dimension, i.e. work order symptom code
Symptom NO Key. Built as DESCR, i.e. the description of the work order symptom code (CODE)

USED BY CUBE

Cube Name
MAINTENENCE

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.073 Load IFSAppl_DIM_SYMPTOM_BI.dtsx IFSAppl_DIM_SYMPTOM_BI
T - DW 2.1.073 Load Dw_DIM_SYMPTOM.dtsx Dw_DIM_SYMPTOM
L - DM 3.1.073 Load Dm_DIM_SYMPTOM.dtsx Dm_DIM_SYMPTOM