Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 232 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Link between 2 subject ares
link between
CRM interactions real time and order management - order headers real time
CRM interactions real time and Receivables transactions real time
Answers
-
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).
0 -
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.
OTBI Resources — Cloud Customer Connect
OTBI Logical SQL complex query assembler - Updated to 10 subject areas — Oracle
Hope this help.
Thank you.
0
