Key Figure Disaggregation Week to Weekday

[former_member844635]

Hi SAP Experts,

I have a KF which at Day level and the user enters the value at Weekly level which then gets disaggregated equally at daily level. Is there any way that if the value is entered at week bucket then I populate the KF value to a certain day of the week like Monday or Tuesday and not equally disaggregating it.

Thanks,

Manas

[former_member811144]

Manas, If you don't want to increase by any means the planning objects (due previous replies), I guess the only way of doing it is through a CI-DS transformation, load the data to a file, transforms it, then load it to IBP.

[AyanBishnu]

Hi manas24

Create a new time based attribute called "DAYWEIGHT" which will be very similar to WEEKWEIGHT. Assign the DAYWEIGHT attribute to the time profile and also to the correct period id int he TP. Refer to how WEEKWEIGHT is assgined in TP and do the same for DAYWEIGHT but at PERIODID0 and activate the TP.

Then down the TP from data integration with option as " with existing time period". OPen the CSV in excel and maintain a value of 1 in the DAYWEIGHT coloumn for all the days where you want the value to dissagg. Keep all the rest as blank.

Then upload the time profile. Now in the KF under the weightage option select DAYWEIGHT and save the KF.

[former_member844635]

hi Ayan,

We are not using this approach since it will increase the Planning objects in our system and impact performance.

Thanks for your comment

[Praveen_Jadhav]

Hi manas24,

Use the feature of Disaggregation & Proportionality Other Key figure - stored values for your requirement. Refer the help document for more details.

Disaggregation and Proportionality | SAP Help Portal

In your case, create a stored KF at daily level - In this KF1 you can update 1(or any proportion can be used) on the days on which you want to disagg. from Week to day level.

In the field Proportionality (for your original KF) choose: Other Key figure - stored values (maintain the KF1).

Regards,

PJ

[former_member844635]

Hi Praveen,

We can't have another KF with value as 1 because it will increase the planning object load in the system and cause performance issue.

Thanks for your comment