Model: Maintenance - Specifications for Dimension Table: FAILING COMPONENT

On this page you will find the specifications regarding the Model: Maintenance and Dimension Table: FAILING COMPONENT.

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

Attributes

Attribute	Description (where applicable)
Error Cause	Represents the error cause
Error Type Code	Represents the code of the Error type
Failing Component Cause Desc	Represents the description of the Failing Component
Failing Component Error	Built as ITEM CLASS ID +' - ' + FUNCTION ID + ' - ' + ERR TYPE + '- '+ CODE+ ' - ' + CAUSE DESCRIPTION
Failing Component ID	Represents the code of the Failing component
Function ID	represents the Function ID Code
Item Class ID	Represents the ID of the Item Class

Hierarchies

Hierarchy	Level
FailCompHy
	Item Class ID
	Function ID
	Error Type Code
	Failing Component Cause Desc
	Failing Component ID

USED BY MODEL(S)

Model Name

Maintenance

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
FAILING COMPONENT	DIM_FAILING_COMPONENT_TM	DIM_FAILING_COMPONENT_BI	DIM_FAILING_COMPONENT	On Line