Model: Maintenance - Specifications for Dimension Table: ASSET HEALTH DIMENSION
Attributes
| Attribute |
Description (where applicable) |
| Asset Description |
Represents the Description of the Asset |
| Asset Group |
Represents the Asset Group (Equipment/Linea Asset/Etc.) |
| Asset Id |
Asset ID (Object ID for equipment objects, etc) |
| Asset Name |
Represents the Name of the Asset |
| Asset Type |
Represents the Type of Asset in the Asset Group |
| Asset Type Description |
Description of the Asset Type |
| Company |
Represents the Company ID which the asset belongs to |
| Contract |
Represents the Site ID which the asset belongs to |
| ID |
Key ID for the Asset - Combination of Object Seq + Asset Group |
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 DIMENSION |
DIM_ASSET_HEALTH_TM |
DIM_ASSET_HEALTH_BI |
DIM_ASSET_HEALTH |
On Line |