Implementing Cloud Financials: From Empty Pod to Go-Live · Module 12 · Financial Reporting
The balances cube
Lesson 115 of 153 · 1 min
A multidimensional store of ledger balances, built for fast aggregation. Not a table you query — a structure you navigate. Its dimensions: ledger, accounting period, currency and currency type, amount type, scenario, and one dimension per chart of accounts segment. And here is where the hierarchy lesson pays off: the hierarchies you built are the cube's rollup structure. When the cube updates: posting refreshes balances, and hierarchy changes require publishing. Which is why a new account can be missing from a report even though the journal posted — the balance exists and nothing rolls it up. Amount type — period activity, year to date, project to date — is the most common cause of a report showing plausible but wrong numbers. And plausible-but-wrong is the dangerous category, because nobody checks a number that looks about right. Then currency type: entered, converted, translated — what each means and when each is…
The full lesson is part of the course
The video, the complete written lesson and the module quiz are included in Implementing Cloud Financials: From Empty Pod to Go-Live, with a certificate on completion and a fourteen-day refund window.