Skip to Content
0
Former Member
Jul 21, 2008 at 04:56 PM

Historical Changes in the info Cube

29 Views

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