Dear experts, I have created a custom VBA code which checks if a certain Planning View filter is present in a certain Worksheet of a Planning View.It checks this using SOPFilterValueIsValid before refreshing the Planning View, using Function BEFORE_R...
Let's say in IBP, we have a stored editable Key Figure on base planning level Month + Product + Location.Can you restrict the editability of a key figure to only allow edits on the lowest (base) planning level.That is: to restrict editability on high...
In IBP, what is the fastest way to delete all Planning Objects on a Planning Level (condition: all Planning Objects without any KF data).Imagine a few 100s of 1000s Planning Objects.
If you do not wish to manually recreate the source sheet. I figured out the following way:Open both Planning Views (source Planning View from which you wish to copy 1 sheet; and target Planning View to which you wish to copy that 1 sheet).Select the ...
@riyazahmed_ca2Please find the following code at the bottom of this post.Would you know how to adapt it such that it specifically checks whether or not there have been any specific changes (edits) to that particular editable Key Figure.It currently o...
@Rigor Interesting. Have you ever used this before? With what process did you create the Planning Objects, and also: will this work for 1 particular Key Figure only? We do not want to restrict the entry on higher level for other Key Figures that use ...