Time Based Disaggregation

[former_member546432]

Hi All,

I need help with respect to Time Based Disaggregation. I am converting my Monthly data into Weekly Data. I am converting my 12 months data to 52weeks starting from 01.06.2012.

I am enclosing the file after the conversion. I am unable to determine how this dis aggregation happening.

Could you anyone help on logic of calculation for Time Base Disaggregation with respect to data I have enclosed.

Also someone explain on all other different type of time disaggregation also with above example?

Thanks,

Best Regards,

Bhaskar

Monthly Data

	Unit	M 06.2012	M 07.2012	M 08.2012	M 09.2012	M 10.2012	M 11.2012	M 12.2012	M 01.2013	M 02.2013	M 03.2013	M 04.2013	M 05.2013
Additional Field 1	EA		100	500	920	1330	1740
Additional Field 2	EA
Additional Field 3	EA	1500	3000	4500	1500	3000	4500	1500	3000	4500	1500	3000	4500
Forecast	EA

Result After Time Based Disagg

	Unit	W 22.2012	W 23.2012	W 24.2012	W 25.2012	W 26.2012	W 27.2012	W 28.2012	W 29.2012	W 30.2012	W 31.2012	W 32.2012	W 33.2012	W 34.2012	W 35.2012	W 36.2012	W 37.2012	W 38.2012	W 39.2012	W 40.2012	W 41.2012	W 42.2012	W 43.2012	W 44.2012	W 45.2012	W 46.2012	W 47.2012	W 48.2012	W 49.2012	W 50.2012	W 51.2012	W 52.2012	W 01.2013	W 02.2013	W 03.2013	W 04.2013	W 05.2013	W 06.2013	W 07.2013	W 08.2013	W 09.2013	W 10.2013	W 11.2013	W 12.2013	W 13.2013	W 14.2013	W 15.2013	W 16.2013	W 17.2013	W 18.2013	W 19.2013	W 20.2013	W 21.2013
Additional Field 1	EA					4	24	22	22	22	86	115	110	115	141	217	213	215	214	301	298	299	298	370	406	403	404	291
Additional Field 2	EA	579
Additional Field 3	EA	150	352	349	349	397	679	676	678	677	919	1018	1015	1016	826	351	349	350	349	678	677	678	678	889	1050	1050	1050	846	339	339	339	339	629	678	676	678	869	1125	1125	1125	787	339	339	339	339	701	699	700	701	925	1017	1016	1015
Forecast	EA	580

[Former Member]

hi Bhaskar,

Before getting into details, just want to check to check with you, when you are saying 'help me out in understanding this disaggregation', kindly check the below example, hope it helps:

http://help.sap.com/saphelp_scm70/helpdata/en/26/53f1f3758211d398490000e8a49608/content.htm

Bye,

Sandeep

[claire_yang]

Hi,

I guess you just have some confusion with the data disaggregation when the week overlaps 2 months.

The data disaggregation depends on the storage bucket profile how data is saved in liveCache. If there are mixed periodicities of e.g. M and W then the data needs to be saved in technical buckets to distinguish overlapping weeks between two months.

You should display the data in technical buckets first, then check the F1 help for different disaggregation method. You will kjnow how the the data is disaggregated. 

To display the technical buckets, check note 737230.

Claire

[former_member546432]

Hi Claire,

Thanks a lot for the information. My storage Bucket Profile has both Week and Month but I am using a complete Month data in my Time Bucket Profile. I am using 24Months Hist Data and 18Months Forecast.

Now for the business requirement, we need to display the some of the Monthly data into Weekly data. As you know in the Interactive Planning Book there is option to convert the Monthly data to Weekly Data. I using the Time Bucket Profile: 9A52WEEKS  starting from period 01.06.2012. When I performed this logic, the above disaggregation value came as a result. I am not understanding the fact how this value got disaggregated?

Kindly help me out in understanding this disaggregation.

Thanks,

Best Regards,

Bhaskar