Cube Dimension - Consolidated Balance Detail SHy

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.

ATTRIBUTES

Attribute Hierarchy Description
ConsBalDetSHy YES Hierarchy built as Structure ID  - Balance Version ID - 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