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

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.

Filter Bar

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.


Overview Page – Filter Bar


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.


Overview – Data Action KPIs Numeric Point Charts


Below this information we show three top 5 “Data Action/ Model – Combinations” rankings for the following criteria:

  1. Median Duration to complete [ms]
  2. Number of Executions
  3. Number of Failures


Overview – KPIs Top Fives

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.

Filter Bar

KPI Section

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.


Data Action KPIs

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


Execution Count and Maximum Data Action Duration


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.



Data Action Analysis Details

What’s next?

  • Statistics for Versions on Planning Models

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Viviana Venturini
      Viviana Venturini

      Great article!

      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?



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

      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.

      Thank you,


      Author's profile photo Jef Baeyens
      Jef Baeyens

      Hi Thomas!

      Great info.

      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?

      Author's profile photo Oleksandr Kovalenko
      Oleksandr Kovalenko

      Hi Jef,

      Unfortunately, the information about the memory consumption of data actions and number of changed records is unavailable in the current setup.



      Author's profile photo Jef Baeyens
      Jef Baeyens

      Hi Oleksandr, are there any plans for supporting more measurements?

      Author's profile photo Oleksandr Kovalenko
      Oleksandr Kovalenko

      Hello Jef,

      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.

      Best regards,



      Author's profile photo Charlotte BURNIER
      Charlotte BURNIER


      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.