Model: Maintenance - Specifications for Dimension Table: ASSET HEALTH INDI HST
Attributes
| Attribute |
Description (where applicable) |
| Asset Group |
Represents the Asset Group (Equipment/Linea Asset/Etc.) |
| Asset Health Indi Hst Count |
|
| Asset Type |
Represents the Type of Asset in the Asset Group |
| Dim_Asset_Health_Indicator |
Dimension ID of the Asset Health Indicator |
| Dim_Asset_Id |
Dimension ID for Asset ID |
| Dim_Asset_Type |
Dimension ID for Asset Type |
| Dimension |
Represents the Indicator Name |
| ID |
Key for each Indicator value recorded - Combination of Asset Group + Asset Type + Object Seq + Indicator
ID + Value Seq |
| Indicator Id |
Represents the ID of the Indicator |
| Indicator Type |
Represents the type of the Indicator |
| Indicator Type Desc |
Description of the Indicator Type |
| InvertNormalizedValue |
|
| Mvt_Created_Dt |
|
| Normalized Value |
Represents the Value recorded for each indicator |
| OBJ_TYPE |
Represents the Asset Type |
| Object Seq |
Represents a unique key for the Asset in the Asset Group |
| Recorded Date |
Represents the Date which the Indicator value was recorded at |
| Value Seq |
Unique sequence number for each recorded Indicator value |
USED BY MODEL(S)
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 |
| ASSET HEALTH INDI HST |
FACT_ASSET_HEALTH_INDI_HST_TM |
FACT_ASSET_HEALTH_INDI_HST_BI |
FACT_ASSET_HEALTH_INDI_HST |
On Line |