Skip to Content

Where to get database tables of SAP Solution Manager 7.2 ?

Jul 31, 2017 at 03:33 PM


avatar image

Hi Experts,

I am building a Dashboard in Tableau on HANA,where I am building some analytics based on the metadata in SAP Solution Manager , like Total no. of requests approved in a day,Total no. of unapproved Requests for change,Classification of requests based on its type (ie, general/Emergency) ...etc.

Where can I fetch these details from. ie. How can I provision Solution Manager Meta data into HANA ?

Any pointers would be highly appreciated!



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Jul 31, 2017 at 04:26 PM

First, I would take advantage of the BW/BEx queries that are available with Solution Manager; Tableau should be able to connect to a BEx query - the 7.2 Solution Manager BW content is the best so that you shouldn't have to build the meta data yourself. I would try this first.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy ,

Thanks for your response.

But in my scenario, We are building These dashboards on a Native HANA platform.There are no BW layer involved.

I can make use of SDI replication from Solman system,If its possible.So If I implement that way,I would need the Database table details - where these metadata info are kept,to be consumed in Tableau dashboard.



Prakhar Saxena
Aug 02, 2017 at 12:44 PM

Hi Abin,

It is no longer required to do all that in Solman 7.2 and you can use dashboard builder to do that easily in a browser.

this way you can achieve it easily.

check below documentation



10 |10000 characters needed characters left characters exceeded