OTBI Payables Invoices to Subledger join

Content

We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger specific data(Subledger Accounting Journals Real Time). Currently dragging and dropping relevant dimensions from both these subject areas results in an error (even after selecting a measure column from each SA).

We want to know how the dimensions are to be selected from both these SA's (or another interlinking SA if necessary) so that they join without error, and also show correct journal amounts of invoice that are not multiplied.

Thanks.