Cube Dimension - Risk Problem

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

Attributes

Attribute Hierarchy Description
Code NO Risk Problem Sequence
Risk Analysis Category NO Risk Analysis Category Id - Risk Analysis Category Description
Risk Analysis Header NO Risk Analysis ID - Revision
Risk Problem NO Risk Problem ID - Problem Title
Risk Problem Id NO Risk Problem ID
Risk Problem Title NO Problem Title
Sub Category NO Sub Category
RiskProblemHy YES Hierachy defined as "Risk Analysis Header" -> "Risk Analysis Category" -> "Risk Problem" 

USED BY CUBE

Cube Name
RISK ANALYSIS

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.138 Load IFSAppl_DIM_RISK_PROBLEM_BI.dtsx IFSAppl_DIM_RISK_PROBLEM_BI
T - DW 2.1.138 Load Dw_DIM_RISK_PROBLEM.dtsx Dw_DIM_RISK_PROBLEM
L - DM 3.1.138 Load Dm_DIM_RISK_PROBLEM.dtsx Dm_DIM_RISK_PROBLEM