Model: Maintenance - Specifications for Dimension Table: LINEAR ASSET

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

This model dimension represents the Linear Assets and is based on the IFS Cloud dimension DIM_LINAST_LINEAR_ASSET. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Description (where applicable)
Class Class of the Design Object connected to Linear Asset
Description Description
Design Object Id Design Object ID Connected to Linear Asset
Design Status Design Status
Item Class Id The identity of the item class used to hold failure analysis data
Length Length + Unit Code Length
Linear Asset Linear Asset Name + Description
Linear Asset Name Linear Asset Name
Linear Asset Revision No Revision Number of the Linear Asset
Linear Asset Type Linear Asset Type Code
Operational Status Operational Status Description
Plant Plant of the Design Object connected to the Linear Asset
Revision Status The Status of the Linear Asset Revision
Site Site Code
Unit Code Length The unit of measure used for the linear asset length
Unit Code Offset The unit of measure used for the offsets

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
LINEAR ASSET DIM_LINAST_LINEAR_ASSET_TM DIM_LINAST_LINEAR_ASSET_BI DIM_LINAST_LINEAR_ASSET On Line