This cube dimension represents the group consolidation balance fact for transcations which are NOT of types 'CONSOLIDATED_BALANCE','CURR_EFFECT_OPENING','CURR_EFFECT_DURING_YEAR' and 'CURR_EFFECT_COUNTER_POST'. The dimension is based on the IFS Applications fact FACT_CONSOL_BALANCE.
The dimension contains only one hierarchy used for browsing through the the balance structure. The structure is based on the last consolidation period.
Sort Order of attributes Structure Node and Structure Node Sublevel are based on the definition of the Consolidation Structure in IFS Applications. These attributes are displayed as Sort Order-Structure Node and Sort Order-Structure Node Sub Level respectively.
Attribute | Hierarchy | Description |
ConsBalDetSHy | YES | Hierarchy built as Structure ID - Balance Version ID - Structure Node - Structure Node Sub Level |
Cube Name |
GROUP CONSOLIDATION |
BI Access View | BI Component | Recommended Source Type |
FACT_CONSOL_BALANCE_BI | GROCFT | On Line |
Please refer to FACT_CONSOL_BALANCE