Hi,
Please check the user level security or authorization in CMC for HANA connection.
Regards,
Vidhya.V
Dear Saranya,
we haven’t had success too but are one step farther. I think it is no authorization issue.
I tell you what we have tried. We still are on a productive BI 4.1 platform and installed BI 4.2 (SP03) for first testing. We have recognized differences in OLAP connections, provider ‘SAP HANA’:
BI 4.1: 2 fields: ‘server’ and ‘instance number’ (no port number asked)
BI 4.2: 1 field: ‘data source’ for [server1]:[port1]
Design Studio was able to see the HANA connection from BI 4.1 but it failed to connect to ‘jdbc:sap://[host]:30115’.
Design Studio was unable to see HANA connection from BI 4.2 with the port that was given to us. We then checked port 30115 from prior error. Now we had success in seeing the connection but got another error.
By googling ‘HANA 30115’ I found following link: ‘TCP/IP Ports of All SAP Products’
https://help.sap.com/viewer/ports
When I search the entire table by ‘HANA’ it shows ports to consider - many above 30000. Maybe this helps you to find the right port in case the port was the reason of not seeing the OLAP connection.
Please let us know if you succeed because we also intend to establish a working OLAP connection to HANA (S4HANA). But I guess we also have to do something on HANA side.
Regards
André
from 4.2 onwards, SAP recommends to use http connection, no longer supports JDBC connection.
And also you need to make changes to mdas.properties file in server.
The MDAS property multidimensional.services.enable.hana.http.connections is 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.properties and on Unix under <BI platform install directory>/java/pjs/services/MDAS/resources/com/businessobjects/multidimensional/services/mdas.properties.
Add comment