Financial Balance

The Financial Balance fact includes measures based on History - Dimension/Ledger Account Combination Totals (tfgld205) and Opening Balances - Combination of Dimension/Ledger/Currency (tfgld206).

Transformation of extracted data:

Archiving or deleting period totals

Archiving or deleting period totals will result in a value of zero for the complete financial period, and analysis cannot be executed anymore.

Therefore, we do not recommend running the Archive / Delete Period Totals (tfgld6206m000) session.

This diagram shows the star schema:

Financial balance star schema