Skip to Content
Author's profile photo Rajeev Mishra

Integrated Planning-ADSO for Planning-New Planning Functions

One change which i forgot to cover in my first blog on advanced DSO for planning was the introduction of  three new planning functions  by SAP .

  • Delete DSO Records
  • Physically delete invalid data in the DSO
  • Repost data and physically delte source data.

These planning functions can only be used with the ADSO for planning.All three planning functions physically delete the records from the ADSO.This was not possible with the transactional infocubes.

If we had to delete records in a transactional cube then we had to first make the values 0 and then run a process chain to compress the infocube with zero elimination.This chain would either run with scheduled loads or be triggered from the application.This would unnecessarily complicate the design.

But now thanks to ADSO for planning and these new planning functions we dont need to depend on a process chain to do this for us.So the users can now do this by pressing a button and not having to wait for a process chain to complete so that they can resume working.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Monika Patel
      Monika Patel

      Request link to first blog. Thanks

      Author's profile photo Rajeev Mishra
      Rajeev Mishra
      Blog Post Author



      Author's profile photo Harish Allachervu
      Harish Allachervu

      Informative blog post, keep sharing your knowledge with community 🙂



      Author's profile photo Rajeev Mishra
      Rajeev Mishra
      Blog Post Author

      Thanks Harish.

      Author's profile photo Rajarshi Muhuri
      Rajarshi Muhuri

      Great to see these new features . You mentioned in your earlier blogs about triggering a process chain from Planning seqence . Any pointers on how to do that .

      Author's profile photo Rajeev Mishra
      Rajeev Mishra
      Blog Post Author

      Hi Rajarshi,


      There are quite a few posts explaining how to do that.Check this one out



      Rajeev Mishra

      Author's profile photo Ruben Blok
      Ruben Blok

      Hi Rajeev,

      Thank you for your blogs on IP in HANA Studio.

      For those that are having trouble getting the planning options on the BW Modeller, make sure you are using neon (not luna or mars) as the add-on.

      Can you please assist me with a scenario? I am trying to save data through an aggregation layer and need to auto populate some fields based on other fields entered.

      How would you recommend I do this? A planning sequence on save?

      Please email me on

      Thank you!


      Author's profile photo Rajeev Mishra
      Rajeev Mishra
      Blog Post Author

      Hi Ruben,

      Just saw your message and have sent u an email with a possible solution.



      Rajeev Mishra

      Author's profile photo Raf Boudewijns
      Raf Boudewijns


      Just a small addition: you may need to install these extra "function types for planning" from the business content first (in this case: 0RSPL_DELETE_CR_DSO, 0RSPL_DELETE_DSO, 0RSPL_REPOST_CR_DSO) as they're not available by default (at least not on BW7.5 SP05).

      Author's profile photo Vidhyarthi Kantumuchhu
      Vidhyarthi Kantumuchhu


      I have tried the option of creating an aggregation level on top of

      1. Multi Provider
      2. ADSO

      And tried to create a planning function of type Delete DSO data physically, on both occasions i am getting the following error. "The aggregation level doesn't contain a DSO object"

      Am I missing something?



      Author's profile photo Suraj Grewal
      Suraj Grewal

      Hi Rajeev,


      Thanks for the wonderful blog .

      I am trying to delete the 0 records (key figures with 0 values from ADSO) . Seems there are some limitations here :

      1.If ADSO is created Infocube-Like Planning Enabled the planning functions will not be helpful as in the classes there is a check for the ADSO type. So it will give the error "The aggregation level doesn’t contain a DSO object

      2.For 0 key figure values it just tries to post extra 0 values instead of deleting the existing 0 values records. 🙁

      Thanks !