Cube Dimension - Reporting Trans Type

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

Natural parent is company, i.e. each master company has its own set of reporting trans type values.

ATTRIBUTES

Attribute Hierarchy Description
Reporting Trans Type Code NO Represents the CODE of the dimension, i.e. Trans Type Code value
Reporting Trans Type Desc NO Represents the DESCRIPTION of the Reporting Trans Type value
Reporting Trans Type Code Desc NO Built as CODE + ' - ' + DESCRIPTION
Reporting Trans Type Function NO Represents the function type type of the transaction
Par Struct Sub Level Type NO Represents the node type of the Structure Node

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.187 Load IFSAppl_DIM_REPORT_TRANS_TYPE_BI.dtsx IFSAppl_DIM_REPORT_TRANS_TYPE_BI
T - DW 2.1.187 Load Dw_DIM_REPORT_TRANS_TYPE.dtsx Dw_DIM_REPORT_TRANS_TYPE
L - DM 3.1.187 Load Dm_DIM_REPORT_TRANS_TYPE.dtsx Dm_DIM_REPORT_TRANS_TYPE