Cube Dimension - Risk Impact Level

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

Attributes

Attribute	Hierarchy	Description
Code	NO	Impact Level ID
Cost Value Function	NO	Cost Value Function
Risk Impact Level	NO	Impact Level ID - Impact Level
Risk Impact Level Description	NO	Impact Level
Risk Impact Weighting	NO	Impact Weighting

USED BY CUBE

Cube Name

RISK ANALYSIS

ETL Information

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

ETL Step	File Name of SSIS Package	Table Name
E - Stage	1.1.136 Load IFSAppl_DIM_RISK_IMPACT_LEVEL_BI.dtsx	IFSAppl_DIM_RISK_IMPACT_LEVEL_BI
T - DW	2.1.136 Load Dw_DIM_RISK_IMPACT_LEVEL.dtsx	Dw_DIM_RISK_IMPACT_LEVEL
L - DM	3.1.136 Load Dm_DIM_RISK_IMPACT_LEVEL.dtsx	Dm_DIM_RISK_IMPACT_LEVEL