Skip to Content
Technical Articles
Author's profile photo Thomas Fery

SAP Analytics Cloud Performance Statistics and Analysis

My previous blog post on “SAP Analytics Cloud Backend Runtime Analysis and Statistics” introduced the Model SAC_STATISTICS_MDS_QUERY_PERF and the Story Backend Application Performance.

2020.Q4 QRC and Wave 2020.17 rename the Story in the SAC Content to Performance Statistics and Analysis. The Model SAC_USER_FRIENDLY_PERF_ACTION has been added to the Story and provides new information on Log On Numbers and Durations as well as Story Load Times.

The Story helps you now not only to answer Backend, it also lightens the dark of some SAC Frontend related Information. And this again in a sample Story that can be adjusted to your needs.

The Overview Page has been modified to show you KPIs on Number of Logons, Average Logon Duration, and the Average Story Load Times. In addition we sum up the Top 5 Users by Logon Time and the Top 5 Stories by Load Time.

Besides the Timeframe you are interested in, you will be able to filter for a specific User or Story.

We help you to get an idea of the Usage, Adoption and Performance of specific Stories.

The Frontend Statistics Page contains two charts. The first chart shows the Number of Logon in contrast to the Average Logon Duration whereas the second chart provides a history on Story Load Times. This can be helpful to identify a specific date or event since the performance increased or decreased.

The Frontend Analysis Page contains the same filter possibilities as the Frontend Statistics Page and provides two chart and table combinations. The first one highlights the 10 Users with the highest Total Logon Duration and highest Average Logon Duration. This helps to identify whether there are single problems or whether the whole user community suffers. The chart provides also a history on Logon Times to identify events or dates that led to an improvement or a degradation. The table on the left to the chart is linked with it to get information only for a specific user and its history.

The second Table and Chart combination provides the same information for the Top 10 Stories by Highest Average Open Duration.

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.

Pleas also check the blog SAP Analytics Cloud Network Statistics for Network Statistics and SAP Analytics Cloud Performance Analysis Tool for analysis of single Story or Analytic Application runs.

Assigned Tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Max One
      Max One

      Hi Thomas,

      thank you for this helpful blog!

      Do you know why some S/4 HANA Live Connections are shown as Connection “SAC”, Model “UKNOWN” and story “UNAVAILABLE”?

      This makes the detailed analysis very difficult.

      Best Regards

      Max

      Author's profile photo Oleksandr Kovalenko
      Oleksandr Kovalenko

      Normally the "SAC" as a connection name means that it is the direct, not live, connection. If you have it for live connections then it is a bug. Could you tell me which system is that so we can have a look? Answering your second question, sometimes it is not possible to retrieve the model or story name for some reasons. In these cases you see the "UNKNOWN" model or "UNAVAILBLE" story.

      Author's profile photo Bjørn Winther Nielsen
      Bjørn Winther Nielsen

      Hi Thomas

      Do you know why the model (SAC_USER_FRIENDLY_PERF_ACTION) for frontend only have data going back 2 weeks?

      Br

      Bjørn

      Author's profile photo Thomas Fery
      Thomas Fery
      Blog Post Author

      Hi Bjørn,

      do you still have only data for the last two weeks?

      Best regards,

      Thomas

      Author's profile photo Alexander Prill
      Alexander Prill

      Hello, in our model we can also only see last two weeks data, can this limitation be extended?

       

      Best regards,

      Alexander

      Author's profile photo Everton Veiga
      Everton Veiga

      Hello-

       

      Although I'm the tenant owner in a new tenant, I can't see the SAC content and the models listed on this post, can anyone help here?

      Thanks,

      Everton

      Author's profile photo Thomas Fery
      Thomas Fery
      Blog Post Author

      Hi Everton,

      you should find the folder SAC Content in the System Files Directory.

      Thank you,

      Best regards,

      Thomas

      Author's profile photo Andreas Kramer
      Andreas Kramer

      Same here.
      Maybe the SAC content folder was not rolled-out for fast track tenants?

      Author's profile photo Thomas Fery
      Thomas Fery
      Blog Post Author

      Hi Andreas Kramer ,

      the content is available on every tenant. Pleas see comment for navigation path above.

      Thanks,

      Thomas

      Author's profile photo Ysaline de Wouters
      Ysaline de Wouters

      Hi,

      Is there a way to integrate this standard SAC story with analytic query 2CRVCOLAPSTATAQ in SAP BW in order to analyze the query runtime of queries ran in BW and SAC stories which are built on a live model (connection to BW4)?

      Thanks,

      Ysaline

      Author's profile photo Jan Lentmaier
      Jan Lentmaier

      Hi Ysaline de Wouters ,

      the performance statistics are currently only available in SAC. If you use a live connection to SAP BW and the query is sent from SAC, it should be traced within the query statistics. Unfortunately I do not know what the code is and we do not trace these query codes.

      Best Regards,

      Jan

      Author's profile photo Jasper Schaepman
      Jasper Schaepman

      Hi,

       

      I was wondering how the measure duration is calculated?

      It is in seconds I assume [S]. For example open resource duration. I've played around a bit with opening stories and then check how this influenced my data. It didn't seem to match. How "live" is the report (ofcourse after a reload of the statistics report)?

      Thanks in advance!

      Author's profile photo Hossein Jafari
      Hossein Jafari

      Hi Thomas,

      I created a dashboard in SAC and used this model as my source.
      To see how the count of active users is developed in the last year, I created a line chart and added number of active user as measure and calendrer time as dimension without any filter on my story or on my chart. But I see just the number of user for this month and last two months and not more.

      What could be the problem or how can I change it to see more data from last months?

      Regards,
      Hossein

      Author's profile photo Thomas Fery
      Thomas Fery
      Blog Post Author

      Hi Hossein Jafari,

      you did it correctly. The problem is here that the data in the Model is not designed to do long term usage and adoption analysis. It has a size limitation.

      We are going to introduce new content for that information soon.

      In the meanwhile you could try to use the Model ACTIVITY_LOG from SAC Content under System > Common.

      Thanks,
      Thomas

      Author's profile photo Yuting Zeng
      Yuting Zeng

      Hi Thomas,

      I created a Usage Dashboard on SAC and used the Model ACTIVITY_LOG. But I can only drill down to "Month" but not "Week". Stakeholders want to see the comparison between each week, month, quarter and year. Here are the details of this question. Is there any way that I can change the ACTIVITY_LOG Model?

      SAC Usage dashboard ACTIVITY_LOG model - how to include Week level to "Date" hierarchy | SAP Community

      If the hierarchy issue can be solved, the next question would be how to compare weekly data. I compared monthly, quarterly and yearly data by adding variance but for weekly data there is no Activity-PW (previous week).

      Variance

      Variance

       

      Thanks in advance!!