Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Neha_Kumari
Advisor
Advisor
0 Kudos

Hi,

This document talks about How to troubleshoot the issues while creating HANA HTTP connection in BI Platform and consume in Analysis Office.


Prerequisites:

Business intelligence Platform 4.1 SP05 or higher
SAP HANA Platform SP09 or a higher version

Enable SAP HANA HTTP option by editing mdas.properties file in the server.
Check note 2182187 - How to enable hana http connection in CMC OLAP connection's provider for details.

Create OLAP connection by selecting SAP HANA HTTP under data provider.
Once we click on connect, error appears “Failed to get connections for connection[Server] using session locale[English]”

This is a limitation for 4.1 SP6 and lower version.
For more details, refer 2182585 - Cannot connect to the Hana via SAP Hana Http OLAP connection in CMC.


OLAP connection can be created without selecting the Cube and can be consumed in Analysis for Office 2.0.

Note : Verify the status of HANA server by pinging HANA server machine from BI server. Verify the port number is 80xx, where xx is the instance number.


Login to Analysis for Office and select the OLAP connection. It throws below error.



For such Authorization issues, check the required roles assigned to the HANA user.

-  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 “Importing the Info Access Service” in the SAP HANA Search Developer Guide.

  The role sap.bc.ina.service.v2.userRole::INA_USER is 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.

Now, the connection should work properly. You can go ahead and use the connection in Analysis for Office.

Regards,
Neha

5 Comments