Hello EveryBody
Currently, we can have the same customer in two different sales channels, for example, the customer Target can buy in the supermarket channel and also in the distributor channel, but it is possible, that after some months, this customer change the distributor channel and begin to buy using the retail channel. If we see this behavior in a table
Information in SAP 6 ECC
Target Sales
Channel <Jan> <Feb> <Mar> <Apr> <May> <Jun> <Total>
Supermarket <20> <25> <30> <28> <24> <31> <158>
Distributor <10> <12> <21> <N/A> <N/A> <N/A> <43>
Retail <N/A> <N/A> <N/A> <9> <7> <6> <22>
But the Users wants to move all the information before the change to the new channel, they want to see this behavior in BI
Information in BI
Target Sales
Channel <Jan> <Feb> <Mar> <Apr> <May> <Jun> <Total>
Supermarket <20> <25> <30> <28> <24> <31> <158>
Distributor <N/A> <N/A> <N/A> <N/A> <N/A> <N/A> <N/A>
Retail <10> <12> <21> <9> <7> <6> <65>
This means, the data of 3 first months of Distributor went to the 3 first months of retail.
Do you know some automatically or manually process that can do this?...I mean, to reasign all the historic data from the inactive channel to the new active channel automatically? How can identify to which channel i must to assign the historical information?
Thanks for your help
Edited by: Oscar M Lopez J on Jul 21, 2008 6:56 PM