- This cube dimension represents the balance version, which is the unique identity that is used in the Balance Transfer process as well as when entering manual adjustment journals. It is also used to connect appropriate currency rates to the consolidation process. The dimension is based on the IFS Applications dimension DIM_REP_BALANCE VERSION. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Natural parent is master company, i.e. each master company has its own set of parallel structure values.
Attribute | Hierarchy | Description |
Conn Balance Version | NO | Connected Balance Version description |
Balance Version Code | NO | Represents the CODE of the dimension, i.e. Balance version code value |
Balance Version Desc | NO | Represents the DESCRIPTION of the Structure value |
Sim Balance Version | NO | Simulated Balance Version description |
Source Type | NO | Source Type description. i.e. Actual, Planning etc. |
Cube Name |
GROUP CONSOLIDATION |
BI Access View | BI Component | Recommended Source Type |
DIM_PAR_CONSOL_STRUCTURE_BI | GROCDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.171 Load IFSAppl_DIM_REP_BALANCE_VERSION_BI.dtsx | IFSAppl_DIM_REP_BALANCE_VERSION_BI |
T - DW | 2.1.171 Load Dw_DIM_REP_BALANCE_VERSION.dtsx | Dw_DIM_REP_BALANCE_VERSION |
L - DM | 3.1.171 Load Dm_DIM_REP_BALANCE_VERSION.dtsx | Dm_DIM_REP_BALANCE_VERSION |