What's new in Customer Journeys?

Connect and learn more!
Unable to join Invoice and Procurement Subject Area in OTBI Analysis — 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

Unable to join Invoice and Procurement Subject Area in OTBI Analysis

Accepted answer
edited May 19, 2020 1:57PM in Reporting and Analytics for ERP 8 comments


I have a requirement to fetch the Purchase order details with corresponding invoice details. Therefore i need to connect two subject areas to fetch the required fields.


Not all invoice information is available in the "Procurement - Procure to Pay Real Time" Subject Area and not all Procurement related information is available in "Payables Invoices-Transactions Real Time" Subject Area.

Please let me know how to connect these two subject areas.

Approaches Tried:

  1. Using Measure columns from both subject areas- Received Cross Joined Data
  2. Enabled Dimensionality feature in Advanced Tab- No effect in joining

Below Error received when just displaying only two columns purchase order number and invoice number from corresponding subject areas:

Howdy, Stranger!

Log In

To view full details, sign in.


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