OTBI - Join/Union Subject Area Payables Transactions Real Time to Payables Installments Real Time
Summary:
Content (please ensure you mask any confidential information): We need to pull Due Date from Subject Area Installments Real Time against columns Invoice Number and Concatenated Segments (Distribution Combination) from Transactions Real Time in OTBI. As soon as we pull due date, it breaks the analysis.
Is there any Union that can be done between these two subject areas? Invoice Number is available in both SAs but Concatenated Segments (Transactions) and Due Date (Installments) are unique. Column matching needs to be one for one and I don't know if this combination is doable.
Version (include the version you are using, if applicable):