Combining Two Data Sources

[Former Member]

HI Guys,

I am trying to link two data providers. one is Sales Cube and second is master data.

In master data we have listing of Customer and Materials. Customer A is listed for following materials. like Product X , Y and Z.

Now I want to show this matrix that customer is listed for three products and now I want to get the sales from sales cube to show sales

for customer A against all of these three Materials. even there is no sales I want to show.

kindly help me to achieve it.

Regards

[RamanKorrapati]

Hi,

Don't combine and not suggestable.

Becasue thosre are not transaction datas.

one is master data and another one is transaction data.

So master data you can load master data object and transaction data you can load to dso/cube.

Later you can do reporting cube/dso directly. you may get required results.

if need master data also then you can create multi provider on cube/dso and info object.

Do the proper identification and save,actiavte multi provider.

Later you can do reporting on MP.

Thanks

[Former Member]

Yes I created MultiProvider. Sales cube have Time dimension but info object done have time deamination. so when I said data of Jan.2014 it is not showing all the customer.