Technology Blog Posts by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

End-To-End performance optimization in SAP Analytics Cloud with SAP Enterprise Support Services

MichaelMoloney
Product and Topic Expert
Product and Topic Expert
‎2024 May 24 10:48 AM
3,491

SAC CQC banner.jpg

Recently I posted a blog about SAP Analytics Cloud: Continuous Quality Checks (CQC services).

The overall performance of SAP Analytics Cloud (SAC) is mainly determined by the three components:

  • Client time - frontend
  • Network time
  • SAP Analytics Cloud service time - backend 

 It is important to regularly monitor and analyze the performance of SAP Analytics Cloud to identify and address any bottlenecks or inefficiencies.
The CQC services in my blog above offer great value in assisting you to analyze your system and/or situation based on real life data from your SAP Analytics Cloud Stories or Analytic Applications etc.
They do primarily focus on the frontend and network aspects. 

In many cases the frontend can be the smaller portion of the total build time of a Story in SAP Analytics Cloud. When connecting to live SAP data sources you must ensure that these have been optimized for reporting usage. This can be achieved by optimizing database queries, tuning configurations and parameters, and scaling resources to handle increasing user loads. Additionally, implementing caching mechanisms, utilizing efficient data storage and retrieval techniques etc.

Getting to the Root Cause

To begin with you should perform some root cause analysis to narrow down where time is being spent.
Take a look at these useful resources and tooling within SAC  

Once you establish the total build time and how much time is spent in the three components, you can follow the guidance in the links above to work on improving and optimizing each part.  

SAP Enterprise Support Services - Backend 

If you encounter a situation where you have performance impact coming from an SAP source system, such as SAP BW or SAP HANA, one option available to you is to engage with us and consume your entitlements from SAP Enterprise Support. We deliver specific recommendations via our CQC checks to help you fine tune these data sources.
Especially relevant for SAP BW and SAP HANA DB are: 

Technical Performance Optimization (TPO)

The TPO service is designed to be an overall health check focusing on throughput of your database.
Some of the checks included in the service include:

  • Checks for major misconfigurations and hardware bottlenecks
  • Parameter settings, table space, expensive SQL statements
  • Database management (CBO statistics, Index and table storage management, Online log configuration)

For more details read the infosheet.

Business Process Performance Optimization (BPPO)

The CQC for SAP Business Process Performance Optimization is designed to ensure best performance for business-critical steps in your solution. It is more relevant for specific issues like modeling. 
Some of the checks included in the service include:

  • Detailed technical analysis of critical process steps, evaluates and identifies potential improvement areas.
  • Investigation of long running process chains / failed process chains.
  • Investigation of long running BW queries
  • Parameter checks of the system for both hardware/software and suggestions for performance improvement

For more details read the infosheet


Further Support and Empowerment via SAP Enterprise Support Value Maps

Value Maps are a support and empowerment program from SAP Enterprise Support and are available to you via the SAP Learning Hub. A one-time sign in with your S User is required, and everything thereafter is free as part of your entitlements. We provide:

  • Prescriptive Guidance
  • Empowerment
  • Social Collaboration
  • Expert Access

For Data and Analytics we provide all of the services and support outlined above, and much more, as part of our Learning Journeys. This includes SAP Analytics Cloud, SAP Datasphere, and SAP BW topics.  
We have dedicated Learning Journeys for SAP Analytics Cloud, SAP Datasphere, and SAP BW topics.

Check out the SAP Enterprise Support value maps landing page for more and start engaging today!

 

MichaelMoloney_0-1716472602963.png

Quicklinks

Labels in this area
Popular Blog Posts