Analyzing SAP connection to HANA using Office

Sap Analysis For Office Hana Connection

philip.mugglestone just added a few more video tutorials to the Getting Started with SAP HANA Cloud series, this time about how you can develop business applications accessible for SAP Analysis for Microsoft Office.

In this blog post, you will find the video embedded with some additional information and resources.

The duration of the four tutorials is approximately one hour. During these tutorials, you will gain knowledge on various aspects such as establishing a connection between SAP Analysis for Office and SAP HANA Cloud using the SAP HANA Analytics Adapter (HAA), installing and operating a business application generator in SAP Business Application Studio, creating a sample HDI Container, configuring a stand-alone scenario, enabling personalized access, and setting up an integrated scenario.


– SAP Analysis for Microsoft Office

– SAP HANA Cloud.

Sample Code

To make the most of your valuable time, we have provided code snippets that allow you to effortlessly and joyfully write code. You can find a collection of sample codes on our GitHub repository at

To acquire the SAP HANA Analytics Adapter (HAA), visit the SAP Development Tools section and navigate to HANA.

Hands On

You will need to have an SAP HANA Cloud instance as well. If you are unfamiliar with this subject, it might be helpful to watch a tutorial before proceeding.

Learn More

This tutorial covers the fundamentals, configuration of development tools, and the process of creating a sample HDI Container with a table, example data, and a calculation view.

You might be interested:  Training and job placement opportunities for SAP FICO in the United States

3:40 – Generate a comprehensive cloud application development environment for SAP Business Application Studio.

4:30 – Copy source code URL from GitHub sales repository

At 6:50, connect the project to the HDI container and access it through the SAP HANA database explorer.

9:10 – The editor for Calculation Views in SAP Business Application Studio.


In this guide, we will discover the process of establishing a standalone situation where the SAP HANA analytics adapter is set up to connect with an already existing HDI container.

At 0:45, you can set up the SAP Partner Engineering extension in the SAP Business Application Studio by following the installation process.

At 1:45, access the template wizard and execute the SAP HANA Academy HAA generator.

7:15 – Allocate role collection to a business user using BTP Cockpit.

9:30 – Establish a connection for SAP Analysis in Microsoft Office.

10:30 – Log on as business user and select data source


In this guide, we will explore the steps to enhance the standalone setup for customized access, eliminating the requirement of creating a separate SAP HANA shadow user for every individual business user.

7:40 – Generate a certificate collection specifically for the purpose of JWT.

14:30 – Insert Dynamic Calculation View as data source in Microsoft Excel


In this guide, we will explore the process of establishing a connected environment where the SAP HANA analytics adapter is integrated as part of the primary business application.

At 1:20, access the template wizard for SAP HANA Academy CAP. Rephrase this sentence using your own language without elaborating on the subject matter. Write in Indian English.

You might be interested:  Determining Exchange Rate Difference Account in SAP

2:45 – Integrate and set up the HANA Analytics Adapter (HAA).

10:00 – Access app as data source in SAP Analysis for Microsoft Office

If you find this information helpful, please show your support by liking and sharing it on social media. We appreciate your help!

Over the years, for the SAP HANA Academy, SAP’s Partner Innovation Lab, and à titre personnel, I have written a little over 300 posts here for the SAP Community. Some articles only reached a few readers. Others attracted quite a few more.

To make your reading experience more enjoyable and convenient, we have compiled a carefully selected collection of articles that have surpassed 10,000 views and continue to attract attention each month. Here are some recommended reads (my personal thoughts).

Getting SAP analysis for office – how can I do it?

To begin the installation process, open the installer file (.exe). Next, navigate to the SAP Front End Installer dialog box and select “Next”. In this dialog box, you will find a list of components that can be installed. Choose the specific components you wish to install and proceed by selecting “Next”.

If needed, you have the option to modify the target directory before initiating the installation. Once satisfied with your selection, click on “Next” to start installing. After completion, a confirmation screen will appear where you can choose “Done” to finalize the installation.

Is SAP Analysis for Office compatible with Office 365?

SAP Analysis for MS Office now provides official support for various versions of Microsoft Office, including Microsoft Office 2013, Microsoft Office 2016, Microsoft Office 2019, and Office 365. This integration allows users to seamlessly connect their SAP data with the familiar interface of MS Office applications.

You might be interested:  Understanding the Distinction: Direct and Indirect Procurement in SAP

With this compatibility, users can leverage the power of SAP Analysis within their preferred version of MS Office. Whether they are using the older but still widely used Microsoft Office 2013 or the latest releases like Microsoft Office 2019 or even the subscription-based service like Office 365, they can easily access and analyze their SAP data without any hassle.

By enabling HANA connection in conjunction with these supported versions, businesses gain greater flexibility in accessing real-time insights from their SAP systems directly through popular tools such as Excel and PowerPoint. This integration empowers decision-makers by providing them with up-to-date information at their fingertips while utilizing familiar interfaces they are comfortable working with.

The connection between SAP and Hana database

To establish a connection, follow these steps:

1. Choose the Cloud option to connect to an SAP HANA Cloud instance.

2. Enter the fully qualified host name or IP address of the remote SAP HANA server.

3. Provide the SQL port number for the remote SAP HANA server. You can locate this information in the list of service details within the SAP HANA Cockpit.

Creating a connection in SAP Analytics Cloud: How can it be done?

To create a new SAP Analytics Cloud connection, follow these steps:

1. Right-click in the Description area and select “Create New SAP Analytics Cloud Connection” from the context menu.

2. The New SAP Analytics Cloud Connection dialog box will appear.

3. Enter a description for the new local SAP Analytics Cloud connection.

4. Enter the logon URL for the new local SAP Analytics Cloud connection.

– Connecting it with HANA requires creating a new SAC connection.