Skip to Content
0

how to connect SAP HANA in LUMIRA DESIGN

Sep 20, 2017 at 07:33 AM

484

avatar image
Former Member

Dear everyone:

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

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

2 Answers

Jawahar Konduru Sep 20, 2017 at 12:07 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Jawahar Konduru Sep 20, 2017 at 12:15 PM
0

Check the admin Guide for SAP Lumira.

  • you use a BI platform 4.1 SP5 or a higher version.
  • The MDAS propertymultidimensional.services.enable.hana.http.connectionsis 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/mdas.properties.

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

Procedure

  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.
Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you for your answer , I can not found it which Windows under<BI platform install directory>\java\pjs\services\MDAS\resources\com\businessobjects\multidimensional\services\mdas.propertiesand on

how to found it in this catalog?

2p.png (12.6 kB)
0

2nd file in the list, mdas.properties file. Find this text and change it to True

multidimensional.services.enable.hana.http.connections

0
Former Member
Jawahar Konduru

Thank you very much,I can connect Lumira Design with HANA database in OLAP.

0