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 instructions. And 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.
Thanks!
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
Yes, all standard but configuration required. You can find the ITSM Analytics guide here>
http://wiki.scn.sap.com/wiki/display/SAPITSM/SAP+ITSM+Analytics+on+SAP+Solution+Manager+7.1
After ITSM Analytics was working - Lumira consumed them without issue.
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
Nice Blog!