Skip to Content
avatar image
Former Member

HANA connection is not getting listed when launching SAP BO Design studio via BI Platform

Hi All,

I am new to Design studio. I could not find a related post regarding my issue. So raising my question as a new thread.

I am able to launch design studio via BI platform. In CMC, I could find Design Studio Runtime application under application folder. Also the design studio applications are getting auto-saved under favorite folder in BI platform.

The issue is while adding new datasource, there are no connections listed in Design studio but there are connections available in CMC server for HANA. Only one Universe is getting displayed.

Need help to list hana connection details in design studio(when launching via BI Platform).

designstudioconn.jpg

Thanks in Advance

Regards,

Saranya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 11, 2017 at 07:29 AM

    Hi,

    Please check the user level security or authorization in CMC for HANA connection.

    Regards,

    Vidhya.V

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 12, 2017 at 11:06 AM

    Dear Saranya,

    we haven’t had success too but are one step farther. I think it is no authorization issue.

    I tell you what we have tried. We still are on a productive BI 4.1 platform and installed BI 4.2 (SP03) for first testing. We have recognized differences in OLAP connections, provider ‘SAP HANA’:

    BI 4.1: 2 fields: ‘server’ and ‘instance number’ (no port number asked)

    BI 4.2: 1 field: ‘data source’ for [server1]:[port1]

    Design Studio was able to see the HANA connection from BI 4.1 but it failed to connect to ‘jdbc:sap://[host]:30115’.

    Design Studio was unable to see HANA connection from BI 4.2 with the port that was given to us. We then checked port 30115 from prior error. Now we had success in seeing the connection but got another error.

    By googling ‘HANA 30115’ I found following link: ‘TCP/IP Ports of All SAP Products’
    https://help.sap.com/viewer/ports

    When I search the entire table by ‘HANA’ it shows ports to consider - many above 30000. Maybe this helps you to find the right port in case the port was the reason of not seeing the OLAP connection.

    Please let us know if you succeed because we also intend to establish a working OLAP connection to HANA (S4HANA). But I guess we also have to do something on HANA side.

    Regards

    André

    Add comment
    10|10000 characters needed characters exceeded

  • May 12, 2017 at 12:27 PM

    from 4.2 onwards, SAP recommends to use http connection, no longer supports JDBC connection.

    And also you need to make changes to mdas.properties file in server.

    The MDAS property multidimensional.services.enable.hana.http.connections is set to true.

    The configuration file can be found on Windows under <BI platform install directory>\java\pjs\services\MDAS\resources\com\businessobjects\multidimensional\services\mdas.properties and on Unix under <BI platform install directory>/java/pjs/services/MDAS/resources/com/businessobjects/multidimensional/services/mdas.properties.

    Add comment
    10|10000 characters needed characters exceeded