I have sales data in a infocube in Calendar day and Calendar month i.e. time characteristics 0CALDAY and 0CALMONTH are present in infocube.
I have a planning area with a storage bucket profile where weeks and months are ticked which means data is stored in the planning area in weeks.
Now, I am using tcode /SAPAPO/TSCUBE to copy sales data from Infocube to planning area. What I see is that the sales data is disaggregating in the month to all the weeks of that month. For example:
In Infocube, Sales for 9th Feb, 2011 is 20 ST
After executing the tcode /SAPAPO/TSCUBE, data is copied to the planning area as
1st Feb - 6th Feb - 4 ST
7th Feb - 13th Feb - 5 ST
14th Feb - 20th Feb - 5 ST
21st Feb - 27th Feb - 5 ST
28th Feb - 28th Feb - 1 ST
This is not my requirement. I want the data to be copied as
1st Feb - 6th Feb - 0 ST
7th Feb - 13th Feb - 20 ST
14th Feb - 20th Feb - 0 ST
21st Feb - 27th Feb - 0 ST
28th Feb - 28th Feb - 0 ST
Has anybody faced such an issue? Can you suggest a solution?
The time based disaggregation type is P for this time series key figure.
Thanks in advance