Skip to Content
avatar image
Former Member

how to connect SAP HANA in LUMIRA DESIGN

Dear everyone:

I can not connect to HANA when use LUMIRA DESIGN , how to creat olap connect with hana http ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 20, 2017 at 12:07 PM

    You need to login to CMC, and create olap http connection.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20, 2017 at 12:15 PM

    Check the admin Guide for SAP Lumira.

    • you use a BI platform 4.1 SP5 or a higher version.
    • The MDAS 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.propertiesand on Unix under<BI platform install directory>/java/pjs/services/MDAS/resources/com/businessobjects/multidimensional/services/

    • The SAP HANA Info Access Service (InA) with delivery unit HCO_INA_SERVICE is deployed on the HANA platform.

      You can find more information in chapter in "Importing the Info Access Service" in theSAP HANA Search Developer Guide.

    • The rolesap.bc.ina.service.v2.userRole::INA_USERis assigned.

      The role is contained in delivery unit HCO_INA_SERVICE. Verify that the following authorizations are selected: Schema _SYS_BIC, Schema _SYS_BI and Schema _SYS_RT. For more information, see SAP Note2097965 Information published on SAP site.


    1. In the Central Management Console underOLAP Connections, clickNew Connection.
    2. Enter a name and a description.

      The description is optional.

    3. SelectSAP HANA httpas provider.
    4. AsServer Information, enter a URL with the following structure:http(s)://<server>:<port>

      We recommend to use HTTPS as scheme.

      The default HTTP port settings for SAP HANA XS include an SAP HANA instance number: 80<SAP HANA instance>, for example 8001. You can change the default settings, for example, to ensure that standard ports 80 and 443 are used for client access to the SAP HANA XS Web server HTTP (80) or HTTPS (443).

      For more information, see chapter "Maintain Standard HTTP Port Numbers with SAP HANA XS" in the SAP HANA Administration Guide.

    5. Select theAuthenticationtype:
      • SSO(single sign-on)

        With the single sign-on option selected, the user has to sign on once to the BI platform. The authentication method for this connection is SAML 2.0.

        For more information, see chapters "User Authentication and Single-Sign" On and "Maintaining Single Sign-On for SAP HANA XS Applications" in theSAP HANA Administration Guide.

      • Pre-Defined

        With this option selected, the administrator enters a specific user and password which will be stored as part of the connection object.

    6. ChooseSaveto create the connection.
    Add comment
    10|10000 characters needed characters exceeded