CUBE DIMENSION - FAILING COMPONENT

This cube dimension represents Failing Component and is based on the IFS Applications dimension DIM_FAILING COMPONENT. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Failing Component Error NO Key. Built as ITEM CLASS ID +' - ' + FUNCTION ID + ' - ' + ERR TYPE + '- '+ CODE+ ' - ' + CAUSE DESCRIPTION
Failing Component ID NO Represents the code of the Failing component
Failing Component Cause Desc NO Represents the description of the Failing Component
Error Type Code NO Represents the code of the Error type
Function ID NO represents the Function ID Code
Item Class ID NO Represents the ID of the Item Class
FailCompHy YES Defined as "Item Class ID" -> "Function ID" -> "Error Type Code" -> "Failing Component Cause Desc" -> "Failing Component ID"

USED BY CUBE

Cube Name
MAINTENANCE

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_FAILING COMPONENT_BI MSCODI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.197 Load IFSAppl_DIM_FAILING COMPONENT_BI.dtsx IFSAppl_DIM_FAILING COMPONENT_BI
T - DW 2.1.197 Load Dw_DIM_FAILING COMPONENT.dtsx Dw_DIM_FAILING COMPONENT
L - DM 3.1.197 Load Dm_DIM_FAILING COMPONENT.dtsx Dm_DIM_FAILING COMPONENT