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

[mohnotrahul · Accepted solution]

Hi Suresh,

There is no month which is split between 2 years but weeks are split in 2 months, hence there is no need for Month split in principle.

In case you want to do the custom split for months with 31 days or 30 days or 29 days from year, you will have to use the attribute in time profile called "MONTHWEIGHT", assign the number of days or the split factor based on your business requirements. Assign this attribute to Month in time profile which is done by default config.

You can use "MONTHWEIGHT" in Key figure with Month level as root.

-Rahul

[sureshkumar_vaniyasekar · Accepted solution]

Hi Rahul,

Thank you for the explanation. After lot of experiments now I could understand what is the use of Period weight factors such as DAYWEIGHT, WEEKWEIGHT & MONTHWEIGHT and how to use them in the time periods.

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

[former_member804657]

Hi Sureshkumar,

In general to disaggregate from year to months or year to technical weeks, you don't need to maintain the MONTHWEIGHT as such. However, MONTHWEIGHT is used to maintain the days in the month, for example in February some year we have 28 and some year we have 29 days. System will automatically disaggregate from year proportionally to 12 months. And for technical week it will first disaggregate from year to 12 months, then in the following month split further into technical weeks based on the WEEKWEIGHT TW1 TW2 TW3 TW4 TW5a.

Hope this helps,

Sittinut

[victor_hugodebastosleo]

Hi Sittinut!

Do you know if it is possible to disaggregate from MONTH to DAY but not proportionally?

My intention is to disaggregate from MONTH to DAY but considering some seasonality. So, for example:

January = 1000 pc (100%)

Jan 1st = 2% ... Jan 15th = 2% ... Jan 28th 10% ... Jan 31th 15%

Is there anyway to have it?

Thanks in advance.

Victor Leao