Skip to Content
0
Former Member
Jul 19, 2013 at 01:35 PM

Question regarding Multi provider

15 Views

I have

1. Old invoices Cube

2. New invoices Cube

3. Todays Cost DSO

I am trying to get the cost variance.

So I created

1. Infoset(old Invoices- costs)

2. Infoset(New Invoices - costs)

I created a multi provider on top. Everything is good. but since Costs(DSO) are in both the Infosets, they are adding up at the Multi provider level. How can I avoid this?

I cannot create a cube on this DSO because I want an Outer join in the Infoset.

Please suggest. Thank you all.