Skip to Content

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply