Skip to Content

OLAP Connection SAP Hana 2.0 invisible in Analysis for Office

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 23 at 03:32 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23 at 03:56 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23 at 05:23 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 24 at 07:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded