Question:
I have the following modelling scenario
I want to pick up the marketing hierarchy for the customer i.e from the 0cust_sales infoobject (sales office,sales gp,...)
Suppose a customer buys a material from a division A. Then the record for the customer with that same division A along with the marketing hierarchy has to be present in the knvv table so that 0cust_sales datasource can pick it.
if the record is not present the new record will be created.
If after sometime the division of this material changes to B then for all the customers there will be a new record in the knvv table with the division as B along with the marketing hierarchy.
In the transactional data too there will be a change in the division value for all the customers who have bought this material from the previous division.
Now I have 0customer infocube
I brought into it 0cust_sales infoobject to pick up the marketing hierarchy and mapped it to 0sold_to.
now when the scenario for the change in division will take place how will i map it in BW???
because the surrogate keys for the 0cust_sales will be generated for the previous transactional data in the dimension.
should i change the the master data explicitly i.e change the key component "division" of the 0cust_sales so that the previously genmerated surrogate keys remain intact.
or is there any other way to model this scenario...
Regards
sHIKHER
Answer:
Can anyone please help me on this..
CHC,EL Belgio
Answer:
I think u can write a routine in 0cust_sales to check for change in division and assign to another infoobject(say Zdivision).
Mn