Period Weight Factor

[sureshkumar_vaniyasekar]

Hello Experts,

I was trying to understand the period weight factor concepts but could not be able to understand it though I have gone through lot of SAP documents, blogs and forums. Could you please help to understand this concept (Disaggregation from Year to Month, Month to Week, Week to Technical Week, Week to Days, etc) with examples as below,

1. How to maintain the values of different Attributes in Time periods such as DAYWEIGHT, WEEKWEIGHT, MONTHWEIGHT, MONTHOFQUATER & WEEKOFQUATER.

2. How does period factor concept work with example?

Please let me know if there is any document available on this topic.

Thank you in advance!

Regards,

SureshKumar V

[former_member804657]

Hi Sureshkumar,

All the period weight factors are maintained in the time profile as an attribute. You can find the prefill time profile template (from SAP IBP standard - Data Integration App) to load in your Planning Area (if there's no prefill template then you need to prepare for the weight calculations by excel etc.). This period weight factor will help you to proportional disaggregate values across time dimensions. Also, you need to assign the period weight factor to the planning levels and key figures to complete the configuration.

An example would be:

The calendar week 30/5/2022 - 5/6/2022

1) WEEKWEIGHT (Weight of days in the week)

TW1a = 2 (30/5-31/5) and TW1b = 5 (1/6-5/6) based on the overlap days between 2 months.

CW1 = 7

So lets say you have the value at the calendar week level of 140

For technical week the value will be proportionally disaggregated according to the weekweight in your time profile TW1a = 40 (2/7*140) and TW1b = 100 (5/7*140).

For more details, you can find them in the Model Configuration Guide document in SAP IBP Best Practices.

Hope this helps,

Sittinut R.

[sureshkumar_vaniyasekar]

Hi chainstn,

Thank you for your explanation. I could understand the concept when we do the disaggregation from CW to TW using period weight factor.

If I want to do the disaggregation from Year to Month using MONTHWEIGHT, how to maintain the MONTHWEIGHT in the time periods?

If I want to do the disaggregation from Year to Tech.Week using MONTHWEIGHT, how to maintain the MONTHWEIGHT in the time periods?

Thank you!

Regards,

SureshKumar V