CUBE DIMENSION - ITEM CLASS FUNCTION

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

ATTRIBUTES

Attribute Hierarchy Description
Item Class Function Desc NO Key. Built as Item Class ID + ' - ' + Function ID + ' - ' + DESCRIPTION
Function ID NO Represents the ID of the dimension, i.e. the Funtion ID
Function Desc Desc NO Represents the description of the Function ID
Item Class Id NO Represents the ID of Item Class

USED BY CUBE

Cube Name
MAINTENANCE

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.120 Load IFSAppl_DIM_ITEM_CLASS_FUNCTION_BI.dtsx IFSAppl_DIM_ITEM_CLASS_FUNCTION_BI
T - DW 2.1.120 Load Dw_DIM_ITEM_CLASS_FUNCTION.dtsx Dw_DIM_ITEM_CLASS_FUNCTION
L - DM 3.1.120 Load Dm_DIM_ITEM_CLASS_FUNCTION.dtsx Dm_DIM_ITEM_CLASS_FUNCTION