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:
Flat File for second Source System:
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
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...........
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 .
if u assign the two data source for master data loading then keyfield should be same for both data sources...
1. materialid mat. name
2. material id mat color
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...
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,
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..