Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
TammyPowlas
Active Contributor

lluis.salvadorsuarez 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

Select Other/Advanced

Select SAP BW OLE DB Provider

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

I select a Pivot Table

Simple results:

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 jansirani.murugesan

5 Comments
Lluis
Active Contributor
0 Kudos

Thanks for Share that option Tammy, there are a lot of customer that don't have BO license but use Solution Manager, i will try for my self and give you some feedback.

Regards,

Luis

former_member183107
Contributor
0 Kudos

Great work Tammy!!

It will be very helpful!!

Regards,

Himanshu

0 Kudos

Tammy, I tried your method, but Excel hung when I logged on to our Solution Manager instance.  I double checked, and I had the right client, ID, and password.  Has this happened to you?  Any idea what I should check for?

Thanks very much.

                                   Gordon

TammyPowlas
Active Contributor
0 Kudos

Hi Gordon - mine is not hanging; did you try testing the connection?  Also see http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/1031a475-a633-2a10-f4b4-ccfe615c0... as it may help you

0 Kudos

Thank you, Tammy.  That link told me exactly what I needed to know.  Now that I can connect, I'll have to figure out which of the hundreds of data cubes I should use, but I'll work that internally.

                                   Gordon

Labels in this area