Skip to Content
Author's profile photo Vivek Singh Bhoj

My Favourite HANA SPS09 Features

Hi Everyone,

I have been using HANA SPS09 for a few days and wanted to share my favourite HANA SPS09 features

My most favourite feature in SPS09 is availablity of XSJS SMTP API

Many new features have been added to XS like Full CORS support, availability of ZIP and REST based APIs and XSDS

But still SMTP API is my favourite and now sending e-mails from HANA is very easy and it has solved many problems.

Configuring SMTP is very easy, you just need to enter SMTP Server name and enter User credentials.

To configure SMTP, go to the below link:

http://<host><port>/sap/hana/xs/admin/#/smtp/  and we will need the role sap.hana.xs.admin.roles::SMTPDestAdministrator to configure SMTP

By default you will see the below screen:


It took me sometime to figure out how to edit this configuration and finally I found the Edit button at bottom right corner of the page.

My second most favourite feature in SPS09 is HANA Cockpit

We can get information about HANA status in a single glance using HANA Cockpitand is really very useful. Administrators will love this tool and whats’ more, most of the tiles in the cockpit are clickable and you can click on them to get detailed information

To see HANA cockpit, go to the below link or open from HANA Studio then R-Click on your System -> Select Configuration and Monitoring -> HANA Cockpit

http://<host><port>/sap/hana/admin/cockpit and we will need the below role to see it



My next favourite feature is availability of Rank function and Time Travel Support in Calculation View and Performance Analysis Debug Editor

In SPS09, many enhancements have been made to HANA Modeling like Redesigned Semantic node, Package level Schema Mapping enhancements to input parameters, restricted columns, currency conversion etc. but Rank function, Time Travel and Performance Analysis Debug Editor are my favourite among all.

When we open Calculation View in new HANA Studio in SPS09, we see that Semantics has been moved to the right side with different tabs as seen from the below screenshot.


One more thing that I like in new design is that Execute In option is clearly visible while it was hidden before.

Next is introduction of Rank Node and now we won’t need to write SQL on top of Views for ranking.


Next thing is Performance Analysis Mode. This was introduced in SPS08 and now it also has another option called Debug this View.


When we click on Debug this View, it automatically generates standard SQL Query and then we can run it in debug mode.


Then the View opens in Read Only Mode and we can also open PlanViz at the same time and check



One more nice thing is that we can now remove and replace nodes


My next favourite feature is getting Graphical Editor for creating repository roles and addition of User Parameters while Creating a user using Graphical Interface

In HANA we create Repository roles as these can be transported to Production Server but we need to write code to create these roles and at many customers, SAP Security is handled by a separate Security team and many of whom are not much familiar with databases. So graphical editor will make their life easy

We need to use HANA Web IDE to create new Graphical based hdbrole and for that open the below URL and we should have role sap.hana.ide.roles::EditorDeveloper



Secondly, if we need to maintain User parameters like E-Mail, Time zone etc, then we needed to write SQL statements up to SPS08, but now we can maintain these parameters graphically


My next favourite feature is Self Services

SPS09 provides web-based user self services for resetting password and requesting new user account.

To configure Self Services, create a Technical user as it is required to execute user self-service requests and assign him the role sap.hana.xs.selfService.user.roles::USSExecutor

For this configuration, we need below roles:




Now go to URL:


In the Application Objects screen, navigate to the package /sap/hana/xs/selfService/user assign the technical user to the selfService.xssqlcc artifact


Now open HANA Studio and change below parameters in xsengine.ini file as per your needs


Then you can open the below URL and check all your pending requests and manage whitelists and blacklists, for this we need role sap.hana.xs.selfService.admin.roles::USSAdministrator



My another favourite feature is new HANA Login Screen

I love the Fiori like feel of it


And if Self Services is enabled, you also get two more options as sown below:


Lastly, one of the most interesting feature I noticed was this:


Note: Now I am able to grant roles to the SYSTEM user using SYSTEM user itself. I will try to check why I was not able to grant roles to SYSTEM user earlier.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Kumar Mayuresh
      Kumar Mayuresh

      Hi Vivek,

      Great blog, thanks for sharing. Looking forward to explore SPS 09 soon.


      Kumar 🙂

      Author's profile photo Krishna Tangudu
      Krishna Tangudu

      Thanks Vivek for sharing 🙂


      Krishna Tangudu

      Author's profile photo Former Member
      Former Member

      Nice post!Vivek Singh Bhoj

      Thanks for shared this new features.



      Author's profile photo Faisal Zia
      Faisal Zia

      Awesome Vivek. I am also looking forward to explore SPS 09 soon.


      Author's profile photo Sunil Baby
      Sunil Baby

      Good document Vivek..! Thanks for sharing 🙂

      Author's profile photo Former Member
      Former Member

      very good !!!!! keep posting

      Author's profile photo Paul Aschmann
      Paul Aschmann

      Thanks for sharing Vivek, nice summary!

      Author's profile photo Former Member
      Former Member

      Thanks Vivek for sharing this ℹ 🙂

      Author's profile photo Former Member
      Former Member

      Thanks for sharing this vivek. Its quite good and educational in understanding SPS09 features of SAP HANA

      Author's profile photo shivam shukla
      shivam shukla

      Thanks Vivek .

      Author's profile photo Sergio Guerrero
      Sergio Guerrero

      thanks Vivek, very helpful