Skip to Content
0

OLAP Connection SAP Hana 2.0 invisible in Analysis for Office

Apr 23 at 03:16 PM

89

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Tammy Powlas
Apr 23 at 03:32 PM
0

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."

Share
10 |10000 characters needed characters left characters exceeded
Benjamin Gravouil Apr 23 at 03:56 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Diego Ferrary
Apr 23 at 05:23 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Benjamin Gravouil Apr 24 at 07:07 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded