Skip to Content
avatar image
Former Member

SAP BO Analysis for Excel and HANA integration

Hi

I could not connect BO analysis for Excel(ver2007) with HANA.

Below is the operation

Open Excel 2007 -> click Analysis Menu -> Import ->click data source

Enter BO user id and password and click OK.

Select data source screen appears- Here I can see the list of datasource

when i click JDBCHANA datasource it says HANA ODBC driver does not exists.

Should i have to install HANA client for 32 Bit(win IA 32 bit version)? but my OS is 64 bit.

Pls advice.

Below things are already installed.

Installed SAP BO Analysis(32 bit) for Excel 2007

Environment is Win Server 2008 R2 Enterprise 64 bit.

Already installed SAP HANA Client ver 34 - X64 bit

SAP HANA Database Client for MS Excel is also installed version 28

When i used ordinary Excel2007 ->menu Data->datasource->select datasource wizard ->Select HANA MDX Provider

give login information and connect. it works.( i hope HANA DB Client for Excel ODBC 32bit driver helps here)

But for SAP BO cannot use the same driver?

Any addition setting is required in ODBC settings?

pls advice.

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 27, 2012 at 03:37 AM

    Hi,

    Just to add to the link already provided. You get a 32 bit and 64 bit installation of BO analysis for Office and the version you install depends on your office version not your OS version, but in saying that you have installed the correct version otherwise the application would not launch.

    I would also recommend you check the version of the client drivers you install match your HANA Version.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Rama Shankar

      Hi

      Sorry, this issue still exists so i thaught of continuing this thread.

      we have created SYSTEM DSN(DSN name SYS_HDBODBC) using Adminitrator user,to connect with HANA. now the connection is fine.

      when i login system with different user and click SYSTEM DSN tab, it gives security warning message and finally SYS_HDBODBC DSN name is displayed.

      but when i open Analysis i could not find SYSTEM DSN in select datasource box.

      however i could only see the USER DSN name over there.

      How to bring SYSTEM DSN in select datasource...? pls advice.

      Regards

  • avatar image
    Former Member
    Jul 27, 2012 at 02:11 AM

    Hello

    Please check below thread..

    http://scn.sap.com/thread/3170907

    Add comment
    10|10000 characters needed characters exceeded