Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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