If you have a HANA system, you can connect directly to your HANA system from Analysis for Office. This enables you to bypass the need for universes and connect directly your HANA views.

The below steps illustrate how this can be achieved.

Following are the steps to create the connection between HANA and Analysis for Office (32 Bit):

  1. Navigate to C:\Windows
  2. Run odbcad32.exe
  3. Under User DSN tab -> AddConnecting to HANA System from Analysis for Office - 1
  4. Select the driver HDBODBC32

Analysis Office connects to SAP HANA always via an ODBC layer. It is necessary, hence, to install the HANA ODBC middle-ware on the local machine where the tool is running.

The HANA middle-ware has to be of the same bit version than Analysis office: 32 bit or 64 bit.

From Windows, make sure you start the correct ODBC driver manager.

(File name for the 32bit version: C:\Windows\SysWOW64\odbcad32.exe;

File name for the 64bit version: C:\Windows\System32\odbcad32.exe).

Connecting to HANA System from Analysis for Office - 2

5. Provide a name and descriptionConnecting to HANA System from Analysis for Office - 36. Provide your credentials. Connect.Connecting to HANA System from Analysis for Office - 4

Connecting to HANA System from Analysis for Office - 5

Launch Analysis for Office from Desktop

Start -> All Programs -> SAP Business Intelligence -> SAP BusinessObjects Analysis -> Analysis for Microsoft Excel

Connecting to HANA System from Analysis for Office - 6

Navigate to Analysis Tab.  Click Insert Data Source.

Connecting to HANA System from Analysis for Office - 7

Connecting to HANA System from Analysis for Office - 8

A prompt to connect to SAP BI Platform appears

Connecting to HANA System from Analysis for Office - 9

Data Source can be chosen either by ‘search’ tab or ‘folder’ tab

Connecting to HANA System from Analysis for Office - 10

Got questions? Click here to reach out.

5600 Tennyson Pkwy
Suite 120
Plano TX 75024.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com

Join Jueun, as she explores the differences between SAP Big Data platform and Cloud platforms, to deliver Big Data Analytics.

You have Successfully Subscribed!