CUBE DIMENSION - ITEM CLASS

This cube dimension represents Item Class and is based on the IFS Applications dimension DIM_ITEM_CLASS. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Item Class NO Key. Built as CODE + ' - ' + DESCRIPTION
Item Class Code NO Represents the CODE of the dimension, i.e. the ISO unit
Item Class Desc NO Represents the description of the ISO unit
Parent Item Class Id NO Parent in Parent-Child hierarchy

USED BY CUBE

Cube Name
MAINTENANCE

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_ITEM_CLASS_BI EQUIDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.117 Load IFSAppl_DIM_ITEM_CLASS_BI.dtsx IFSAppl_DIM_ITEM_CLASS_BI
T - DW 2.1.117 Load Dw_DIM_ITEM_CLASS.dtsx Dw_DIM_ITEM_CLASS
L - DM 3.1.117 Load Dm_DIM_ITEM_CLASS.dtsx Dm_DIM_ITEM_CLASS