Cube Dimension - Performed Action

This cube dimension represents maintenance performed action identity and is based on the IFS Applications dimension DIM_PERFORMED_ACTION. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Performed Action NO Key. Built as DESCR i.e. the description of the maintenance performed action identity (CODE)
Performed Action Code NO Represents the PERFORMED_ACTION_ID  (also equal to CODE), i.e. maintenance performed action identity

USED BY CUBE

Cube Name
MAINTENENCE

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.070 Load IFSAppl_DIM_PERFORMED_ACTION_BI.dtsx IFSAppl_DIM_PERFORMED_ACTION_BI
T - DW 2.1.070 Load Dw_DIM_PERFORMED_ACTION.dtsx Dw_DIM_PERFORMED_ACTION
L - DM 3.1.070 Load Dm_DIM_PERFORMED_ACTION.dtsx Dm_DIM_PERFORMED_ACTION