Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
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
58
Views
7
Comments
edited May 19, 2020 1:57PM in Reporting and Analytics for ERP 7 comments

Summary

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.

Content

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.

Register

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