Cube Dimension - Linear Asset

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.

ATTRIBUTES

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

Used By Cube

Cube Name
MAINTENANCE

ETL Information

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