Unable to join Product management OTBI subject areas

Summary:

Hello Community,

I have a requirement where I need to pull the Royalty data from the "Where Used" part of PIM.

As part of that we are trying to join below subject areas but unable to get the data. Can you please let me know any possible solutions.

We have tried using measure columns from both subject areas but no luck.

Content (please ensure you mask any confidential information):

Subject Areas:

Product Management: Trading Partner Item Real Time

Product Management: Components Real Time

Product Management: Structures and Components Real Time

Version (include the version you are using, if applicable):