Skip to Content
Author's profile photo Rahul Mahajan

Data Geek Challenge 2 – ST22 Dump Analysis using SAP Predictive Analysis

Programmer always wants his/her code to be dump free. However, sometimes during unit testing we get some dumps which can be viewed from transaction ST22. One day I was also doing testing and suddenly program dumped and then went to ST22 and analyzed the logs.

Suddenly some questions came to mind and that was How many dumps we get/produce J daily in a particular SAP landscape? Is there any specific dump we are getting for particular time frame? And many more…


To answer these questions, SAP Predictive Analysis can be used to decide what can be done to avoid those in future. To do so, we will need a dataset. I have used following dataset.


Dumps from ST22 from August 01, 2013 to August 19, 2013


As the data downloaded from SAP cannot be uploaded as it is, we need to format it. The file after formatting looks like as follows:

/wp-content/uploads/2013/08/1_266807.png

Later simply upload data using any of the below data source.

/wp-content/uploads/2013/08/2_266808.png

Define some attributes as measures. Drag measure on Y-Axis and then some other fields on X-axis and then select different views, graphs, pie-charts etc. and do your analysis.

/wp-content/uploads/2013/08/new_266974.jpg

Let’s see various scenarios which will answer above questions.

Scenario 1: Daily Runtime Errors in SAP System from Aug 1, 2013 to Aug 19, 2013


We can see that total number of runtime errors day wise for a particular time in below graph. We can easily found out on which day dumps were maximum.

/wp-content/uploads/2013/08/4_266730.png

However this is still not helping us in identifying by which user id we are getting maximum dumps on various days. Let’s see next scenario for this.

Scenario 2: Date and User ID wise Runtime Errors in SAP System 230 (Aug 1, 2013 to Aug 19, 2013)

From below screenshot we can easily find out that on August 1st 2013 there were maximum dumps by user id SysuserALE and total errors were 570. Apart from that we can also find out date and user wise dumps.

/wp-content/uploads/2013/08/5_266811.png

Scenario 3: Maximum Runtime Errors by USER ID


/wp-content/uploads/2013/08/6_266812.png

Runtime Errors user wise in terms of Pie Chart


/wp-content/uploads/2013/08/7_266813.png

Runtime Errors user wise in terms of HEAT MAP


/wp-content/uploads/2013/08/8_266814.png

Runtime Errors user wise in terms of TAG CLOUD

Scenario 4: Maximum Runtime Errors in SAP Landscape 230 by runtime errors name (Aug 1, 2013 – Aug 19, 2013)


In scenario 3, we saw maximum errors by a particular USER id. Let’s see maximum errors by error name itself. “RFC_NO_AUTHORTITY” error was highest in number during mentioned time frame.

/wp-content/uploads/2013/08/9_266815.png

/wp-content/uploads/2013/08/10_266816.png

Scenario 5: Maximum Runtime Errors by Date


Now let’s find out maximum runtime errors date wise in RADAR Chart.

/wp-content/uploads/2013/08/11_266817.png

Till this point we were just analyzing errors by user id, by error wise, date wise and overall daily how many runtime errors we get in SAP Landscape.

In next scenario, we will see is there any trends in occurrence of these errors?

Scenario 6: Runtime Errors Trend in weekdays and weekends


As name itself suggest, we can see that runtime errors coming on weekends or holidays is significantly getting reduced while it’s getting increased on weekdays.

/wp-content/uploads/2013/08/12_266818.png

Another view for similar trend.

/wp-content/uploads/2013/08/13_266819.png

Till this point we were just doing the analysis of available data in various formats such as Graph, 3D views, Pie Charts, Geographical view etc. but SAP Predictive  Analysis also provide option to predict results based on data. Following are some steps for predicting results.

/wp-content/uploads/2013/08/14_266820.png

/wp-content/uploads/2013/08/15_266821.png

Click Yes. It will take you to Results tab which has 3 different tabs. Grid, Charts, Visualize. Since this is not good data for prediction, results are not appropriate. Please ignore the results. I have added these just for reference.

/wp-content/uploads/2013/08/16_266822.png

Closing remarks:

There are many other views/charts available in SAP Predictive Analysis tool such as geo-graphical view but that can be used for a dataset which involves measures such as Country, state etc.

If you want to see that feature, please refer my blog at SCN:

http://scn.sap.com/community/lumira/blog/2013/08/15/data-geek-challenge–district-wise-season-wise-crop-production-statistics-in-india-from-1998-to-2003-by-using-sap-predictive-analysis

Note: This is just one simple example and does not demonstrate all the functionality available in SAP Predictive Analysis tool.


I hope you like this blog and look forward for your comments and suggestions.


Thanks for reading!!!! 🙂

Assigned Tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      nice work Rahul. 🙂

      I liked the title you have chosen for this blog. really fantastic. !!!

      Rgrds,

      Jitendra

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Jitendra Kumar Kansal 🙂

      Author's profile photo Former Member
      Former Member

      Good Analysis.

      Best Regards,

      Naresh K.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author
      Author's profile photo Former Member
      Former Member

      Good. You took SAP short dump analysis to analyse with SAP Lumira.

      Its an indicative analysis.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment Kumar Sunny !

      I have used SAP Predictive Analysis. It's bit different from Lumira.

      SAP Predictive Analysis = SAP Lumira + Predict

      I am still struggling with predict part. I mean with limited trial version only a few algorithms are available and those also requires numeric columns.

      I am working on this. I will update this blog once have concrete results.

      Cheers!!!

      Rahul

      Author's profile photo Former Member
      Former Member

      Have you had a chance to use the new Lumira version? (SP12)

      If you haven't, I highly recommend the download (for FREE).

      Try to do some powerful analysis with Lumira, and let's see where we can go!

      If you run into anything that may require help, just give the Expert Team a call, or tweet us!

      @SAPLumiraExpert

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Irshaad Bijan Adatia for comment and suggesting new version of Lumira. I will definitely try it.

      Do we also have same team for Predictive Analysis? I am struggling with some Predict part of it. I am working on it.

      Keep Learning,Sharing and Inspiring! 🙂

      Author's profile photo Former Member
      Former Member

      My pleasure Rahul,

      Although I don't know of a team for Predictive Analysis, have you tried using SAP Lumira to accomplish what you'd like to do?

      We can try to make something work with that! 🙂

      Join other's who've called in for help as well +1-855-5-LUMIRA (586-472)

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Hi Irshaad Bijan Adatia,

      No, we can not achieve it with SAP Lumira.

      SAP Predictive Analysis = SAP Lumira + Predict

      Anyways, I am working on it and ll update my blog once have something concrete.

      Thanks,

      Rahul

      Author's profile photo Former Member
      Former Member

      We are eagerly anticipating your post!! 🙂

      Author's profile photo Srinu S
      Srinu S

      Good Job. Keep it up. thanks for sharing.