Cube Dimension - Class

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

ATTRIBUTES

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

USED BY CUBE

Cube Name
MAINTENENCE

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.068 Load IFSAppl_DIM_CLASS_BI.dtsx IFSAppl_DIM_CLASS_BI
T - DW 2.1.068 Load Dw_DIM_CLASS.dtsx Dw_DIM_CLASS
L - DM 3.1.068 Load Dm_DIM_CLASS.dtsx Dm_DIM_CLASS