This cube dimension represents the Linear Assets and is based on the IFS Applications dimension DIM_LINAST_LINEAR_ASSET. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Hierarchy | Description |
Description | NO | Description |
Design Status | NO | Design Status |
Item Class Id | NO | The identity of the item class used to hold failure analysis data |
Length | NO | Length + Unit Code Length |
Linear Asset | NO | Linear Asset Name + Description |
Linear Asset Name | NO | Linear Asset Name |
Linear Asset Revision No | NO | Revision Number of the Linear Asset |
Linear Asset Type | NO | Linear Asset Type Code |
Operational Status | NO | Operational Status Description |
Class | Class of the Design Object connected to Linear Asset | |
Design Object Id | Design Object ID Connected to Linear Asset | |
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 |
Cube Name |
MAINTENANCE |
BI Access View | BI component | Recommended Source Type |
DIM_LINAST_LINEAR_ASSET_BI | LINADI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.143 Load IFSAppl_DIM_LINAST_LINEAR_ASSET_BI.dtsx | IFSAppl_DIM_LINAST_LINEAR_ASSET_BI |
T - DW | 2.1.135 Load Dw_DIM_LINAST_LINEAR_ASSET.dtsx | Dw_DIM_LINAST_LINEAR_ASSET |
L - DM | 3.1.135 Load Dm_DIM_LINAST_LINEAR_ASSET.dtsx | Dm_DIM_LINAST_LINEAR_ASSET |