OLAP Connection SAP Hana 2.0 invisible in Analysis for Office

[Former Member]

Hello,

In CMC I create 2 OLAP Connection with same privilege : SAP HTTP and SAP Hana 2.0.

Unfortunately, in Analysis for Office when I click on "Insert DataSource" I see only the SAP HTTP OLAP connection.

Do you know If it's possible to see also SAP Hana 2.0 OLAP connection ? and How we can do that ?

Thank you very much for your help

[Former Member]

Thank you. I assumed that it was possible to connect to a SAP Hana 2.0 Olap connection in Analysis. So I Will try to do it with http. I will follow this :

https://archive.sap.com/documents/docs/DOC-63479

[former_member151004]

Hi Benjamin Gravouil,

The connection engine delivered with Analysis for Office 2.x is based on HTTP and will not work if you try to use the ODBC connection.

As Tammy Powlas described, you can find all the information related to the connection at the wiki page.

Thanks,

Diego Ferrary

[Former Member]

Hello

I am trying with OLAP connection. I create a SAP HANA 2.0 instead of http because it's multitenant : I have different instance number. my SAP Hana 2.0 OLAP connections is ok because I can select a query. But as I say, in analysis for office I don't see this connection.

[TammyPowlas]

Hello Benjamin - are you trying on ODBC connection? Please see this wiki: https://wiki.scn.sap.com/wiki/display/BI/BI-RA-AO-CON+Connection+and+Authentication

It says "For Analysis for Office 1.4.x you will configure the ODBC connection and for Analysis for Office 2.x you will use the HTTP connection."