Skip to Content

Reporting Against Solution Manager – with no BI Tools

Lluis Salvador Suarez asked me on a blog about how to report on Solution Manager with no BI tools.  Personally I do not do this, but you could use Excel directly against the BW cubes inside Solution Manager.

In Excel go to Data > Other Sources > Data Connection Wizard

/wp-content/uploads/2013/08/1datasource_267608.jpg

Select Other/Advanced

/wp-content/uploads/2013/08/2otheradvanced_267609.jpg

Select SAP BW OLE DB Provider

/wp-content/uploads/2013/08/3adatalink_267610.jpg

You will log on to Solution Manager.  Then select $Infocube and your desired InfoCube.  I am select Incident Management Message Reporting.

/wp-content/uploads/2013/08/3connectocube_267611.jpg

I select a Pivot Table

/wp-content/uploads/2013/08/4pivotable_267612.jpg

Simple results:

/wp-content/uploads/2013/08/5results_267614.jpg

Some down sides to this, in my opinion, are there are too many fields from the InfoCube are in the field list of the pivot table.  SAP BusinessObjects Analysis, edition for Microsoft Office is much easier to use as it can use the BEx Query as a data source (in addition to the cube) and limit what is returned from the cube.  My preference would be to use Analysis Office instead of Excel, but in case you do not have a license for it, this may be an alternative.

Related Link

How Is The Health Of Your SAP Solution Manager BI Content?  by Jansi Rani Murugesan

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