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.
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 |
Cube Name |
GROUP CONSOLIDATION |
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 |