Cube Dimension - Priority

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

ATTRIBUTES

Attribute Hierarchy Description
Priority NO Key. Built as DESCR, i.e. the description of the priority identity (CODE)
Priority Code NO Represents the PRIORITY_ID (also equal to CODE) of the dimension, i.e. maintenance priority identity

USED BY CUBE

Cube Name
MAINTENENCE

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.072 Load IFSAppl_DIM_PRIORITY_BI.dtsx IFSAppl_DIM_PRIORITY_BI
T - DW 2.1.072 Load Dw_DIM_PRIORITY.dtsx Dw_DIM_PRIORITY
L - DM 3.1.072 Load Dm_DIM_PRIORITY.dtsx Dm_DIM_PRIORITY