Skip to Content

There are so many new features that I do not even know where to start! I have been playing with these for the last weeks and updating tutorials on XS Advanced. But I had to contain my excitement and  wait until everybody else could get their copy.

And with Rudi’s announcement yesterday, it’s sharing time!

There are plenty of very cool features released in SAP HANA, express edition 2.0 SPS03, some are at plain sight and some not. This is my own recollection of the some of them.

If you want a full list of the updates, explained by the mere makers and experts of the product, you cannot miss the free webinars starting on Monday: https://blogs.saphana.com/2018/03/05/sap-hana-expert-webinar-series-march-2018/

This a teasing attempt to convince you that dedicating an hour of your time to those webinars is a great investment:

If the updates or new features had a “wow” effect on me and I had the chance to update the tutorials with them, you will find them in this blog post. It would be no fun if I mentioned them and did not help you try them out. There are some other updates that I think deserve their own chapter and we will get there.

I am using SAP HANA, express edition, from the launcher in Google Cloud Platform to take screenshots of this.

HXE has something to say to you

Even if you do not talk to your HANA instance, she has something to say to you.  From the HANA cockpit (default for HXE is https://hxehost:51042) you can access notifications with interesting updates:

For example:

The XS Advanced cockpit

The old XSA admin tool is gone and this one has taken over. This is not really a new feature but it has some updates itself and is included by default in HANA express now.

Those who have attended my CodeJams on XS Advanced know that we make some tweaks when Web IDE needs more room to run. The part in which we stop services we are not using can be done from here too:

Allergic to the command line?  Stop sneezing for UAA services

Steps are also documented in the first tutorial for the Getting started with XS Advanced development  series. There is a wizard in the cockpit that will create the UAA service for you:

Those user-provided services

Another feature that makes our lives easier in the XSA cockpit (it was there before, though not installed in HXE).

Remember how you needed to create a “user-provided service” for situations like making an HTTP request or accessing a classic schema? Well, you still do.

However, you do not need to go into the console for that and struggle with the double quotes.

If you are looking for more, Denys van Kempen posted a very nice intro and tour of the cockpit here.

Information Access is installed by default

There were some requests for this and they were heard. The main problem was not really installing the plug-in in HXE but getting to it, as you needed a username for the marketplace and a valid license.

You can now go back to using Live connections to your calculation views in XS Advanced from HANA Express out of the box.

The steps to configure InA are still here and valid. You can now jump to the part where you “Configure the tenant database” and continue having fun with Calculation Views.

By the way, there’s also a lot going on in the HANA modelling world, so there goes another reason to check out the update sessions.

The clients for HANA are available from the tools repo

I don’t think this needs any further explanation on why I think it is great to have them so handy https://tools.hana.ondemand.com/#hanatools:

 

VERY easy cross-container access

We all want to tap into the master data created in another MTA (or the data generated automatically by the Data Generator in the SHINE model. It’s as easy as this right-click now:

 

It creates the resource in the mta.yaml file and shows that DB module who’s boss and also who is the default target HDI container.

I think the updated tutorial explaining how to access containers by means of synonyms and grant files shows how much this has been simplified.

Stepping into a procedure or function call during SQL debugging

Rich Heilman lists many other cool new features in his blog, including this one.

https://blogs.sap.com/2018/04/11/sap-hana-2.0-sps-03-new-developer-features-database-development/

No picture here, go to that blog post and see it for yourself if you haven’t already, because it is completely worth it.

So if you have made it this far, I’d really like to know which features are a pleasant surprise to you too. As always, let’s stay in touch in  or on LinkedIn .

To report this post you need to login first.

14 Comments

You must be Logged on to comment or reply to a post.

    1. Lucia Subatin Post author

      Thanks for that 🙂 It did not happen to me (but I tried upgrading in an unconventional HXE), but you might want to watch out for this: https://answers.sap.com/questions/482999/sap-hana-20-sps-03-after-update-error-variable-can.html

      Hopefully I called the attention of the right people and the note gets responded

      (2) 
  1. Ayman Salem

    The mentioning issue only occurs with systems that have “mapped spaces” to the tenant

    one more things about upgrades to watch out for:

    The installation of the new cockpit will fail for the first time (not fully installed).

    Reason the “di-builder” in spaces is not automatically updated to the new version of “di-core”, so after the upgrade you should go to “di-space-enablement-ui” and update it manually (see “Builder Version” and the “DI Core Version” and “outdated”).

    Then re-run the upgrade shell again and it will install properly.

     

    Hope this will help other people by upgrading 🙂

    (1) 
      1. Ayman Salem

        Hi Lucia,

        The issue I was referring to with “systems that have mapped spaces” is “XS_APPLICATIONUSER” described in “https://answers.sap.com/questions/482999/sap-hana-20-sps-03-after-update-error-variable-can.html”.

        The other issue “New cockpit failed” was due to “Di-Builder” not updated automatically during the upgrade (both spaces “SAP” and “Development”). If the reason for this was the mapping (SAP Space) or not, I will try to check that.

        (1) 
  2. Former Member

    Hi

    When installing HANA express, is it best to enter FQDN or just the local host name for the server?  It seems that local host name is the most common way. But I think FQDN is needed to generate the correct certificates. Do you have any guidelines / tips ?

     

    Br Petter Huseby

    (0) 
    1. Lucia Subatin Post author

      Hi Peter, is it giving you an option to change the fqdn or do you want to rename the host at is level? What installation type are you referring  to?

      Changing the name is possible but I have  randomly faced some issues so have not done a post on that.

      (0) 
    2. Mike Howles

      Petter, my experience when doing a binary install is definitely use a FQDN (important that there be 2 dots) or you get intermittent errors at random points of the install.  Maybe it’s improved in SPS03, but even as recently as SPS02, this gave me fits.

      (0) 
  3. Mike Howles

    Lucia,

    Thanks for your post!  I was able to go for the VM Server-Only version and get INA up and running, so I am happy.  However I noticed that it seems that the (old, I know) Web-based Development Workbench is now missing in SPS03.  It was nice to use this instead of the (older) HANA Studio Eclipse plugin.  Is this because the Web-based Development Workbench is now completely deprecated in SPS03 or just to cut down on HANA Express file/memory footprint?  I can resort to HANA Studio and commandline so it’s not the end of the world for me, and XSA is out of scope for memory savings reasons.

    (0) 
    1. Lucia Subatin Post author

      Hey, Mike! The installation files are still there but in a different directory. I would still recommend to stay away form the old web editor workbench. It has some problems and because it’s been deprecated it is not getting any more love.

      HANA studio is then your best option but if you really want to suffer and install it just the same, the installation files should be in /hana/shared/HXE/global/hdb/content  (I’m at the airport now so I’m having trouble loading a console right now, you would be looking for SAP_WATT and HANA_IDE_CORE).

      Cheers,

      Lucia.

      (1) 
      1. Mike Howles

        Ah cool, I see it:

        hxeadm@hxehost:/hana/shared/HXE/global/hdb/content> ls -lart
        total 76128
        -r–r–r– 1 hxeadm sapsys 2260 Mar 28 01:07 HANA_XS_IDE.tgz
        -r–r–r– 1 hxeadm sapsys 1231 Mar 28 01:07 HANA_XS_EDITOR.tgz
        -r–r–r– 1 hxeadm sapsys 17649787 Mar 28 01:07 HANA_IDE_CORE.tgz
        -r–r–r– 1 hxeadm sapsys 23020528 Mar 28 01:07 HDC_IDE_CORE.tgz
        -r–r–r– 1 hxeadm sapsys 33178299 Mar 28 01:07 SAP_WATT.tgz
        -r–r–r– 1 hxeadm sapsys 266 Mar 28 01:07 manifest.txt
        -r–r–r– 1 hxeadm sapsys 4068076 Mar 28 01:07 HANA_TA_VOC.tgz
        -r–r–r– 1 hxeadm sapsys 1983 Mar 28 01:07 HANA_ROLES.tgz
        -r–r–r– 1 hxeadm sapsys 1366 Mar 28 01:07 HANA_DXC.tgz
        drwxr-xr-x 2 hxeadm sapsys 209 Apr 4 10:31 .
        drwxr-x— 19 hxeadm sapsys 4096 Apr 17 06:51 ..

        And duly noted about not using the Web-based Development Workbench but it’s sometimes nice to have 🙂

        (0) 
  4. Jay Malla

    Hi Lucia,

    We just upgraded our CAL HANA Express 2.0 SP 2 to SP 3.  We no longer have Nodejstools running.  I have created a question about this – https://answers.sap.com/questions/607173/xsa-webide-has-no-nodejs-build-option-after-cal-ha.html

    Also when WebIDE starts, we see the error with Unable to Load features:

    https://answers.sap.com/questions/607175/xsa-webide-unable-to-load-features-after-cal-hana.html#

    It’s been a real challenge working on HANA Express 2.0 SP 2 and we had so many issues with the WebIDE and we were hoping upgrading it to SP 3 would resolve them but we are stuck.  If you can provide some help, that would be great.

    Thanks,

    Jay

     

    (0) 

Leave a Reply