SAP Analysis for Microsoft Office and SAP HANA Cloud | Hands-on Video Tutorials

[dvankempen]

With this blog series we provide an update with the latest information on getting started with SAP HANA Cloud on the SAP Cloud Platform.

1. About SAP HANA Cloud


2. SAP HANA Cloud Getting Started


3. SAP HANA Cloud and SAP Business Application Studio


4. HDI with SAP HANA Cloud <=


5. SAP Analysis for Microsoft Office and SAP HANA Cloud <=


6. Cloud Foundry Advanced (space travel, multiple instances, defining schema names)


7. SAP HANA Cloud, JWT Provider, and Certificate Collection with Purpose JWT


8. Data masking and data anonymization


9. Predictive Analysis Library (PAL) and Automated Predictive Library (APL)


10. Remote data sources and virtual tables


11. OData with SAP HANA Cloud


12. SAP HANA Cloud Graph


13. Role Attributes


14. SAP HANA Cloud and Smart Data Integration

For more information about the free trial, see

• SAP HANA Cloud Free Trial

For the new features overview posts, see

• What’s New – SAP HANA Cloud April 2021

Questions? Post as comment.

Useful? Give us a like and share on social media.

Thanks!

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

• SAP Analysis for Microsoft Office


• SAP HANA Cloud

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

• github.com/saphanaacademy/sales

To download the SAP HANA Analytics Adapter (HAA), go to

• SAP Development Tools > HANA

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.

• SAP Cloud Platform Developer Onboarding | Hands-on Video Tutorials

Also required is an SAP HANA Cloud instance. If you are new to this topic, consider watching this tutorial first.

• SAP HANA Cloud and SAP Business Application Studio

Learn More

For blogs, answers, downloads, and links to the documentation and other resources, visit the community topic area

• SAP Analysis for Microsoft Office

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

• LinkedIn > linkedin.com/in/dvankempen


• Twitter > @dvankempen

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.

• Good Reads (my two cents)

[David_B]

Hi,

Thank you very much this tutorial is very interesting.

I have question.

On the first tutorial, the path for db deployer is path: db

On the last one, the path for db deployer is path: gen/db

The path gen/db seems to generate troubleshooting.

• During developement, the view in the directory db are not checked anymore.


• We have to Bind the database connections in the "SAP HANA PROJECT" each time we generate the CDS.


• As the files in the "SAP HANA PROJECT" are based on the files in the directory gen/db the icon filter does not work any more as each time we regenerate all the files.

May me there is a config point I am missing ? or could we use the path : db

Regards,
David Bizien

[David_B]

I Think I have found the solution.

1. set the path: db for the db deployer


2. add a package json in the db directory, the kind you have provided in the first video : https://github.com/saphanaacademy/sales/blob/master/db/package.json

May it could be great to enhance the HANACADEMY wizard for cap project.

Regards,
David Bizien

[saurabh301]

Hi Denys,

Thanks for sharing the information.

I was trying to implement the standalone scenario. But have been getting error while building the yaml of haa. It says "mvn" executable file not found in $PATH.

I have even uploaded the 'java-xsahaa.war' in target folder under srv.

Any suggestions how can I resolve this? I have also attached the screen grab of the error.

Best Regards,

Saurabh

[dvankempen]

mvn = maven, compiles Java.

Maybe try taking a look at this tutorial to see how this might work

• https://developers.sap.com/tutorials/cp-cap-java-app-studio.html

Could be a different project template needs to be selected.

[paulgabog]

Had the same issue, i just switched to using Full Stack Cloud Application Workspace with SAP Hana add ons rather than SAP HANA Native Application then it worked.

[RonaldKonijnenb]

Hi,

 

The AFO client is not able to handle universal IDs (message browser not supported). Any thoughts?

[mfoeken]

Hi denys.kempen,

Like 1c996cacb1274a94b1b6e84abd9dfac3 mentioned this is displayed when trying to login:

Any idea what needs to be done?

Kind regards,

Martijn van Foeken | Interdobs

[dvankempen]

Hi Martijn,

Suggest to create a ticket with SAP Support.

Will try to contact a few colleagues as well from my side.

[dvankempen]

Hi Ronald,

No thoughts. Suggest to create a ticket with SAP Support.

Will try to contact a few colleagues as well from my side.

[RonaldKonijnenb]

Thank, ticket has been raised two weeks ago. Does not really move.

[dvankempen]

Thanks, Ronald,

Twitter informed me foekenm found an article related to the topic

https://twitter.com/mfoeken/status/1600066591835574272?s=20&t=Yx9HUluPJOrBUGcTrttMvw

>> https://launchpad.support.sap.com/#/notes/2928422

Will update when I get a response from product management.

 

 

[carlospinto]

Hi saurabh301,

I got the same error and fixed it by enhancing my space (HANA Native Application) with Java Tools.



Thanks a lot for this blog series denys.kempen

Kind regards,

Carlos

[uksimpcamera]

Hi,

I am not able to watch any videos mentioned in above blog. Could you please share the correct link or make the videos Public. I am specially looking for Analysis for Office Integration to HANA Cloud. I am using Trial version to explore so please also suggest how can I get a Trial version for Analysis for Office.

Thanks in Advance.

Kumar