Question:
Hello,
Our BW dev. box is configuered and loaded with the Master Data already from R/3. However, I need to load up some obsolete master customer data(46 records). The columns for each record are:
0CUSTOMER, 0NAME, 0STREET, 0CITY, 0POSTAL_CD, 0SALES_DIST, 0SALES_OFF and 0SALES_GRP.
I do know the steps to load data into an InfoProvider from a Flat file. But, my question is, how do I load Sales related data into 0CUSTOMER(0SALES_DIST, 0SALES_OFF and 0SALES_GRP).
In the Query, there is a characteristic "Address" but I cannot find a suitable InfoObject for it. Obviously, it comprises of 0STREET, 0CITY, 0POSTAL_CD. When I build a Query (after having the 0STREET, 0CITY, 0POSTAL_CD objects filled with data through the Flat file into 0CUST_SALES object) Address info. is not showing in the executed query workbook.
Thanks for your help.
Dan
Answer:
If I understand correctly this is a question about extending R/3 master data from an external source.
One approach would be to load a second 'customer' object with the addtional attributes. If you have the luxury of being able to modify your cubes (you can reload them) you could add this characteristic (and navigable attributes) and simply assign the value of 0CUSTOMER in the update rules.
If you can't modify your cubes you could also extend 0CUSTOMER with the additonal attributes, then derive them from the new customer in the transfer rules (requires code). Alternatively you could use an InfoSet to JOIN the existing cube to the new customer master data, but you would need to write new queries.
In the Query, there is a characteristic "Address" but I cannot find a suitable InfoObject for it. Obviously, it comprises of 0STREET, 0CITY, 0POSTAL_CD. When I build a Query (after having the 0STREET, 0CITY, 0POSTAL_CD objects filled with data through the Flat file into 0CUST_SALES object) Address info. is not showing in the executed query workbook.
It should be possible to make display attributes visible from the context menu of 'Address' in Query Designer. Have I misunderstood the problem?