Technical Articles
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.
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
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.
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
Hi Bjørn,
do you still have only data for the last two weeks?
Best regards,
Thomas
Hello, in our model we can also only see last two weeks data, can this limitation be extended?
Best regards,
Alexander
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
Hi Everton,
you should find the folder SAC Content in the System Files Directory.
Thank you,
Best regards,
Thomas
Same here.
Maybe the SAC content folder was not rolled-out for fast track tenants?
Hi Andreas Kramer ,
the content is available on every tenant. Pleas see comment for navigation path above.
Thanks,
Thomas
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
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
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!
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
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
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
Thanks in advance!!