Skip to Content

Purge Key Figure Data job : Deleting planning object for entire horizon

In Purge Key Figure Data Job I want to delete the planning object for the entire horizon. Can you suggest what should be setting made in filter below Pic1. In filter I am giving locationId and product ID.

Following options I have tried.

1> It does not deletes the entire planning objects.

Regards,

Akhilesh

pic1.png (11.1 kB)
pic1.png (6.0 kB)
pic2.png (4.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    May 16 at 09:35 AM

    Hi Akhi,

    You may try the operator (Job template in Application Jobs App) -

    Purge Key Figure Data Outside Planning Area Planning Horizon?

    Check box - delete planning combinations according to your requirement...

    I assume this 730 days in the past is not in your planning area horizon, that is why you see those data not as deleted.

    In case, the above assumption is wrong - i.e. 730 days in the past is within planning horizon, then enter 730 and not -730 using Purge Key Figure Data job template

    Also check that you have selected the version correctly and also the filter value.

    Add comment
    10|10000 characters needed characters exceeded

  • May 09 at 12:26 PM

    Hello Akhilesh,

    You can select positive value of the end of horizon in the period offset with older than check box.

    This will delete data for entire planning horizon for the selected planning level.

    See more details in SAP help link.

    Thanks,

    Rohit

    Add comment
    10|10000 characters needed characters exceeded

    • My observation after detailed testing is "Delete Planning Objects" option in the job can delete planning object irrespective of the Key Figure values existence. Every thing works perfectly when I run the job thrice in the following sequence ie all the planning object across horizon for selected location product gets deleted.

      1> "later Than" with offset "0".

      2>"Older Than" with offset "0".

      After above two runs all the planning objects except at "0" or current period are deleted therefore to delete planning object from current period third run is required.

      3> "later Than" with offset "-5". say any negative offset .

      Now the question is instead of running the job thrice what setting or values I should give in "offset" OR "option" so that in a single run planning objects across horizon are deleted.

      Thanks,

      Akhilesh

  • May 11 at 12:34 PM

    Hello Akhilesh,

    Did you try to run twice like below:

    1. Run Purge Key Figure Data operator using the proper filters, without "Delete Planning Objects" enabled;
    2. Then run Purge Key Figure Data operator again using the same filters, with "Delete Planning Objects" enabled.

    The option "Delete Planning Objects" only deletes planning objects that don’t have any associated Key Figure data are deleted.

    Best regards,
    Matheus

    Add comment
    10|10000 characters needed characters exceeded

    • HI Matheus,

      My observation after detailed testing is "Delete Planning Objects" option in the job can delete planning object irrespective of the Key Figure values existence. Every thing works perfectly when I run the job thrice in the following sequence ie all the planning object across horizon for selected location product gets deleted.

      1> "later Than" with offset "0".

      2>"Older Than" with offset "0".

      After above two runs all the planning objects except at "0" or current period are deleted therefore to delete planning object from current period third run is required.

      3> "later Than" with offset "-5". say any negative offset .


      Now the question is instead of running the job thrice what setting or values I should give in "offset" OR "option" so that in a single run planning objects across horizon are deleted.

      Thanks,

      Akhilesh

  • May 13 at 09:27 PM

    Hi Akhilesh,

    You mentioned that you have tried to run the job with "0" value in Period Offset field, but in that way, the current period planning objects are not deleted. What about if you don't enter any value at all on this field? Does the behavior changes?

    Best,

    Ivan

    Add comment
    10|10000 characters needed characters exceeded