Skip to Content
0
Former Member
Dec 04, 2007 at 02:57 PM

BW CRM LEADS OPPORTUNITIES ACTIVITIES

14 Views

Hi experts,

I am working in CRM reports. We have a requirement where i need to give a report which shows the leads converted to opportunities and opportunities won as shown below.

<b>Country Campaign leads opps % to opp opps won</b>

I have leads and its status in one cube but i have opp status in another cube. These two are related with a Lead GUID. Can you tell me the best way to develope this report. From Opp data target i have to take only those opp. exactly which are in the same campaign and same country and the leads which are converted to opportunities. How can i achieve this?

Thanks

Kiran