Skip to Content

Connecting HANA and Analysis for Office

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 –> Add

hana 1.png

4. Select the driver HDBODBC32

hana 2.png

5. Provide a name and description

hana 3.png

6. Provide your credentials. Connect.

hana 4.png

hana 5.png

Launch Analysis for Office from Desktop

Start –> All Programs –> SAP Business Intelligence –> SAP Business Objects Analysis –> Analysis for Microsoft Excel

hana 6.jpg

  • Navigate to Analysis tab. Click insert Data source.

hana 7.jpg

hana 8.jpg

  • A prompt to connect to SAP BI Platform appears,

hana 9.jpg

Once connected, Data source can be chosen either by ‘search’ tab or ‘folder’ tab.

hana 11.png

Be the first to leave a comment
You must be Logged on to comment or reply to a post.