Hi Guyz,
I have requirement to create a report on CRM Leads and Opportunities cube.
The req is to report which leads turned into opportunities. The way I see it is the opportunities cube has info object "Preceding Lead GUID" which is same as "Lead GUID" in Lead cube.
So I can use this to report particular leads turned into opportunities.
Now while designing the report I will create a multiprovider over Leads and Opportunities cubes and have all required fields for report in it. But how do it do it.
This is a design question.
1) Do I write a routine for multiprovider to create a single record where both GUID's are same?
2) Or can I do that in report creating a filter saying where the GUID's are same.
3) Or should I follow some other approach.
Your inputs will be greatly appreciated.
Thanks