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.
| Cube Name | Product Area |
| GROUP CONSOLIDATION | Financials |
| 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 |
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.