Hi all:
I have 1 Multiprovider that contains 2 cubes (sales and delivery). They have only 3 Chars in common. (one have around 10 Chars and the other has 3 Chars) When I display the data in the Multiprovider, it shows the data form one cube and it appends at the end, the data from the other infocube. I mean, if one cube has 50 records and the other has 80 records, the multiprovider display 130 records. So is not doing the merging to show the following:.
Order, Item, Qty Sold, Qty Delivered.......
Any idea or tip?
Regards,