Cube Dimension - Risk Analysis Header

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

Attributes

Attribute Hierarchy Description
Analysis Method NO Analysis Method
Owning Organisation Name NO Org Name
Restricted Sub Cat NO Restricted Categories
Review Period NO Review Period
Revision NO Revision
Risk Analysis Header NO Risk Analysis ID - Revision
Risk Analysis Header Code NO Risk Analysis Sequence
Risk Analysis Id NO Risk Analysis ID
Risk Comment NO Risk Comment
Risk Owner Name NO Owner Name
State NO State

USED BY CUBE

Cube Name
RISK ANALYSIS

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.132 Load IFSAppl_DIM_RISK_ANALYSIS_HEADER_BI.dtsx IFSAppl_DIM_RISK_ANALYSIS_HEADER_BI
T - DW 2.1.132 Load Dw_DIM_RISK_ANALYSIS_HEADER.dtsx Dw_DIM_RISK_ANALYSIS_HEADER
L - DM 3.1.132 Load Dm_DIM_RISK_ANALYSIS_HEADER.dtsx Dm_DIM_RISK_ANALYSIS_HEADER