Finding of Fixed Cells in Planning Book

[Former Member]

Hello All,

Fixing of cell refers to inital forecast values of product being not changeable in planning book even though quantity changes takes place at the product group level and forecast is re-run, but still the old forecast values of product happened through disagreegation remains unchanged in the planning book.

Is there any way we can find out what all cells were fixed ? are there any standard reports which tells us the details of all the cells which were fixed ?

if any one has any idea, please share with us since it is very urgent.

Many Thanks !!

regards

Pawan.

[srinivas_krishnamoorthy · Accepted solution]

Dont think there is a standard report to find all fixed cells. However you can do couple of things like creating a maintenance view that looks at the Fixed key figure or if you are on 5.0, try to use IS_FIXED() macro to flag a cell as fixed. If in 4.1, you can use the attribute of the primary key figure by the name Fixed Value to again flag what is fixed. Yes, the latter solutions that I mention would mean that one has to browse around. The maintenance view solution would probably help you a quicker way of finding the fixed values.