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?