This document talks about How to troubleshoot the issues while creating HANA HTTP connection in BI Platform and consume in Analysis Office.
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.