Skip to Content
0
Former Member
Apr 19, 2011 at 12:37 PM

/SAPAPO/TSCUBE tcode - storage bucket profile issue

74 Views

Dear All,

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

Ehsan Ahmed