Skip to Content
Author's profile photo Michael Pytel

Using Lumira with Solution Manager 7.1 CHARM (ITSM Analytics) BW Reports

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


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


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 🙂


Click Create


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.


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.


Michael Pytel

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Jerry Zhu
      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,


      Author's profile photo Michael Pytel
      Michael Pytel
      Blog Post Author

      Yes, all standard but configuration required. You can find the ITSM Analytics guide here>

      After ITSM Analytics was working - Lumira consumed them without issue.

      Author's profile photo Jerry Zhu
      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?



      Author's profile photo Monalisa Biswal
      Monalisa Biswal

      Nice Blog!