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.

 

Be the first to leave a comment
You must be Logged on to comment or reply to a post.