Is there is way to find out all fixed cells in DP-Interactive Planning

[Former Member]

Hi Experts,

Is there way out to find all the fixed cells in Interactive demand plannning.

Thanks in advance.

Sunil

[srinivas_krishnamoorthy · Accepted solution]

Absolutely, but through little bit navigation. You can have a maintenance data view that points to the Fixed Key figure portion of a fixable key figure as a visible key figure. Any non-zero value of Fixed Key figure represents that the primary key figure is fixed.

[Former Member]

do you have fixed 'cells'... or is it fixed Key Figues?

or is it locked cells?

[Former Member]

please try using this macro

IS_FIXED( Key Figure )

Key Figure: Row, column, or cell element (data source = row attributes)

Description

The IS_FIXED function returns the value 1 if the cell is completely fixed. (The column results from the current step iteration; the row is determined by the Key Figure parameter.) If the cell is not fixed or partially fixed, the return value is 0. The function is not available if the compatibility mode is activated for the macro book.

you can use the output in another temporary KF that is visible or to get a background color loop it into another macro step with CELL_BG()

there is another macto function IS_PARTLY_FIXED( )

[Former Member]

Hi All,

Thaks for your help and suggestion

I am using SCM 4.0.

Is IS_FIXED( Key Figure ) macro avialable in this version if so suggest me how to get to SAP deliverd macros.

Thanks,

Sunil

[Former Member]

am sure it is available

you need to get to the planning book 9AEXAM (or EXAMPLES) to have a look at the sap example macros

you can find the funtion when you create your own macro

[Former Member]

Hi Sunil,

YES. It is possible as srinivas said, in your planning screen (SDP94 or SNP94), you can see the fixable key figures as editable out and non fixable as grayed out.

Also you can go to each key figure maintenance in RSD1 and see if there is a fixing key figure assigned.

Hope this helps.