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.
Request link to first blog. Thanks
https://blogs.sap.com/2016/11/28/integrated-planning-advanced-dso-for-planning/
Informative blog post, keep sharing your knowledge with community 🙂
Regards,
Harish
Thanks Harish.
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 .
Hi Rajarshi,
There are quite a few posts explaining how to do that.Check this one out
https://blogs.sap.com/2014/04/01/how-to-trigger-bw-process-chains-from-analysis-for-office/
Regards,
Rajeev Mishra
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 ruben.blok@delaware.pro.
Thank you!
Ruben
Hi Ruben,
Just saw your message and have sent u an email with a possible solution.
Regards,
Rajeev Mishra
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).
Hi,
I have tried the option of creating an aggregation level on top of
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?
Thanks
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 !