Question:
I have the following modeling scenario…
I am not able to map it in BW
Suppose I have a master data in the knvv table on the R/3 side as this
CustId Distribution Channel SalesOrg Division attribute1
1 A B D1
1 A S D1
2 A C D2
The entries in the above R/3 table is made only after the customer has bought a material
From that particular division.. which is stored in the MARA table for that material.
CustId Distribution Channel SalesOrg Division Material Fact1
1 A B D1 C
2 A C D2 A
1 A S D1 C
Suppose the division of the C is changed from D1 to D3..
Now on the R/3 side the change that will be there in the knvv table… irrespective of the distribution channel and sales organization…
CustId Distribution Channel SalesOrg Division attribute1
1 A B D3
1 A S D3
2 A C D2
The division is changed to D3 for every combination..
The change that will me made in the historical transactional data…
CustId Distribution Channel SalesOrg Division Material Fact1
1 A B D3 C
2 A C D2 A
1 A S D3 C
The division is changed to D3 for every customer that has bought that material in the past so that the marketing hierarchy can be picked from the knvv table..
The customer wants that the historical data should also be reflected through the new division that is change the previous division of the historical data also..
Is the ODS only soln for changing the division characteristic..
Or is there any way we can do this in the cube..
I cannot take division as a navigational attribute from the 0material because then how will I capture the marketing hierarchy for the old transactional data. when the division changes and we have to map the division in the old transactional data with the new division..since the surrogate keys for the 0cust_sales(which will be used the dimension as one of the characteristic) for the old combination of salesorg,distrchannel,division will already be present in the dimension table …
How do I go and change the surrogate keys…
We change the combination for division in the master data but how do I do this in the transactional data..
Answer:
Can please anyone help me on this???