Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OTBI Analysis, Join Project Number to Contract Agreement Amount
Hello, New Reporting analyst here. I'm trying to build a report to group together the agreements and contracts by project. I would like to know if I can join the following without going to BIP. Project Number to Contract Agreement Amount and Release Amount
I believe Project number is from "Procurement - Purchasing Real Time"
and
Contract Agreement > Contract Agreed Amount (Transaction Currency) is from "Procurement - Purchasing Agreements Real Time"
OTBI Analysis, Master / Child, or Dash Board. I need to export to excel these fields combined if possible.
Answers
-
Hi @TrevorM,
Welcome to the Oracle Analytics Community!
QQ: How are you joining those 2 subject areas?
Logical SQL approach will be the best way to achieve your requirement.
Thank you.
0 -
Here is some docs which might be useful.
HCM – OTBI Office Hour March 2020 — Cloud Customer Connect
Thank you.
0 -
Hi @TrevorM , Welcome to the Oracle Analytics Community and asking the question in the forum.
OTBI subject areas can only be combined if Oracle has defined conformed dimensions between them. In your case, looks like there is no common dimension in terms of
- Project Number from Procurement – Purchasing Real Time
with - Contract Agreement Amount from Procurement – Purchasing Agreements Real Time
There is possibility that in the database they relate but if OTBI doesn’t expose that relationship then it is not possible.
I would still suggest working with Oracle Support via SR because they might reach out to Product Team and they can confirm if it is currently possible via some other SAs or other workarounds.
Hope it helps!
0 - Project Number from Procurement – Purchasing Real Time
