Multiple DataSource Assignment to One InfoSource(Urgent)

[Former Member]

Hi Experts,

I have a doubt regarding multiple datasource assignment to one infosource, plz can anyone help me in this regard. The problem is described below..................

I know that it is possible to assign more than one datasources to one infosource, but i am confusing at scenarios we will go for that. I am trying to assign in this way:

1. Created one infosource.

2. Assigned datasource to infosource using one PC Source System and maintained two fields in the transfer structure(Customer, Material) and activated.

3. For the same infosource i again assigned one more datasource with another PC Source System and maintained two more fields in the transfer structure(sales and quantity).

4.Then i scheduled the infopackges under each source system.

Flat File for first Source System:

Customer Material

C1 M1

C2 M2

Flat File for second Source System:

Quantity Sales

100 1000

200 2000

Data was loaded Successfully.(Status Message).

5. In Monitoring, in PSA it is showing the respective data in respective PSAs

But in infocube it is showing like

Customer Material Quantity Sales

C1 M1 000 000

C2 M2 000 000

-

---

300 3000

So, i need information is it right scenario for assigning the multiple DSs to one IS. If it is wrong then at what scenarios we will go for this assignment.

Thank in Advance...........

Regards

Ramakrishna Kamurthy

[Former Member · Accepted solution]

For the cube to know which customer and material to link with which sales and quantity figure you need to load that in that way. You can better consolidate the file at your end before loading. or else you may give the customer and material along with the sales quantity and value. I don't understand who you are geeting data in such way from two dirrerent sources. Please explain the complete senario why data is comming from two seperate source system and what data are avilable at both source system .

[Former Member]

hai,

if u assign the two data source for master data loading then keyfield should be same for both data sources...

Like...

1. materialid mat. name

M01 SILVER

2. material id mat color

m01 white

If u assign two data source for transactional then what are the key fields u having should be same for the other data source also...

like...

1. mat.id cus.id sales quantity

m01 c01 200

m02 c02 400

2. mat id cusid pur quantity price

m01 c01 100 1000

m01 c01 300 2000

thankz & regards,

prakasu

[Former Member]

Hi Ramakrishna,

your second flat file contain only Key performance data (that means only key figures) .. but second file does't contan any key fields..

but , you want to assign two data sources to a single info sorce means.. you need atleast one key field(Cust No or Mat No ).

so, plz keep any key field in the second file..and now load the data..

regards

@jay