Link between 2 subject ares

Question

link between

CRM interactions real time and order management - order headers real time

CRM interactions real time and Receivables transactions real time

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/27367/link-between-2-subject-ares

Hi @Ani_tha,

Welcome to the Oracle Analytics Community!

Quick Question: Do you have any matching keys between those 2 subject areas?

If Yes, then you can join those subject area using the Logical SQL Approach.

Please find below posts which might be useful for the initial starting point and the understanding.

C Logical SQL Reference

OTBI Resources — Cloud Customer Connect

https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/advanced-techniques-examine-logical-sql-statements-analyses.html

OTBI Logical SQL complex query assembler - Updated to 10 subject areas — Oracle

Hope this help.

Thank you.

RVohra · Answer

I do not think you can directly join Sales – CRM Interactions Real Time with Receivables – Transactions Real Time.

Each subject area pulls from separate transactional schemas within Fusion (Sales Cloud vs. Financials Cloud), and OTBI doesn’t have a shared join key across them (like Opportunity ID to AR Invoice ID).