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.
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
Could you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test environments expected to be updated on August 7, followed by the production release on August 21, we have a limited window to review and assess any potential…
