Cube Dimension - Consolidation Trans Type

This cube dimension represents the group consolidation transaction type and is based on the IFS Applications dimension DIM_CONSOL_TRANS_CODE_TYPE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

The transaction type is a stand alone item, independent of company.

ATTRIBUTES

Attribute Hierarchy Description
Consolidation Trans Type NO Key. Built as CODE + ' - ' + DESCRIPTION
Consolidation Trans Type Code NO Represents the CODE of the dimension, i.e. Transaction Type Code value
Consolidation Trans Type Desc NO Represents the DESCRIPTION of the Transaction Type

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_CONSOL_TRANS_CODE_TYPE_BI GROCDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.175 Load IFSAppl_DIM_CONSOL_TRANS_CODE_TYPE_BI.dtsx IFSAppl_DIM_CONSOL_TRANS_CODE_TYPE_BI
T - DW 2.1.175 Load Dw_DIM_CONSOL_TRANS_CODE_TYPE.dtsx Dw_DIM_CONSOL_TRANS_CODE_TYPE
L - DM 3.1.175 Load Dm_DIM_CONSOL_TRANS_CODE_TYPE.dtsx Dm_DIM_CONSOL_TRANS_CODE_TYPE