Skip to Content
Author's profile photo Daniel Wroblewski

What’s New in SAP HANA SPS05

OK, RTC was several weeks ago … OK, it’s almost a month ago, and perhaps you’ve heard of what’s new in the last SAP HANA release. But back in the days when I was writing about the SAP NetWeaver Portal, my What’s New blogs were the most well received, so I’m going to plow ahead and today start writing blogs for each new release. And, besides, a few more features were released in a revision about a week ago, so I’ll use that as an excuse to write about SPS05.

To review, SAP HANA revision 45 (the first SPS05 version) was released on Nov. 29, and revision 47 was released on Dec. 21. In this blog, I will summarize the new features, and in future blogs I’ll look more closely at a few of the larger features.

  • SAP HANA XS: This is THE big change in SPS05. Essentially, there’s now an application server built into SAP HANA that let’s you expose your data in one of the following ways:
    • OData: You write descriptors that specify how to expose your data via standard OData services.
    • XMLA: You write descriptors, but now for exposing data via XMLA services, which enable multidimensional queries.
    • Server-Side JavaScript: Here, you have greater control over how to expose your data, by being able to write control logic and accept any parameters that you define.

In addition, you can deploy Web pages, especially using the SAPUI5 library, using the SAP HANA XS web server.

There is a GREAT blog by Thomas Jung, explaining very clearly and simply how to write OData and server-side JavaScript.

  • The Repository: SAP HANA XS is the big new feature, but really, the repository should have been the first item, since it enables development of all types of objects, not just those related to the SAP HANA XS web access features. The repository is essentially the source control for your development projects, and it is built into SAP HANA. It enables a methodical approach to building design-time objects, as follows:
    • You connect to a SAP HANA system (in the Navigator view).
    • You create a view into that system’s repository (in the SAP HANA Repositories view).
    • You create a project for all your design-time objects, and connect that to one of the repositories (in the Project Explorer view).

To quickly learn how to set up a development environment and use the repository, see Tutorial: My First SAP HANA Application in the SAP HANA Developer Guide.


Thomas also discusses the repository in his blog.

  • SQLScript Editor/Debugger: The studio now includes a new editor and debugger for creating SQLScript procedures, with the following advantages.
    • You can now debug your procedures, adding breakpoints and watching variables/parameters. What’s really nice is if you have a table type as a parameter, you can watch it and then open up the current contents with the standard Open Data Preview window. 
    • Syntax highlighting
    • Code completion
    • Supports the now standard way of developing within SAP HANA.

Rich Heilman has written two nice blogs, one on the editor and one on the debugger, which describes how to view contents of table types.

  • SAPUI5: SAP HANA includes the SAPUI5 SDK, also known as the Demo Kit, a client-side rendering library for building desktop and mobile applications. So you can create HTML pages with the help of the library and deploy them in the SAP HANA web server. The SAP HANA studio also includes some tools for creating SAPUI5 pages.

Since the SDK is deployed in SAP HANA, you can view the basic SAPUI5 documentation by going to: http://<server>:<XS port>/sap/ui5/1/sdk/index.html. [If your SAP HANA uses https, use that protocol instead. The XS port is 80 + the instance number. Replace <server> with your server name.]


Documentation for using SAPUI5 within SAP HANA is available in the developer guide.

  • SAP HANA UI Integration Services: You can quickly create an “application site” within SAP HANA, and insert application UIs that you’ve built and deployed in SAP HANA (for example, with SAPUI5 tools) or that were deployed elsewhere. Each application that you want to add to your site you wrap as a “widget”, and then you can add it.

You can create pages in your site, rearrange the widgets, and let the different widgets communicate with each other via the client-side Site Context API.

  • Modeling View: I won’t say much about it here, but the editor for modeling views has been revamped (for example, the editor for attribute and analytic views have been combined).
  • Decision Tables: This is a way to set data values based on rules. The classic case is to set the discount field, based on rules about the type of product, quantity and other factors. Decision tables are for non-technical users, meaning users who do not want to write complex SQLScript procedures to do this, or who already have an Excel with the rules.

Essentially, you use modeling tools to create a view, and then use a table to enter values, where each value is selected if a set of conditions are met. For example, with the SFLIGHT database, if the flight is from Lufthansa during March, then you can set the discount to 10 percent. Once activated, the decision table is converted into a procedure, which can be run to return or update tables based on the values returned in the decision table.



  • SQL – Random Function: Thought this would come in hand. SAP HANA SQL now includes the RAND function that generates a pseudo-random value from 0 to 1.0. For more info about RAND and other changes to SQL in SAP HANA, see the SQL Reference.
  • Documentation: The documentation has been revamped to be friendlier, easier to understand, with examples and tutorials. The documentation consists of the developer guide, plus a set of references. The guide tries to take you through the development process, in logical order:
    • What is SAP HANA database? [Chapter 3]
    • How do you develop on top of SAP HANA? This includes overview of the repository and the SAP HANA studio IDE. [Chapter 4]
    • How do I create a project? [Chapter 5]
    • How do I create the data model? [Chapter 6]
    • How do I create analytic views? [Chapter 7]
    • How do I create complex SQLScript procedures?  [Chapter 8]
    • How do I expose my data via Web interfaces (JavaScript, OData, XMLA)?  [Chapters 9 and 10]
    • How do I create a UI on top of these interfaces? [Chapter 11]

I will write about a few of these in more details in the coming weeks. Please comment and tell me what else you would like to know about.

There were also changes to the fuzzy search, full-text search, SQL and SQLScript syntax, and Modeler tools. For more on these, see the Development section of the What’s New document.

Assigned Tags

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

      Hi Daniel

        Thanks for the good overview on new  features of SPS05 from modeling perspective.


      Santosh Varada

      Author's profile photo Lars Breddemann
      Lars Breddemann

      Hey Daniel,

      thanks for writing this up!

      RAND() function: it finally got into the official documentation. GREAT 🙂 !

      What's also cool is that now we have a version information on the bottom of each page indicating the exact revision this documentation belongs to:

      "SAP HANA Appliance Software SPS 05, Revision 47"

      I wanted to have this for so long and now it's finally in there. Just awesome!

      Cheers, Lars

      Author's profile photo Andy Silvey
      Andy Silvey

      Hi Daniel,

      excellent blog, thank you.

      All the best for 2013,


      Author's profile photo Kumar Mayuresh
      Kumar Mayuresh

      Hi Daniel,

      Can you provide the link for downloading HANA studio Revision 45/47 ?



      Author's profile photo Daniel Wroblewski
      Daniel Wroblewski
      Blog Post Author

      You can download the studio from the SAP HANA Developer Center, but I see this is a previous revision. I will try to find out how you can get the latest versions.

      Author's profile photo Daniel Wroblewski
      Daniel Wroblewski
      Blog Post Author

      There was an announcement on Friday about upgrading the trial versions --

      Author's profile photo Kumar Mayuresh
      Kumar Mayuresh

      Hi Daniel,

      As you have mentioned - SAPUI5 SDK is deployed in SAP HANA, you can view the basic SAPUI5 documentation by going to: http://<server>:<XS port>/sap/ui5/1/sdk/index.html.

      Considering the same format when I am trying to open SAPUI5 SDK Demo Kit I am getting the following error  - 

      "This link seems to be broken

      We could not find the resource you're trying to access.
      It might be misspelled or currently unavailable. ?
      Possible solution

      Please check the URL or try again later.
      In case of ongoing problems please contact your system administrator"

      Can you please guide me for the same.



      Author's profile photo Daniel Wroblewski
      Daniel Wroblewski
      Blog Post Author

      Are you sure you are on revision 45 or above? If you want you can send me in direct message the exact URL you are using and I will double check.

      Author's profile photo Kumar Mayuresh
      Kumar Mayuresh

      Hi Daniel Wroblewski

      Thanks for your response.

      Can you please follow me back on Twitter or on SCN so that I can send you the direct message. 🙂



      Author's profile photo Former Member
      Former Member


      I am a new learner of SAP HANA,

      i wanna know exact use of sap hana,

      thank you,

      Author's profile photo Former Member
      Former Member

      We are on the test XMLA interface. The connection u. Discover many features to work.

      Unfortunately, SAP Hana incorrect XML requests supplies. All timestamps (datetime) are not formatted correctly. Since the "T" between Date and Time is missing. Here an example from Discover MDSCHEMA_CUBES:

      Is: ... <LAST_DATA_UPDATE> 2014-09-05 14:03:49.8910000 </ LAST_DATA_UPDATE> ...
      Should be: ... <LAST_DATA_UPDATE> 2014-09-05
      T14:03:49.8910000 </ LAST_DATA_UPDATE> ...

      Is it possible to configure the formatting or is this a bug in SAP Hana?