

Hands-On Video Tutorials
What You Will Learn
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 four tutorials take about an hour to watch. What you learn is
- How to connect SAP Analysis for Office to SAP HANA Cloud via the SAP HANA Analytics Adapter (HAA)
- How to install and run a business application generator in SAP Business Application Studio
- How to create a sample HDI Container
- How to set up a stand-alone scenario
- How to provide personalised access
- How to set up an integrated scenario

Playlist
To bookmark or directly access the YouTube playlist, go to
Sample Code
Because we know your time is precious, we have included code snippets so you can easily and merrily code along. For the GitHub repository with sample code, visit
To download the SAP HANA Analytics Adapter (HAA), go to

Hands On
To follow along, you'll need a (free) SAP BTP trial account. If you are new to the SAP SAP Business Technology Platform, consider watching the onboaring series first.
Also required is an SAP HANA Cloud instance. If you are new to this topic, consider watching this tutorial first.
Learn More
For blogs, answers, downloads, and links to the documentation and other resources, visit the community topic area
SAP Analysis for Microsoft Office
Introduction
In this tutorial, we learn about the concepts, how to configures development tooling, and how to create an example HDI Container containing a table, example data, and a calculation view.
https://youtu.be/4ZLWgxewkEU?list=PLkzo92owKnVzSyYh7qrBrDcjIUv_C3r8o
0:00 - Introduction and scenarios
3:15 - SAP BTP Cockpit and prerequisites
3:40 - Create Full Stack Cloud Application dev space for SAP Business Application Studio
4:30 - Copy source code URL from GitHub sales repository
5:00 - Clone from Git
5:45 - Build and deploy MTA project
6:30 - SAP BTP Cockpit and deployment artifacts
6:50 - Bind project to HDI container and open in SAP HANA database explorer
8:30 - Session Info
9:10 - Calculation View editor in SAP Business Application Studio
SAP Analysis for Microsoft Office
Stand-alone
In this tutorial, we learn how set up a standalone scenario where SAP HANA analytics adapter is configured to access an existing HDI container.
https://youtu.be/vs_BuJKEERk?list=PLkzo92owKnVzSyYh7qrBrDcjIUv_C3r8o
0:00 - Introduction
0:45 - Install SAP Partner Engineering extension in SAP Business Application Studio
1:30 - Install SAP HANA Academy yeoman generators
1:45 - Open template wizard and run the SAP HANA Academy HAA generator
3:30 - Project code walkthrough
5:00 - Download SAP HANA Analytics Adapter (HAA) from the SAP Development Tools
5:50 - Copy file to target folder
6:30 - Build and deploy
7:15 - Assign role collection using BTP Cockpit to business user
8:00 - Access App Router
9:30 - Create connection for SAP Analysis for Microsoft Office
10:30 - Log on as business user and select data source
12:30 - Insert Session Info
SAP Analysis for Microsoft Office
Personalised
In this tutorial, we learn how to further configure the standalone scenario to provide personalized access without needing to create a shadow user SAP HANA for each and every business user.
https://youtu.be/uyBQ0TR4hPQ?list=PLkzo92owKnVzSyYh7qrBrDcjIUv_C3r8o
0:00 - Introduction
1:10 - Run command yo saphanaacademy-haa:update
2:15 - Code review
3:15 - Run command cf-env and restage application
4:00 - Access SAP HANA Cockpit
5:00 - Download certificate from SAP BTP subaccount
6:40 - Import certificate
6:55 - Create JWT identity provider
7:40 - Create certificate collection for purpose JWT
8:45 - Refresh sheet in Microsoft Excel
9:30 - Code review
12:45 - Assign role to runtime user
14:30 - Insert Dynamic Calculation View as data source in Microsoft Excel
SAP Analysis for Microsoft Office
Integration
In this tutorial, we learn how to set up an integrated scenario where SAP HANA analytics adapter is configured as a component of the main business application.
https://youtu.be/i0T05vJigEM?list=PLkzo92owKnVzSyYh7qrBrDcjIUv_C3r8o
0:00 - Introduction
1:20 - Open the template wizard for SAP HANA Academy CAP
2:45 - Include and configure HANA Analytics Adapter (HAA)
3:50 - Code review
5:00 - Copy HAA web archive file to target folder
5:30 - Build and deploy project
6:30 - Artifacts review in BTP cockpit
7:40 - Assign role collection to business user
8:20 - Verify app router
9:20 - Verify HAA
10:00 - Access app as data source in SAP Analysis for Microsoft Office
Share and Connect
Questions? Post as comment.
Useful? Give us a like and share on social media. Thanks!
If you would like to receive updates, connect with me on
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.
For your reading pleasure and convenience, here is a curated list of posts which somehow managed to pass the 10k-view mile stone and, as sign of current interest, still tickle the counters each month.
|