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

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'))