Skip to Content
Author's profile photo Lluis Salvador Suarez

Analysing Data from #solman Incident Management with SAP Lumira

Inspired on post from friend Tammy Powlas  i decided to try to find a good utility for new SAP Lumira tools used for analyse data, lets go to see how it works to process data from excel source. In that link you will find more information about Lumira, http://scn.sap.com/community/lumira.

lest go to see how it works within Solman data.

1.- Run SAP Lumira and create a new document data, chossing excel source.

/wp-content/uploads/2013/08/cap_256901.png

2.- I need to collect some data, but for looking for something different and related to SAP Solution Manager i decided to collect data from Solman Incident management and upload it to SAP Lumira, i download to excel file only 1426 oss sap message.

/wp-content/uploads/2013/08/cap_256901.png

3.- Once the file is opened with SAP Lumira, if you forgot to create data aggregates inside excel you can do it simply using that option, and on the next step “Show Data” you will be able to start Analyzing information from data source.

Option to auto create metrics Metrics created
/wp-content/uploads/2013/08/cap_256901.png /wp-content/uploads/2013/08/cap1_256911.png

4.- After change Message Number ( a field that hod the row number on excel) to count, you can add indicator to Y axis.

/wp-content/uploads/2013/08/cap2_256912.png

5.- Now the next step is to play with attributes and graphic options to display data.Lest go to see the the average of priority, adding priority attribute to X axis; i just surprise with that, the medium priority is higher than “high”; usually message report always think that his problem is usually a high one, but here we can see that firs level of support is doing well their job verifying the correct priority of each message.

/wp-content/uploads/2013/08/cap3_256934.png

6.- Now i will check from each message grouped by priority, who is the reporter; for that we need just to add a new attribute on X axis, trellis option will allow us to see data on 3 individual rows, and when we move “rep” to “Color de la leyenda” that will generate a right view with data from that field.

/wp-content/uploads/2013/08/cap4_256935.png

7.- Now lets go to group data to analyse information about processing og message in solution manager.

Messages number by product versión: Here SAP Solution Manager message is near to SAP ERP valure (orange), that indicate a good trend for solman.

/wp-content/uploads/2013/08/cap5_256936.png

How is the reporter that has highest number of message confirmed automatically ?

/wp-content/uploads/2013/08/cap6_256940.png

Message number grouped by Reporter excluding confirmed message.

/wp-content/uploads/2013/08/cap9_256941.png

Now Lets got to see a tag cloud grouped by message sap component, excluding “SV-SMG-SUP-TST”.

/wp-content/uploads/2013/08/cap10_256942.png

The last one, Showing message filtering only by very high priority message to display with product version are more affected.

/wp-content/uploads/2013/08/cap11_256946.png

My conclusions is that with that tool it’s easy to read data, analyse and get a quick view of problems related to data, in that example it’s possible to see the load for reporters, the problems related to processing, the impact of each sap component versión, etc… , now it’s possible to load data from CSV, Free hand SQL, Excel, SAP Hana and BO Exterprisse.

Anyone know if with the SAP Solution Manager Enterprise Edition is possible to load data for Lumira using BO Sources ? if that is possible Lumira will be a excellent tools to analyse all Solution Manager Information, not only from crm operations. thinks on analyse technical data from monitoring, bussines process, etc..

I will like to find time to try a more extensive analysis from other sata sources, hope that i can doy before 30 day’s trial expire

Regards,

Luis

Assigned tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Tammy Powlas
      Tammy Powlas

      Nice job!

      I run similar Solution Manager reports every week, except I use BusinessObjects Analysis for Office, not Lumira 🙂

      On this:

      Anyone know if with the SAP Solution Manager Enterprise Edition is possible to load data for Lumira using BO Sources ? if that is possible Lumira will be a excellent tools to analyse all Solution Manager Information, not only from crm operations. thinks on analyse technical data from monitoring, bussines process, etc..

      Lumira supports BusinessObjects Universes

      So you could create a Universe against a standard Solution Manager BW provider.

      Please see document Creating a BI4.1 Universe on top of a BW InfoProvider where I create a universe against a BW Incident Management InfoProvider.

      Or you could use other BusinessObjects tools such as Analysis Office.

      Author's profile photo Lluis Salvador Suarez
      Lluis Salvador Suarez
      Blog Post Author

      +1 Tammy Powlas

      For me it's so hard to use BO analysis, i don't have experience on BO tools 🙁 .

      I will check your link after holidays for try to extract information from Solution Manager BW that contain technical information of technical landscape and system information of each managed system.

      Thanks Tammy ¡

      Author's profile photo Former Member
      Former Member

      that's a great solution for solman report viewers. thanks for this Luis

      Author's profile photo Billy Warring
      Billy Warring

      Lluis Salvador Suarez you should also post this over the in the Lumira space, I just noticed that you can complete another mission by blogging on how you used the software, for the Data Geek challenge.  😉

      Author's profile photo Tammy Powlas
      Tammy Powlas

      He can only move it to the Lumira space as posting the same information twice is again SCN rules of engagement 🙂

      Author's profile photo Billy Warring
      Billy Warring

      I believe has to be in a blog format, vs the doc that he created here also. 

      Author's profile photo Lluis Salvador Suarez
      Lluis Salvador Suarez
      Blog Post Author

      Moved 😉 , thanks Billy for the warning

      I will done a new one comparing ITSM reporting and compare with Lumira.

      Author's profile photo Former Member
      Former Member

      Hi Luis,

      How did you export the data to the .xls?

      Thanks,

      Author's profile photo Lluis Salvador Suarez
      Lluis Salvador Suarez
      Blog Post Author

      Hello Felipe, for the test with Lumira i use an old export from 701 using CRM_DNO_MONITOR, if you are on 7.1 you can use data sources from BW or reports like that:

      http://scn.sap.com/blogs/lsalvador/2013/05/19/where-is-transaction-crmdnomonitor-on-solution-manager-71

      Regards,

      Luis