Logging to Analysis for Office with different (no SSO) user

Single Sign On authentication scheme is very popular and useful for users. While user is successfully authorized by OS with the same login ID is allowed to access to other applications. In many organizations, it is deployed also for SAP systems. In one of my previous posts, I described how to avoid SSO for Analysis for Office. However, in case user has no possibility to edit entries to SAP systems in SAP Logon Pad – simply just deactivating the SSO for particular SAP system will not help.

Luckily, there is another option. First following settings of the AfO need to be adjusted. In Options part of Analysis Customizing available menu on MS Excel: File -> Analysis -> Customize Analysis -> Options:

Switch to Advanced tab and choose and enable following two check boxes:

-      Allow Client and language Selection for SSO Logon

-      Force Logon Window for SSO Logon on BIP

Now try to open Insert Data Source -> Select Data Source for Analysis a BW report while selecting menu on Analysis ribbon, and Skip below popup window:

On next pop-up, choose particular BW SAP system, which you want to log on into:

Choose Cancel for next pop-up:

Finally, you are prompted to enter logon criteria for non-SSO user:

More information:

Bypassing SSO in Analysis Office (AO)

Logging to SAP BPC Add-in with different (no SSO) user

Where to download SAP HANA Studio?

Most of SAP HANA development artefacts including SAP HANA administration is being done in a tool called SAP HANA Studio. The tool is based on Eclipse foundation. The easiest way to get the tool is just to download the latest Eclipse IDE (at the time of writing it is version 2021-09). Afterwards an SAP specific plug-ins needs to be installed via menu Help->Install Software) from:

https://tools.hana.ondemand.com/#abap for ABAP Development Tools

https://tools.hana.ondemand.com/#bw for BW Modelling Tools

https://tools.hana.ondemand.com/#cloud for Cloud development like SAP BTP

https://tools.hana.ondemand.com/#cloudintegration for Cloud Integration

https://tools.hana.ondemand.com/#hanatools for HANA related development

etc..

or simply: https://tools.hana.ondemand.com/latest

However, SAP offers all this and much more included in one distribution of SAP HANA Studio. At the time of writing, there is a version 2.3.32.000000 available via Note 2902153. Physically the installation media is distributed via SAP Support Portal its Download section. Here you need to navigate to SUPPORT PACKAGES & PATCHES -> By Alphabetical Index (A-Z) -> select S -> e.g. SAP HANA STUDIO 2 (SUPPORT PACKAGES AND PATCHES)

The installation file can be either downloaded directly or via SAP Download Manager. The file itself is quite heavy, approximately 1.2GB. It comes as SAR file and it needs to be unpacked by SAPCAR tool.

There are following main 3 parts that can be installed:

SAP HANA Studio Administration

SAP HANA Studio Application

SAP HANA Studio Database Development

After the installation, the software occupies approximately 1.2GB (1.5GM with all the SAP plug-ins) on hard drive. For ABAP BW, BPT and cloud development SAP plugins need to be installed from https://tools.hana.ondemand.com/latest again via menu Help->Install Software.

In case you run into issues like below while installing the SAP plugins into the Studio:

An error occurred while uninstalling session context was:(profile=hdbstudio, phase=org.eclipse.equinox.internal.p2.engine.phases.Uninstall, operand=[R]com.sap.ide.support.feature_root.win32.win32.x86_64 1.15.0 --> null, action=org.eclipse.equinox.internal.p2.touchpoint.natives.actions.CleanupzipAction). Backup of file C:\Program Files\SAP\hdbstudio\collectSupportInformation.bat failed. hdbstudio\collectSupportInformation.bat

Then it is most likely that you need to run your Studio as administrator and repeat installation of the SAP plug-ins.

In most cases just to download the IDE from eclipse and install the plugin is efficient. However if you prefer to have the full blown SAP HANA Studio you can get it as described in this blog post.