Need to create project revenue OTBI report with 'Revenue in Ledger Currency' attribute
Summary:
We have a requirement to create an OTBI report to retrieve all the Revenue Distributions in Project Billing. Specifically, we're looking to include details such as revenue in ledger currency and the corresponding ledger currency for each revenue distribution.
However, 'Revenue in Ledger Currency' attribute do not appear to be available in the "Project Billing - Revenue Real Time" subject area and I could see only below attributes for Revenue Amount.
Has anyone encountered this/similar issue and knows how to retrieve this specific detail in an OTBI report when attribute isn't available in OTBI but this data is being stored in Db.