Skip to Content
0

Where to get database tables of SAP Solution Manager 7.2 ?

Jul 31, 2017 at 03:33 PM

634

avatar image
Former Member

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!

Thanks,

Abin

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
0

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 https://community.tableau.com/docs/DOC-9946 - 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
Former Member

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.

Thanks,

Abin

0
Prakhar Saxena
Aug 02, 2017 at 12:44 PM
0

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

https://blogs.sap.com/2017/02/28/sap-solution-manager-7.2-dashboard-builder/

thanks

Prakhar

Share
10 |10000 characters needed characters left characters exceeded