Cube Dimension - operational Status

This cube dimension represents maintenance operational status type and is based on the IFS Applications dimension DIM_OPERATIONAL_STATUS. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Operational Status NO Key. Built as DESCR i.e. the description of the maintenance operational status type (CODE)
Operational Status Code NO Represents the OP_STATUS_ID (also equal to CODE), i.e. maintenance operational status type

USED BY CUBE

Cube Name
MAINTENENCE

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_OPERATIONAL_STATUS_BI WODI Data Mart

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.071 Load IFSAppl_DIM_OPERATIONAL_STATUS_BI.dtsx IFSAppl_DIM_OPERATIONAL_STATUS_BI
T - DW 2.1.071 Load Dw_DIM_OPERATIONAL_STATUS.dtsx Dw_DIM_OPERATIONAL_STATUS
L - DM 3.1.071 Load Dm_DIM_OPERATIONAL_STATUS.dtsx Dm_DIM_OPERATIONAL_STATUS