I have a requirement where i need to disaggregate data into an keyfigure on the basis of factory calender. currently i'm receving consolidated flat file which contains data from multiple plants and each plant have its own factory calendar. & this needs to disaggregate/distribute into 0calweek and 0calday level.. these additional time characteristics are part of infocube.
The only way i can think of is using the time distribution functionality , create multiple update rules(each for factory calendar) and break the flat file into multiple flat files(each for a factory calendar) and load the data. This will work, but it needs lots of manual intervention.
Wondering can we use the same time distribution functionality for all incoming plant factory calendar data to distribute/disaggregate using single update rule instead of of going for multiple, please suggest me if you have any other ideas..
The flat file contains following records.
Plant ;Resource ;0calmonth;Factory calendar;Kfig
P1 ;R1 ;062005 ;Z1 ;100
P2 ;R2 ;062005 ;Z2 ;100
Any help will be greately appreciated...