Skip to Content
avatar image
Former Member

Where to get database tables of SAP Solution Manager 7.2 ?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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 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.

    Add comment
    10|10000 characters needed 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

  • 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

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

    thanks

    Prakhar

    Add comment
    10|10000 characters needed characters exceeded