Skip to Content
0
Former Member
Mar 03, 2015 at 08:09 AM

multiprovider join? Possibilities

52 Views

Hi Everyone !

I have a requirement , This is just a sample .

1.cube

material ID Quantity

101 5

102 7

103 3




2.Cube


Material ID Price

101 10

102 8

103 25

104 30




Report



Material Quantity Price Sales Amount

101 5 10 50

102 7 8 56

103 3 25 75




report should not have Material ID = 104 , as there is not corresponding material ID in 1 st cube .

Using Infoset is not an option provided for me. This can be solved with a Multiprovider itseems , Please help!!