Cube Dimension - Risk Consequence

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

Attributes

Attribute Hierarchy Description
Code NO Risk Consequence Sequence
Notes NO Notes
Risk Analysis Category NO Risk Analysis Category Id - Risk Analysis Category Description
Risk Analysis Header NO Risk Analysis ID - Revision
Risk Consequence NO Risk Consequence ID - Consequence Description
Risk Consequence Description NO Consequence Description
Risk Consequence Id NO Risk Consequence ID
Risk Problem NO Risk Analysis Problem Id - Risk Analysis Problem Description
Status NO Status
RiskConsequenceHy YES Hierachy defined as "Risk Analysis Header" -> "Risk Analysis Category" -> "Risk Problem" -> "Risk Consequence"

USED BY CUBE

Cube Name
RISK ANALYSIS

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.135 Load IFSAppl_DIM_RISK_CONSEQUENCE_BI.dtsx IFSAppl_DIM_RISK_CONSEQUENCE_BI
T - DW 2.1.135 Load Dw_DIM_RISK_CONSEQUENCE.dtsx Dw_DIM_RISK_CONSEQUENCE
L - DM 3.1.135 Load Dm_DIM_RISK_CONSEQUENCE.dtsx Dm_DIM_RISK_CONSEQUENCE