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

SAC Data Management Jobs Statistics and Analysis

NEW Statistics and Analysis Capabilities for Data Management Jobs

Q2.2022 QRC and wave 2022.07 bring brand new information to your tenants.

The Story can be accessed from the same place (Files > System > Common > SAC Content) as the other performance content that has been shipped to your tenants like the SAP Analytics Cloud Performance Statistics and Analysis and has the same look and feel.

But now we offer you the possibility to get an overview of jobs that have been scheduled in your tenant, with frequency, expiry date etc. to, for example, identify housekeeping potential, as well as the possibility to identify long runners and erroneous instances.

The Story contains two pages, Overview and Statistics. Both offer page filter for date, model ID, model name, creator, frequency and status of the job.

Overview

The starting page should give an overview of important KPIs like users that have scheduled jobs, the amount of schedules, the amount of instances as well as the amount of models that are used.

Below the KPIs we show the top 5 jobs or models by different runtime criteria to help you to identify problematic candidates.

 

Statistics

The statistics page shows averages, maxima, median and error percentage of all schedules.

 

The following time series with jobs and their maximum duration shows the historic trend of jobs and their maximum duration, but can also be used to check whether a specific job or model was long running already all the time, or whether we face a specific pattern over time.

This is followed by a table that shows all job instances descending by job duration. It provides information of job log start time, the corresponding model, message type, frequency, result, creator and instance ID.

 

Last you can get details on the job instance from the table above in the following table by selecting one entry and filtering down. You will get the full information on creation date, expiry date, model ID, update method, etc.. This should help you to answer all questions be it for reasons of housekeeping or performance analysis.

 

We hope that this new feature is helpful for you. Stay tuned for news, there is a lot more to come!

Assigned Tags

      14 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Petr Novák
      Petr Novák

      Hello Thomas,

      thank you for this amazing article and very good news. Is it also possible to monitor scheduled jobs for public dimensions that are updating master data? Or is it available only for transactional data import jobs in models?

      Thank you!

      Petr

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

      Hi Petr Novák,

      yes, you get the same information for master data updates.

      Thanks,

      Thomas

      Author's profile photo Marian Canciu
      Marian Canciu

      Hi Thomas

       

      Is it possible to monitor scheduled publications and automatically trigger an alert (f.e. an email) if a publication fails ?

       

      Thank you
      Marian

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

      Hi Marian Canciu,

       

      publications are not part of the solution yet, but this is something we plan to add as soon as possible. I will update this blog once it happened.

       

      Thanks,

      Thomas

      Author's profile photo Sebastian Sättler
      Sebastian Sättler

      Good morning Thomas,

      that looks very interesting. Having the chance to monitor these Import job statistics further was a long time wish.

      Unfortunately i cannot find the new content on our 2022.07 tenant. Neither in the existing stories nor a new story has been added. Is there something i have to do manually?

      Cheers

      Sebastian

       

      Author's profile photo Shailendar ANUGU
      Shailendar ANUGU

      Dear Sebastian,

      Nice to hear from you!!

       

      i have the story in my tenant under files --> system--> common --> SAC content.

       

      SAC version is 2022.08 now.

       

      Thanks,

      Shailu.

      Author's profile photo Sebastian Sättler
      Sebastian Sättler

      Hey Shailu,

      nice to hear from you too 🙂

      And thanks for clarifying. We will get Wave 2022.08 i guess next week. I let you know if its still not visible 🙂

       

      Cheers

      Sebastian

      Author's profile photo Sebastian Sättler
      Sebastian Sättler

      Hi Shailu,

      i have to get back to you with the still existing issue. We are still missing on Wave 2022.08 the mentioned new SAC Story.

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

      Hi Sebastian Sättler,

      the content is deployed to all tenants automatically.

      Do you see the other content in the file repository under System > Common > SAC Content? Could you please open an incident for this?

      Thank you,

      Thomas

      Author's profile photo Petr Novák
      Petr Novák

      Hi Thomas,

      I am investigating this new content and so far I was able to successfully track all import jobs for:

      • Public dimensions (master data update)
      • Classic Account Models (transactional data update)

      But for some reason it seems that import jobs that were triggered for new "measure-based" models are not captured in this content. Could you please just confirm that this content should capture all the imports no matter what kind of model is used?

      For old classic models it works without any problem and on top that it does not matter if the data were uploaded from the Excel file only once or via scheduled job from BW for example. Everything is captured properly. But for new model type - not a single row is appearing in reporting tables. Is there anything I had missed?

      Thanks in advance for your help!

      Petr

      Author's profile photo Thiago Franca Carvalho Silveira
      Thiago Franca Carvalho Silveira

      Hi,

      I'm having this same issue. I can't see one model I created as the new measure-based model captured in the Data management job statistics and analysis.

      Did you find a way to get this captured?

       

      Thanks,

      Thiago

      Author's profile photo Petr Novák
      Petr Novák

      Hi Thiago,

      unfortunately no 😔. It would be great to get some feedback from SAP regarding to this issue.

      Please let me know if you ever manage to solve it.

      Thanks!

      Petr

      Author's profile photo Lena Gessel
      Lena Gessel

      Hi Petr Novák and Thiago Franca Carvalho Silveira

      Sorry, that we missed your questions.

      I would like to let you know, that it is the known gap with showing the statistics based on new models. The issue is under our development. Please follow our release announcements.

      Regards,

      Lena

      Author's profile photo Sayed Zubair D
      Sayed Zubair D

      Hi Lena Gessel,

      Is there any deadline by when this report would include the job details on Measure based models? We were looking for a report that shows all the job details and started using "Data Management Jobs Statistics and Analysis" However we got a blocker stating Measure based models are not included. So now the report looks incomplete.

      Could you please share an insight if this will be included anytime sooner?

       

      Regards,

      Sayed Zubair