Skip to Content
0
Former Member
Apr 23, 2009 at 07:17 PM

Design question for Multiprovider or Creating a filter

18 Views

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