Model: Maintenance - Specifications for Dimension Table: REPORTED EQUIPMENT OBJECT

On this page you will find the specifications regarding the Model: Maintenance and Dimension Table: REPORTED EQUIPMENT OBJECT.

This model dimension represents equipment objects and is based on the IFS Cloud dimension DIM_EQUIPMENT_OBJECT. All models that refer to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute	Description (where applicable)
ITEM_ABOVE_ID
Rep Equipment Category	Defined as the equipment category description (CATEGORY_DESCRIPTION)
Rep Equipment Group	Defined as the equipment group description (GROUP_DESCRIPTION)
Rep Equipment Object	Key. Defined as MCH_CODE + ' - ' + MCH_NAME, i.e. identity and name of the equipment object.

Hierarchies

Hierarchy	Level
Rep EquipmentHy
	L1
	L2
	L3
	L4
	L5
	L6
	L7
	L8
	L9
RepEquipmentCategoryHy
	Rep Equipment Category
	Rep Equipment Object
RepEquipmentGroupHy
	Rep Equipment Group
	Rep Equipment Object

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
REPORTED EQUIPMENT OBJECT	DIM_EQUIPMENT_OBJECT_TM	DIM_EQUIPMENT_OBJECT_BI	DIM_EQUIPMENT_OBJECT	On Line