Cube Dimension - Risk Assessment Level

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

Attributes

Attribute Hierarchy Description
Code NO Assessment Level ID
Risk Assessment Level NO Assessment Level ID - Assessment Level
Risk Assessment Level Description NO Assessment Level
Risk Severity Rating Min NO Minimum Severity Rating

USED BY CUBE

Cube Name
RISK ANALYSIS

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.134 Load IFSAppl_DIM_RISK_ASSESSMENT_LEVEL_BI.dtsx IFSAppl_DIM_RISK_ASSESSMENT_LEVEL_BI
T - DW 2.1.134 Load Dw_DIM_RISK_ASSESSMENT_LEVEL.dtsx Dw_DIM_RISK_ASSESSMENT_LEVEL
L - DM 3.1.134 Load Dm_DIM_RISK_ASSESSMENT_LEVEL.dtsx Dm_DIM_RISK_ASSESSMENT_LEVEL