Cube Dimension - Event

This cube dimension represents maintenance event call code and is based on the IFS Applications dimension DIM_EVENT. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Call Code NO Represents the CALL_CODE  (also equal to CODE), i.e. maintenance event call code
Event NO Key. Built as DESCR i.e. the description of the maintenance event call code (CODE)

USED BY CUBE

Cube Name
MAINTENENCE

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.065 Load IFSAppl_DIM_EVENT_BI.dtsx IFSAppl_DIM_EVENT_BI
T - DW 2.1.065 Load Dw_DIM_EVENT.dtsx Dw_DIM_EVENT
L - DM 3.1.065 Load Dm_DIM_EVENT.dtsx Dm_DIM_EVENT