Cube Dimension - Risk Action

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

Attributes

Attribute Hierarchy Description
Code NO Risk Action Sequence
Risk Action NO Represents the CODE + ' - ' + ACTION_DESCRIPTION related to a risk action
Risk Action Description NO Description
Risk Action Id NO Risk Action Unique Sequence
Risk Action Note NO Notes
Risk Action Status NO Status
Risk Analysis Category NO Risk Analysis Category Id - Risk Analysis Category Description
Risk Analysis Header NO Risk Analysis ID - Revision
Risk Consequence NO Risk Analysis Consequence Id - Risk Analysis Consequence Description
Risk Problem NO Risk Analysis Problem Id - Risk Analysis Problem Description
Risk Response NO Risk Analysis Response Id - Risk Analysis Response Description
RiskActionHy YES Hierachy defined as "Risk Analysis Header" -> "Risk Analysis Category" -> "Risk Problem" -> "Risk Consequence" -> "Risk Response" -> "Risk Action"

USED BY CUBE

Cube Name
RISK ANALYSIS

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.130 Load IFSAppl_DIM_RISK_ACTION_BI.dtsx IFSAppl_DIM_RISK_ACTION_BI
T - DW 2.1.130 Load Dw_DIM_RISK_ACTION.dtsx Dw_DIM_RISK_ACTION
L - DM 3.1.130 Load Dm_DIM_RISK_ACTION.dtsx Dm_DIM_RISK_ACTION