FACT - CONSOL BALANCE SET ANALYSIS

This cube fact represents Balance sets  in General Legder in Financials and is based on the IFS Applications fact FACT_CONSOL_BAL_SET_ANALYS. Four pre-defioned balances ACT (Actual), BUD (Budget), CFC (Current Forecast) and NFC (Next Forecast) are defined in table Dm_FACT_CONSOL_BAL_SET_CONF_ANALYS. In table Dm_FACT_CONSOL_BAL_SET_ANALYS a fifth balance set can be defined by the user.

Note: Please refer to documentation of each cube to find out about attributes used in referenced cubes.

USED BY CUBE

Cube Name Product Area
GROUP CONSOLIDATION Financials

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.2.046 Load IFSAppl_FACT_CONSOL_BAL_SET_ANALYS_BI.dtsx IFSAppl_FACT_CONSOL_BAL_SET_ANALYS_BI
T - DW 2.2.046 Load Dw_FACT_CONSOL_BAL_SET_ANALYS.dtsx Dw_FACT_CONSOL_BAL_SET_ANALYS
L - DM 3.2.046 Load Dm_FACT_CONSOL_BAL_SET_ANALYS.dtsx Dm_FACT_CONSOL_BAL_SET_ANALYS
L - DM 3.2.046 Load Dm_FACT_CONSOL_BAL_SET_CONF_ANALYS.dtsx Dm_FACT_CONSOL_BAL_SET_CONF_ANALYS

SPECIAL INFO

This fact supports Reporting Date, i.e. a time dimension that can be used to when doing cross product/module reporting. The date chosen to connect the fact with the dimension is the start date of the accounting period for a balance. This date is also used when finding the currency rate for calculation of reporting currency amounts.