Cube Dimension - Consolidated Balance Detail FHY

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.

Sort Order of attributes Structure Node and Structure Node Sublevel are based on the definition of the Consolidation Structure in IFS Applications.

 

ATTRIBUTES

Attribute Hierarchy Description
Balance Version ID NO Balance Version ID
Equity Elimination NO TRUE/FALSE
No  Elimination NO TRUE/FALSE
Profit Elimination NO TRUE/FALSE
Matching ID NO Represents the matching ID of the transaction
Structure ID NO Represent the Consolidation Structure ID - HIDDEN
Structure Node NO Displayed as SortOrder-Structure Node Code Desciption - HIDDEN
Structure Node Sub Level NO Displayed as SortOrder-Sub Level Code Description- HIDDEN
Year Period NO Represents the Consolidation Year and Period of the Consolidation Structure. The structure can vary over time - HIDDEN.
ConsBalDetFHy YES Hierarchy built as Structure ID  - Balance Version ID - Year Period - Structure Node - Structure Node Sub Level

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

BI Access View BI Component Recommended
Source Type
FACT_CONSOL_BALANCE_BI GROCFT On Line

 

Please refer to FACT_CONSOL_BALANCE