Cube Dimension - Critically

This cube dimension represents equipment criticality in maintenance and is based on the IFS Applications dimension DIM_CRITICALITY. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Criticality NO Key. Built as DESCRIPTION, i.e. the description of the criticality (CODE)
Criticality Code NO Represents the CRITICALITY (also equal to CODE) of the dimension, i.e. equipment criticality

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.074 Load IFSAppl_DIM_CRITICALITY_BI.dtsx IFSAppl_DIM_CRITICALITY_BI
T - DW 2.1.074 Load Dw_DIM_CRITICALITY.dtsx Dw_DIM_CRITICALITY
L - DM 3.1.074 Load Dm_DIM_CRITICALITY.dtsx Dm_DIM_CRITICALITY