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)
IDKey for each Indicator value recorded - Combination of Asset Group + Asset Type + Object Seq + Indicator ID + Value Seq
Asset GroupRepresents the Asset Group (Equipment/Linea Asset/Etc.)
Asset TypeRepresents the Type of Asset in the Asset Group
Object SeqRepresents a unique key for the Asset in the Asset Group
Indicator TypeRepresents the ID of the Indicator
Indicator Type DescRepresents the type of the Indicator
Indicator IdRepresents the ID of the Indicator
Dim_Asset_TypeDimension ID for Asset Type
Dim_Asset_IdDimension ID for Asset ID
Dim_Asset_Health_IndicatorDimension ID of the Asset Health Indicator
Recorded DateRepresents the Date which the Indicator value was recorded at
Mvt_Created_Dt
Value SeqUnique sequence number for each recorded Indicator value
Asset Health Indi Hst Count
Normalized ValueRepresents the Value recorded for each indicator
DimensionCombination of Asset ID + Asset Name - Used or Search bars
OBJ_TYPERepresents 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 HSTFACT_ASSET_HEALTH_INDI_HST_BIFACT_ASSET_HEALTH_INDI_HSTOn Line