Unable to join Invoice and Procurement Subject Area in OTBI Analysis
SummaryI 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.
- Using Measure columns from both subject areas- Received Cross Joined Data
- 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: