SAP Knowledge Base Article - Public

2591655 - Performance analysis when using SAP HANA Live Data Connections in SAP Analytics Cloud *** Collective KBA ***

Symptom

  • You experience performance problems opening or refreshing stories that use a "Live" connection (or model) to SAP HANA using a Direct Connection (CORS).
  • Changes in your story take a long time and sometimes your browser asks you if you want to "wait" for the page to load.

Environment

  • SAP Analytics Cloud (Enterprise)
  • SAP HANA Live Data Connection via Direct (CORS) connectivity type

Resolution

1. General

The first step is to narrow down if you experience a general performance problem or only with a particular SAP HANA system or Calculation View.

  • Explore data: Use the option of exploring your data so other input controls or linked models may affect the performance of your story.
  1. Go to the menu Create > Story.
  2. Select Access & Explore Data.
  3. Select the model icon (cube) - Data Acquired from an existing model.
  4. Select your model from the dropdown menu that is connecting to the SAP HANA using Live Direct Connection.

You can compare the time taken to display measures and dimensions in exploration mode vs. your story. If it's a significant difference, you may start simplifying your story.

2. Specific Calculation View

Usually, performance problems are related to complex Calculation Views created in SAP HANA that require complex authorizations or calculations that slow-down retrieving measures.

Using a simple calculation:

  1. Create a very simple Calculation View in SAP HANA studio.
  2. You only need data from a table using some measures and dimensions. Use a simple aggregation method.
  3. Create a "test" model using this calculation view and explore the data to compare the performance.

3. Capture the time spent in each chart

To identify problematic charts or tables that your browser sends to SAP HANA, there are the following tools to help you troubleshoot:

3.1. Capturing browser requests

You can use the browser (Chrome or Edge) Developer Tools or Fiddler to capture network traffic between your browser and SAP HANA. You can search for the queries used to retrieve data from SAP HANA as follows:

  • https://<HANA_SERVER>:PORT/sap/bc/ina/service/v2/GetResponse
  • You will see two different requests, one per chart/table widget: OPTIONS and POST.
  • Examine the time taken by the POST requests, as follows:

Capture_HANA_requests_browser.png

In the tab Timing, you can find how long that request took to complete and how long it took to send and receive the information.

  • Each request has its own Session and Step ID which can be traced back in the SAP HANA MDS server component to find out which request takes the most time.

3.2 Capturing performance information in SAP HANA

Let's have a simplified picture of all the items affecting the performance between your browser and SAP HANA.

Simplified_services_HANA.png

In this very simplified picture there are 3 areas that can affect performance of a chart or table widget:

  1. The network: your browser will be requesting HTTPS connections to SAP HANA directly and will make intense use of the network, its cache and memory.
  2. InA Service (Multidimensional Services or MDS): These are the services that transform the results back to a language that a SAC (browser app) can understand: json.
    • More information about MDS 2670064- FAQ: SAP HANA Multi-Dimensional Services (MDS)
  3. Index Server: This is shared among other SAP HANA clients, it's the time that the database requires to run the calculations, aggregations, and everything else to return your data.

The following SAP Notes can help analyze issues when experiencing performance problem between SAP Analytics Cloud and SAP HANA:

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

HANA, cors, live, direct, remote, slow, wait, crash, freeze, SAC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, slow, performance, speed, C4A, BOC, SAC, AnalyticsCloud, Analytics Cloud, SAP BusinessObjects Cloud, network connection, bandwidth, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, slower, Performance problem, stopped, slow, slowness, hangs, hanging, Cross calculation, sac bp performance sap kba, query, InA, SAP Cloud for Planning, live, remote, sc4p, c4p, cforp, cloudforplanning,Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, trace, mds, ina, CORS, debug, Live data source is showing different results in SAC compared to the data source, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence, , KBA , performance issue (live connection to sa , (live connection to sap hana using path) , way to improve performance , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , LOD-ANA-ADM , SAC Administration , LOD-ANA-XUS , User assistance, performance statistics , HAN-AS-INA-SVC , deprecated - please use HAN-DB-ENG-MDS instead , How To

Product

SAP Analytics Cloud 1.0