Cube Dimension - Balance Version

- 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.

ATTRIBUTES

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.

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

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