Issue Using Two Subject Areas in a Single OTBI Analysis to Bring Budget and End Of The Day Balance. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue Using Two Subject Areas in a Single OTBI Analysis to Bring Budget and End Of The Day Balance.

edited Aug 27, 2025 2:02PM in Reporting and Analytics for ERP

We are trying to build an OTBI analysis that contains Ending balances and End Of The Balance(EOD) related transactions within a period.
To achieve this, we are using two subject areas in the same OTBI analysis.
Subject Areas Used :
General Ledger: Balances Real Time
General Ledger: Average Daily Balances Real Time

Requirements:
We need to fetch

  1. End of the Day Balance column - based on accounting date with the filter condition scenario as 'Actual'
    Formula used: FILTER("General Ledger - Average Daily Balances Real Time"."Daily Balances"."End of Day Balance" USING (DESCRIPTOR_IDOF("General Ledger - Balances Real Time"."Scenario"."Scenario") = 'Actual'))
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!