I love new technology and new software.  Lumira has been released for some time.  We’ve all seen it on stage at SAP SAPPHIRE, SAP Insider HANA 2014, etc. so I needed to find a way to get involved.  When implementing Change Request Management (CHARM) on Solution Manager 7.1 – we also have to configure ITSM Analytics for much of the browser based reporting in the CRM UI.  The reports in the UI are all supported by Info Areas and BEx Queries behind the scenes.  Once I realized SAP Lumira can consume a BW Query – I had to try it with Solution Manager 7.1.

There is nothing special in this setup.  ITSM Analytics has been configured per these instructionsAnd I had the required security roles to access ITSM Analytics.

Once you have SAP Lumira installed and licensed (you need a licensed copy to use BW as data source), open Lumira and choose File >> New

/wp-content/uploads/2014/07/2014_07_24_9_17_24_505598.png

Select Connect to SAP Business Warehouse

Enter your connection information and click Connect (it should pull systems from your SAP GUI Logon.ini)

Next, you’ll be presented with a selection screen.  In my case, I didn’t have anything assigned via role so I selected InfoAreas

/wp-content/uploads/2014/07/2014_07_24_14_26_53_505600.png

Next, I selected ‘SAP Solution Manager’ > Service Provider Reporting > Incident Management Reporting – Message Reporting

Why did I select this? I tried finding other InfoAreas that made more sense – but couldn’t find data.  I found the CHARM data using this InfoArea.  Maybe someone can provide some other InfoAreas in the comments section 🙂

/wp-content/uploads/2014/07/2014_07_24_14_27_45_505607.png

Click Create

/wp-content/uploads/2014/07/2014_07_24_9_51_49_505608.png

Next I was presented with the ‘Cross Tab Analysis’ section where I added the fields I wanted for my test report.  In this case I wanted to see Transaction Types and their respective status.

/wp-content/uploads/2014/07/2014_07_24_14_32_06_505609.png

Once I was able to view the data I wanted – I started testing the visualizations.

While not the definitive guide – I hope this gets some people thinking about how we can visualize data within Solution Manager.  We could also try this with the monitoring data in Technical Operations!  Looking forward to more posts on this topic.

Thanks!

Michael Pytel

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Jerry Zhu

    Hi Michael, great bolg! Just a quick qustion: are those BW queries built-in in Solution Manager?  Do we need to do any configuration and/or development to make them available for Lumira to consume?

    Thanks in advance,

    Jerry

    (0) 
      1. Jerry Zhu

        Michael, thanks! The link looks like a great resource.  I’ve set up a Lumira server on HANA and will try it with solution manager reporting later. Just wonder if you’ve used Solution Manager on HANA. If so, how do you feel about it?

        Thanks,

        Jerry

        (0) 

Leave a Reply