SAP Analytics Cloud Data Action Performance Statistics and Analysis
In this blog post I want to introduce new statistics and analysis capabilities for Data Actions in SAP Analytics Cloud.
The goal is to enable the user to:
- get an overview of the Data Actions
- see statistics, detect patterns and trends in the execution history
- analyse single Data Actions that have been triggered
When and Where do I get it?
With Wave 2021.07 and 2021.Q2 QRC Release the Story Data Action Performance Statistics and Analysis and the underlying Live Model PLANNING_DATA_ACTIONS will be released.
Data Action Performance Statistics and Analysis will be deployed automatically under the System Directory into the folder SAC Content which is already known from previous shipments of SAP Analytics Cloud Performance Statistics and Analysis. In case you need more details on how to find the content please visit the “Where can I get it?” Section of SAP Analytics Cloud Performance Analysis Tool.
How can I use it and what information can I access?
Once you open the Story Data Action Performance Statistics and Analysis, the Overview page will open.
The Overview page can be distributed into two sections. On one hand on top of the page the filter bar and on the other hand below it, the KPI section.
In the filter section you can limit the KPI section to a timeframe and a specific Model that you are interested in or get the full picture.
Data Action KPIs
The KPI section shows 6 Numeric Point Charts with variance values for the previous period for each KPI.
The first points the number of users that either have scheduled a Data Action or directly triggered one from within a Story or Analytic Application.
The second chart shows the number of Models that have been accessed by Data Actions.
The third chart indicates the number of Data Actions that have been triggered whereas the fourth charts shows how often those Data Actions have been executed.
The fifth and sixth charts show how many of these executions have been scheduled via from a calendar task or from a Story or Analytic Application within the selected timeframe.
Below this information we show three top 5 “Data Action/ Model – Combinations” rankings for the following criteria:
- Median Duration to complete [ms]
- Number of Executions
- Number of Failures
Statistics and Analysis
The second page focuses on Data Action statistics and analysis.
The page is structured into four sections. First we have a KPI section, followed by a Time Series Chart that can be used to filter the table below which lists the data actions per date and can be used to filter further down to a single data action on a specific date. The different status and steps of single entries can then be analysed.
The data can be limited by Date, Data Action, Model Name, User Name, the Story or Analytic Application where the Data Action has been triggered from and whether the Data Action has been scheduled by a calendar task or by Story or Analytic Application.
The Data Action KPIs show the average and maximum number of executions, the median and maximum duration, and the amount of successful and failed executions for the selection.
Execution Count and Maximum Data Action Count
The time series chart shows the execution count and maximum Data Action duration in milliseconds for the selection.
This chart can be used to filter the tables below for a specific date which results in a table view that shows the date and time when the Data Action has been triggered, its final status and the name of the Data Action and the Model that has been used. In addition we show the number of steps of the Data Action, the name of the Story, Analytic Application or Calendar Task that it has been triggered from as well as the type of the same and the full duration of the Data Action in milliseconds.
Data Action Statistics and Analysis
Once you have selected a single entry, you want to analyse, the two tables at the bottom of the page refresh for detailed analysis of the Data Action.
The left table shows the status and step overview with each step’s timestamp whereas the right table shows the duration for each of the steps. This helps to understand whether the Data Action was waiting to be processed, whether a specific step during the processing was problematic, etc.
- Statistics for Versions on Planning Models
Just a question. I'm working on BW4 backend system, and the performance analysis tool traces the total backend time but doesn't trace the widget drilldown backend details.
So I can see the total time backend for each page but I didn't understand if the BW query has a issue.
Do you know this restriction?
Hi Viviana Venturini,
currently we do not collect the backend requests for BW. This is something that we planned to enhance in near future and are currently working on it.
Please check from time to time the "Latest innovations" in SAP Analytics Cloud Performance Analysis Tool
I will update new release information there.
Sometimes runtime info is not enough to get a clear picture of how heavy certain steps are.
- How can we monitor memory consumption of data actions & (auto-)publish follow-up action?
- How can we monitor nr. of records changed?
Unfortunately, the information about the memory consumption of data actions and number of changed records is unavailable in the current setup.
Hi Oleksandr, are there any plans for supporting more measurements?
As of now we don't have materialized plans for extending the current dashboard. In any case, we appreciate your feedback and it was recorded by us. As soon as we collect a defined number of customer requests pointing to the same problem area which was not covered by us, we'll put it into our to-do list for future implementations.
I fully support and emphasize Jef's request.
The dashboard should indicate the number of records and the memory consumption in every data
action with "failed" status.
In the meantime, could you please provide a workaround to get this information maybe with the Chrome console.