how to connect SAP HANA in LUMIRA DESIGN

[former_member415673]

Dear everyone:

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

[former_member185603]

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 .

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.

[former_member415673]

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?

[former_member185603]

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

multidimensional.services.enable.hana.http.connections

[former_member415673]

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