Skip to Content
Product Information
Author's profile photo Chandni Sinha

Multi Actions Chain – Clean – Import – Predict – Publish – Data Locking

Introduction

SAP Analytics Cloud (SAC) Multi Actions has gained a lot of attention recently because of its ability to orchestrate multiple Data, Predictive and Planning operations. Plus, it helps end user to save time when there are multiple planning model and versions are involved. In this blog, lets see how to run multiple planning operations using Multi Actions.

Multi Action History

SAC introduced Multi Actions in the release of 2021.Q3, then integrated Predictive Scenario into Multi Actions in the release of 2022.Q1. In the release of 2022.Q3, Post that SAC released Integrating Data Import Job into Multi Actions Now, in 2023.Q2, SAC has introduced Data Locking into Multi Actions.

Scenario

In this blog, you will learn to trigger Clean(Data Actions), Import(Data Loading), Predict(Predictive Scenario), Publish(Version Management) and Data locking at single click using Multi Actions

Preparation before Multi Actions

Firstly, you need to create a Data Action which will delete model data or perform any desired action on the model.
Secondly, create data import job in Data Management of a model. I assume you are familiar with the creation of data import job. If no, refer to Import Data to you Model.
Third, for Data Locking step, make sure Data Locking toggle is on for Model under Model Preferences > Access and Privacy
Lastly, you need to create a predictive scenario. If you are not familiar with predictive scenario, refer to Predictive Scenario

Creating Multi Actions Chain

1#Create Multi Actions either from the Side Menu bar

Multi%20Action%20Option%201

Multi Actions Option 1

 Or create it from File Repository

Multi%20Action%20Option%202

  Multi Actions Option 2

 

2#Clean Model data using Data Action step

Add a Data Action step which will delete all Forecast version data from the selected model

Add%20Data%20Action%20Step

Add Data Action Step

Data%20Action%20Step

Data Action Step

 

Data%20Action

Data Action – Delete

 

3#Import Data to Model using Data Import Step

Add Data Import steps to import Master and Model Data.

Data%20Import%20Step

Data Import Step

Master%20Data%20Import

Master Data Import

 

Model%20Data%20Import

Model Data Import

 

4#Add Predictive and Version Management Step

For Predictive step, please refer to blog. Here, I will predict Net Income for 2022 and 2023 till Q2

For Version Publish step, please refer to blog

Predictive%20Step

Predictive Step

Version%20Publish%20Step

Version Management Step

 

5#Data Locking

Add Data Locking step to lock data for previous years i.e. 2020, 2021 and 2022

Data%20Locking%20Step

Data Locking Step

You can also add API Step to integrate Remote Application. Please refer blog to add API step

Your Multi Actions chain is ready now!!

To test this Multi Actions , create a story and add a table with required columns and rows. Add Multi Action trigger. According to the steps , first it will clear data for Forecast Version, then import master and model data from already setup data import jobs, followed by prediction scenario to predict few months ahead and version management to publish changes and at the end locking previous years with Data locking step.

Before Multi Actions Execution:

Before%20Executing%20Multi%20Action

Before Executing Multi Action

After Multi Actions Execution:

After%20Executing%20Multi%20Action

After Executing Multi Action

 

Conclusion

Multi actions help you orchestrate a set of data, planning and predictive operations across multiple planning models and versions in SAP Analytics Cloud. They link together a sequence of steps such as data actions, data import, version management steps, predictive steps data locking and even API integration, which all run from a single planning trigger.

References

See the list of existing Multi Action blogs

https://blogs.sap.com/tag/multi-actions/

https://blogs.sap.com/tag/multi-action/

 

Thanks for the read! Hope you find this blog helpful. Please share your thoughts and questions via comments. I request you to follow for future interesting blogs on SAP Analytics Cloud

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo poorna mahe
      poorna mahe

      Thank you for sharing this informative post about multi-actions, data locking, and other features in SAP Analytics Cloud. I found the explanations and examples very helpful in understanding how to use these features effectively.

      As someone who frequently works with data in SAP Analytics Cloud, I appreciate the tips and best practices you've provided for using multi-actions to chain together multiple steps and automate data processing. The section on data locking was also particularly useful, as it clarified some of the common scenarios in which data locking can be useful.

      Overall, this post has given me a better understanding of how to use some of the more advanced features in SAP Analytics Cloud. Thank you for taking the time to create such a valuable resource and sharing it with us.

      Best regards,

      poorna

      Author's profile photo Chandni Sinha
      Chandni Sinha
      Blog Post Author

      Thank you Poorna!

      I am happy to see this blog was considered helpful.

      Regards,
      Chandni