Cube Dimension - Risk Response

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

Attributes

Attribute Hierarchy Description
Code NO Risk Response Sequence
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 Problem NO Risk Problem ID - Problem Title
Risk Response NO Risk Response ID - Description
Risk Response Description NO Description
Risk Response Id NO Risk Response ID
Risk Response Status NO Status
Risk Response Type NO Response Type
Secondary Risk NO Secondary Risk
RiskActionHy YES Hierachy defined as "Risk Analysis Header" -> "Risk Analysis Category" -> "Risk Problem" -> "Risk Consequence" -> "Risk Response"

USED BY CUBE

Cube Name
RISK ANALYSIS

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.140 Load IFSAppl_DIM_RISK_RESPONSE_BI.dtsx IFSAppl_DIM_RISK_RESPONSE_BI
T - DW 2.1.140 Load Dw_DIM_RISK_RESPONSE.dtsx Dw_DIM_RISK_RESPONSE
L - DM 3.1.140 Load Dm_DIM_RISK_RESPONSE.dtsx Dm_DIM_RISK_RESPONSE