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.