OTBI - Subject Area - General Ledger - Balances Real Time
Summary: General Ledger - Balances Real Time - can anyone confirm this works correctly with Budget and Actual data
I am trying to construct reconciliation queries against; General Ledger - Balances Real Time; for budgets and actuals, confirming the balances using smart view against the same cube.
I am using the best practise guide to construct queries, but still finding that the clients' intercompany segment is not showing any data, though its' 'tree' does.
I am also finding that some accounts / nominals show as null when pulled back without filters.
My question is is anyone using this subject area on a combination of budget and actual data and getting wholly valid resullts?