link between
CRM interactions real time and order management - order headers real time
CRM interactions real time and Receivables transactions real time
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).
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.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
