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.

Overview

Overview

 

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%20Page%20-%20Filter%20Bar

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%20-%20Data%20Action%20KPIs%20Numeric%20Point%20Charts

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%20-%20KPIs%20Top%20Fives

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%20Action%20KPIs

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.

Details

Data%20Action%20Analysis%20Details

Data Action Analysis Details

What’s next?

  • Statistics for Versions on Planning Models

Assigned Tags

      7 Comments
      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?

      thanks

       

      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,

      Thomas

      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.

      Regards,

      Oleksandr

      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,

      Oleksandr

       

      Author's profile photo Charlotte BURNIER
      Charlotte BURNIER

      Hello

      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.

      Thanks

      Charlotte