Skip to Content
Technical Articles

SAP Analytics Cloud Backend Runtime Analysis and Statistics

Imagine your Colleague is asking: “How does the recently established SAP Analytics Cloud Live Connection affect my Backend System?” “Do you have any Statistics on Queries that are running against my Backend System?”. “Could you check the most expensive SAP Analytics Cloud Models for improvement potential?”.

Questions like these can now be answered faster with a new SAP Analytics Cloud Model and Sample Story.

2020.Q3 QRC and Wave 2020.14 introduce SAP Analytics Cloud Content in the System Files Directory without the need to deploy it from the Analytics Content Network. All out of the Box. This System Folder contains the Analytic Model SAC_STATISTICS_MDS_QUERY_PERF and the Story Backend Application Performance.

The purpose of the Story is to help you answer typical Performance related Questions as well as to give you an Idea what Information can be accessed via the Model if you want to customize the Sample Story.

Besides the Timeframe you are interested in, you will be able to filter for a specific Connection, Model, Story, or your most active Users.

We help you to identify active Users, most used Connections, and Models with high total Processing Time in the Backend.

A Model can be used in different Stories. Sometimes the Model itself is performing well, whereas the combination of Model and Story can cause an Performance Issue. We show the combinations with the most Impact in the Backend System.

And Charts to analyze the Query Response Times and the Execution Counts over time as well as the Runtime Distribution for selected Queries.

Some customers have already been testing this Model and Story, as a Proof of Concept. Now we are happy to release it to the full customer community! Stay tuned for further enhancements and updates.

 

11 Comments
You must be Logged on to comment or reply to a post.
  • Hi Thomas,

    Great article!  Fyi I notice that the story name has changed slightly and is now Performance Statistics  and Analysis.

     

    Thanks

    Lucy

    • Hi Nivetha Jeyananthan ,

      The connection SAC means local connections from the SAC client to your SAC backend.

      This performance analysis is for the Analytical Backend Query Processing only. Therefore only live connections are tracked. File Server does not have Analytical Processing Queries and therefore it also doesn’t have a live connection. That is why there is no tracking for it available.

      I hope this answers your questions!

      Thanks and Best Regards,

      Jan

      • Hi, Thanks for responding.

        we were in an assumption that if we select the connection name from the checkbox, it would show the models & stories associated with it and the user id’s which are accessing the connection.

        Does this story provide the above information?

        Thanks,

        Nivetha

          • But it gives the data for live connections only. Can we get the same for each import data connections?

            Also I don’t see the import data connections in the ‘connection name’ column. I can only see the connection name ‘SAC’ which is showing all the models & stories created using import data connections.

            Thanks,

            Nivetha

             

             

          • Hi Nivetha,

            as for now, we are working on tracking more SAP HANA components in the future before looking into these other type of connections. For now, analytical backend queries are tracked.

            Thanks and Best Regards,

            Jan