Technical Articles
SAP Analytics Cloud Planning : do you encounter performances issues? What can you do before contacting SAP?
Dear customers and partners,
When encountering performances issues,
what can you do before contacting the support of SAP or your Customer Success Partner?
Start by checking your local PC resources, your network speed, number of Chrome extensions and set power mode on battery on “best performance” for more detailed information see System Requirements and Technical Prerequisites – SAP Help Portal
During the User Acceptance Tests process, use the role configured with most accesses and not the Administrator role that isn’t relevant to your planning data collection process
Once you’re in the optimal conditions for your tests, assess what is slow, describe items perceived as slow, current time and expected time
This comprehensive KBA will help you 2511489 – Troubleshooting performance issues in SAP Analytics Cloud (Collective KBA)
For more “developer” profiles, open Google Chrome Developer Tools and analyze what is slow:
✓ Query data at backed
✓ Calculation on the fly
✓ Render and display data
Once you have localized the areas where you need performances improvements,
please find below some examples of features of SAP Analytics Cloud Planning that you could leverage in a short term period.
Implement security in the model and its dimensions (thus reducing the Private version “playground” of the end user)
- Activate Planned area option Planned area option definition in SAP Help
- Configure the Data Access Control in dimensions having the largest amount of dimension members
- Activate the Model data Privacy and set up the Data Access filters in Roles see the
Configuration guide for Data Access filters in roles
For more detail about the configuration, please watch this video Implement security in the model and its dimensions
- Optionally, decrease the number of driving dimensions in the Data Locks option of the model
Readapt “performances costly” data actions
- Check security in user’s role (note that the data action triggers only the entities the user is entitled to)
- Check the scope of the calculations and reduced it if needed
- Use member set selection
- Try to avoid too many If statements in the Advanced formulas (please find illustrated examples there Optimize Advanced Formulas for Better Performance | SAP Help Portal)
- Use parameters of the data action to narrow the scope of the execution especially during a cross model copy process
- Use function “Aggregate_write to” when cross copying from one model to another
- Check the amount of data to be published in the details of the version in the story
- Stop initializing stories with 0 to delete them afterwards, please try out the options of this blog The evolution of data initialization in SAC Planning | SAP Blogs
Review your data collection stories
Navigation
- Define a Summary page and Use hyperlinks to go to detailed information (more levels if needed)
- Keep the fluid data entry mode, activated by default.
Presentation
- Filter as much as you can, implement filters in documents rather than creating generic documents without selection possibilities in dimensions as drill-down to all details can be expensive
- Take care at drill state – filter as many dimensions as possible
- Limit the number of charts per page – max 6-8 parallel queries can be run by browser (depending by version)
- Split big tables in multiple tables with fewer accounts
- Propose to the end users to try “Add member” instead of configuring tables with “Unbooked data”
- Less is more – request only what you need
- Limit the numbers of descriptive columns into the table – easy to be read
- Avoid formatting rules for tables with large datasets
- Reduce as much as possible the cell references
Calculations
- Use Restricted measures instead of Conditional Aggregations in the model
Review your reporting stories
- Filter first (avoid loading all and filter after)
- Split the information in more level of details:
- Define a Summary page with global indicators – use conditional formatting to highlight a wrong result
- Use hyperlinks to go to detailed information (more levels if needed)
- Limit the number of charts per page – max 6-8 parallel queries can be run by browser (depending by version)
- Limit as much as possible the linked data sources
- Use page filters instead of individual filters per chart
- Use cascading effect in case of multiple filters or input controls
- Enable “unbooked members” only if needed
- Rebuild the story in using “lazy loading” approach (tables one after another)
- If your performances issues are related to the front end of SAP Analytics Cloud, try out the Optimized Design Experience more details in this blog and please be aware of the current limitations Optimized View Mode
On a mid-term basis, you may also reconsider the configuration of the Planning model with the following recommendations
MODEL
Size of the model and its dimensions combinations
Often customers and partners mix up the concept of dimensions and properties
Check if
✓ all dimensions are required to define the collected information, here an illustrated exemple with the gender in this blog about HR Planning SAP Analytics Cloud Planning and SuccessFactor – Building a robust Planning Model – Some best practices examples and tips | SAP Blogs
✓ some dimensions can be transformed into properties of other dimensions
✓ try to extrapolate the number of records of your model based on the existing Actual data in the current sources and check the existing limitations of SAP Analytics Cloud System Sizing, Tuning, and Limits
Model calculations
✓ Try to find the right balance between on the fly calculated measures in the model and calculation done by data actions
✓ Use hierarchies instead of calculations
✓ In the classic model avoid accounts formulas, lookup formulas, exception on aggregation, try to initialize data with Data management import
✓ Replace Conditional aggregations with Restricted measures in stories
Useful link to troubleshoot performances issues Optimize System Performance with the Analysis Tool | SAP Help Portal
Super useful tips for our customers, great stuff Charlotte!!!
Is there a recommendation for the limit of the Cartesian Product?
Thanks a lot in advance!
Best regards,
Emre
Hello Emre there isn't official "T Shirt sizing" approach as SAP Analytics Cloud Planning allows unlimited models creation purposes.
For data collection purposes, 6 to 8 dimensions should be sufficient and if you plan to have more dimensions you must use the Planning area option and beware of administrators tasks that would leverage too many combinations and/or calculations.
If you have a lot of calculations involved in your configuration, please consider our 2 offers (Public and Private Cloud with up to 2Tera GB).
Is there a difference in performance between the old Classic Account Model and New Model?
Thanks a lot in advance!
Best regards,
Emre
I would say that the new model allows other types of data storage that should help see here
https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2022.22/en-US/22af95d0151c4946b132d4e904b1e32a.html?css=https://cx-ws-cf.eu10.sapanalytics.cloud/sap/fpa/services/rest/epm/feature/css?tenant=2
Besides converted data being now stored, the retrieval should be alleviated.
And another question:
Is the new model a requirement for later migration to DWC?
Thanks a lot in advance!
Best regards,
Emre
Let's wait for the coming roadmap 🙂