Model: Maintenance - Specifications for Dimension Table: ASSET HEALTH INDI HST

On this page you will find the specifications regarding the Model: Maintenance and Dimension Table: ASSET HEALTH INDI HST.

Attributes

Attribute Description (where applicable)
ID Key for each Indicator value recorded - Combination of Asset Group + Asset Type + Object Seq + Indicator ID + Value Seq
Asset Group Represents the Asset Group (Equipment/Linea Asset/Etc.)
Asset Type Represents the Type of Asset in the Asset Group
Object Seq Represents a unique key for the Asset in the Asset Group
Indicator Type Represents the ID of the Indicator
Indicator Type Desc Represents the type of the Indicator
Indicator Id Represents the ID of the Indicator
Dim_Asset_Type Dimension ID for Asset Type
Dim_Asset_Id Dimension ID for Asset ID
Dim_Asset_Health_Indicator Dimension ID of the Asset Health Indicator
Recorded Date Represents the Date which the Indicator value was recorded at
Mvt_Created_Dt
Value Seq Unique sequence number for each recorded Indicator value
Asset Health Indi Hst Count
Normalized Value Represents the Value recorded for each indicator
Dimension Combination of Asset ID + Asset Name - Used or Search bars
OBJ_TYPE Represents the Asset Type
InvertNormalizedValue

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

Additional information can be found in the online documentation of Information Sources.

Model Table BI Access View Referenced Information Source Recommended Access Type
ASSET HEALTH INDI HST FACT_ASSET_HEALTH_INDI_HST_BI FACT_ASSET_HEALTH_INDI_HST On Line