How to link Receivables - Customer Real Time and Receivables - Payment Schedules Real Time in OTBI
Summary:
I am wanting to create a report with certain bill-to customer information that is not located within the Receivables - Payment Schedules Real Time subject area, but is in the Receivables - Customer Real Time subject area. I have tried linking the 2 subject areas based on customer name, customer account number and many other fields that are located within both subject areas. Does anyone have any suggestion for how to link these two subject areas?
Content (required):
I am needing the account contact point type and account contact point value from the Receivables - Customer Real Time subject area. Both the Receivables - Customer Real Time and Receivables - Payment Schedules Real Time subject areas have the customer account number however the report crashes when I try to add this field in.
Version (include the version you are using, if applicable):
22A
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Hi,
I don't think it is possible to join these two subject areas as there doesn't seem to be a confirmed dimension. It is erring out when I tried combining.
One way is to create a BIP report if we know the backend base tables.
Thank you!
0