Cube Dimension - Risk Project Type

This cube dimension represents the Risk Project Types and is based on the IFS Applications dimension DIM_RISK_PROJECT_TYPE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Hierarchy Description
Code NO Project Type ID
Risk Project Type NO Project Type ID - Project Type Description
Risk Project Type Description NO Project Type Description

USED BY CUBE

Cube Name
RISK ANALYSIS

ETL Information

BI Access View Recommended
Source Type
BI component
DIM_RISK_PROJECT_TYPE_BI RISKDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.139 Load IFSAppl_DIM_RISK_PROJECT_TYPE_BI.dtsx IFSAppl_DIM_RISK_PROJECT_TYPE_BI
T - DW 2.1.139 Load Dw_DIM_RISK_PROJECT_TYPE.dtsx Dw_DIM_RISK_PROJECT_TYPE
L - DM 3.1.139 Load Dm_DIM_RISK_PROJECT_TYPE.dtsx Dm_DIM_RISK_PROJECT_TYPE