What is a best practice to optimize the performance of SAP Analytics Cloud?

Minimizing the use of complex calculations in stories is indeed a best practice to optimize the performance of SAP Analytics Cloud. Complex calculations can significantly impact the performance of your analytics solution by increasing the processing time needed to render visualizations and queries. When you utilize simpler calculations or pre-aggregated data models instead, you reduce the computational load during runtime, leading to faster response times and an overall improved user experience.

This approach allows for not only quicker data retrieval but also a smoother interaction with the application, enabling users to derive insights without waiting for lengthy processing or rendering of data visualizations. Moreover, it helps in maintaining a cleaner, more manageable data model, which can be crucial for collaborative environments where multiple users access and interact with the same analytics content.

In contrast, frequently refreshing live data connections, increasing data model size, and utilizing maximum row limits in all queries can lead to excess strain on the system and can result in slower performance or other inefficiencies. Adhering to best practices, such as minimizing complex calculations, is essential for achieving optimal performance in SAP Analytics Cloud.