cancel
Showing results for 
Search instead for 
Did you mean: 

"fixing" or "locking" a KF in DP

Former Member
0 Kudos

Hello gurus:

We've just implemented some new functionality where a KF can be "fixed" or "locked" so a disaggregation of proportions (APODPDANT) won't overwrite a forecast they put in.  The situation is that mid-month, they put in forecast data on a material and lock it.   In the beginning of the next month, some new CVCs get auto-created based on sales data.  These CVCs can be on the same material, but a different customer.

What I am finding is that only the CVCs which were in the system when people put the "lock" on stay "locked'.  Any new CVCs that come in are not locked and therefore the disaggregation will put data on these CVCs if a change is made at a higher level (such as product family).  Since the Marketing people expected the entire material is "locked", they are surprised that their forecast is changing.

Does anyone know of a solution for this?  Are we handling this "locking/fixing" functionality correctly?

Thanks for any ideas you have....its much appreciated!

Andrea

Accepted Solutions (1)

Accepted Solutions (1)

rajkj
Active Contributor
0 Kudos

Hi Andrea,

The fixing functionality heavily depends on the CVC (technically the PLOB objects). Probably, one alternative is to use another key figure to apply the proportional factors instead of APODPDANT directly. The following 2 macro functions might be useful in populating the proportional factors (based on the values of APODPDANT and fixing information).

1. IS_FIXED

2. IS_PARTIALLY_FIXED

IS_FIXED()

Syntax

IS_FIXED( Key Figure )

Key Figure: Row element, column element, 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 is partially fixed, the return value is 0. The function is not available if the compatibility mode is activated for the macro book.

IS_PARTLY_FIXED()

Syntax

IS_PARTLY_FIXED( Key Figure )

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

Description

The IS_PARTLY_FIXED function returns the value 1 if the cell is partially 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 is completely fixed, the return value is 0. The function is not available if the compatibility mode is activated for the macro book.

Thanks,

Rajesh

Answers (1)

Answers (1)

Former Member
0 Kudos

One solution is to back up the Fixing information at family level in a cube and re-upload it periodically back at the family level using TSCUBE and it will disaggregate it again to the lowest level.

The other option is run a macro at family level aggregation to find out if the cell is FIXED or PARTIALLY FIXED. If new CVCs have come in due to new values the cell would turn from FIXED to PARTAILLY FIXED and that can be fixed again at family level using FIX_CALC.