Skip to Content
avatar image
Former Member

How to delete Key Figure values In the Past

Hello,

I am working on a scenario based on SAP2 template which has an offset of -4 months as a predefined value.

I would like to reinitialize the scenario getting 0's for all the key figures related to inventory.

My idea is as follows:

  1. 1. Generate 0's for all the past horizon for Total Saleable Qty Key Figure
  2. 2. Execute a Profit Optimization Model getting a 0's for Constrained Demand Plan Qty Key Figures
  3. 3. Validate that all the Inventory related key figures are 0 like the Projected inventory in the DC's due to 0s on Demand.

In order to be able to edit Total Saleable Qty key Figure I have thought in the next options:

a. Change the offset to -28, all the past horizon, for the planning area and make the key figures editable. Change values to 0.

  1. b. Change the configuration of Total Saleable Qty key figure form "Editable in the Current or Future" to "All Editable". Make the changes and undo the configuration modification.

I would be really pleased if you could help me with this point.

Is this the best option to reinitialize the Past values?

Which is the best practice for this aim?

Thank you very much.

Josep Tomas Olive

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 28, 2015 at 10:05 AM

    Hi Josep,

    The easiest way to delete transactional data for the past (when KF is not editable) is to go to

    Versions -> Manage -> Delete -> Select the version (e.g Baseline) -> Provide time horrizon -> Select your KF from the KFs tab -> Run

    But one question, why don`t you make inventory target equal to zero?

    Regards

    Alecsandra

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Josep,

      Yes, this is due to transport supply from location Canada which already started in past and is reaching DC in your current bucket i.e June'15 as per offset. This can be seen in transport receipt key figure at your DC.

      You can try to the parameter INITIALIZE_LEADTIME_HORIZON to delete these key figures. Please see section 10.8.1 in help document for more detail-

      http://help.sap.com/download/ibp/ibp40_model_ref_en.pdf

      Thanks,

      Rohit