Cube Dimension - Discovery

This cube dimension represents the work order discovery code and is based on the IFS Applications dimension DIM_DISCOVERY. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Discovery NO Key. Built as DESCR, i.e. the description of the discovery (CODE)
DiscoveryCode NO Represents the ERR_DISCOVER_CODE (also equal to CODE), i.e. workorder discovery code

USED BY CUBE

Cube Name
MAINTENENCE

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.066 Load IFSAppl_DIM_DISCOVERY_BI.dtsx IFSAppl_DIM_DISCOVERY_BI
T - DW 2.1.066 Load Dw_DIM_DISCOVERY.dtsx Dw_DIM_DISCOVERY
L - DM 3.1.066 Load Dm_DIM_DISCOVERY.dtsx Dm_DIM_DISCOVERY