Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 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
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Which subject area in Oracle BI can help to retrieve Lead to Opportunity conversion data
Which subject area in Oracle BI can help to retrieve Lead to Opportunity conversion data for eg, Opportunity revenue of all the converted opportunities, # open opportunities converted from lead etc. I tried Sales-CRM Pipeline SA but it doesn't yield the opportunity related data. It however does give data for fields, # of leads converted, Lead revenue.
Also tried adding other SA's like Marketing-CRM leads and opportunities real time and others but no success.
Please suggest.
Thank you.
Answers
-
Check in the ETL and the RPD from source to target. Take your desired source table, follow it through the ETL, then the RPD from physical to presentation layer and you have it.
0 -
What version of apps?
Independent of that ... you might have to build your own Subject Area using the pre-built logical layer or you might have to customize both logical and physical layers to get what you want if you can't find pre-built. Be prepared!
0