How to – Import SFLIGHT sample data into HANA from a local computer

As you discovered few seconds ago, HANA doesn’t come with any preloaded sample data.

So, before starting to play with your brand new system, you need to find and load some data.

Luckily SAP provides for free its flight data model (you can download it here unluckillly the previous link doesn’t work anymore; I will try to fix this issue asap) – it’s a good starting point since it contains a sufficient amount of data and a limited number of tables.

Upgrade your HANA, express edition

In my previous blog Secure your HANA, express edition I described how to register your HANA, express edition system with SUSE to receive critical security updates.

In this blog I will leverage this work to describe how to upgrade your HANA, express edition to the latest patch level. However, please be aware, that

1. This increases the memory required from 7 GB to 9 GB for the Server only option.
2. Also, temporarily, 24 GB of available RAM are needed for the upgrade.

To start with, I update the preinstalled VMware Tools to mount shared folders with the upgrade software packages.

Secure your HANA, express edition

As soon as I heard of the HANA, express edition I got it installed on my laptop. The Server only option requires 7 GB of available RAM, the Server + applications 12 GB.

Importing the images into VMware Player 7.1.4 went like a charm. However, the underlying SUSE Linux Enterprise Server for SAP Applications has received security updates since the HANA, express edition images had been build.

Therefore, the first step for me after logging into the hxehost system and changing the hxeadm password was to start the SLES setup tool YaST to add a SUSE subscription to the installation:

How to found Dependent Objects in SAP HANA

This is a Blog to help you out in finding SAP Dependent object / Catalog object form HANA System. Once we used to do some change in Information model, before doing so, we should have analyzed the dependent object list.

This will help you to understand the foot print of your model and other affecting areas. Moreover it is required before modifying Modeling object or information model. To know, which all are affected object of this change.

If you required the list of tables for a particular SCHEMA or the list of Field of a particular table, this this is one and only easiest way. Even if you would like to know, which Tables are using same field, this can be a simple way.

Upload and Retrieve Image using SAP HANA XS & SAP UI5

One of the most common use case in building XS based Native HANA Application is working with file uploads like image, csv etc.,
In this blog I will explain how to:

1. Use SAPUI5 File Uploader to upload an image
2. Render preview of the uploaded image
3. Save it to HANA DB using a XSJS service.
4. Retrieve the saved image using XSJS service and render it on the UI.

Please note this approach can be applied for any type of file. e.g .csv, xlsx etc.,
Upload an Image using SAPUI5 File Uploader:

SAP HANA Developer Edition 1.00 SPS11

After several months we finally have the SPS11 SAP HANA Developer Edition live with the brand new SAP HANA XSA configured and running, unfortunately being early meant we had a few problems along the way so hopefully you'll all be happy with the results - we are that is for sure!

DB Refresh of HANA Based systems using HANA Studio Backup/Recovery without SWPM

DB Refresh using HANA Studio DB Restore  with SID Modification -  NON SAPinst

HANA Studios DB restore option and hdbuserstore there after makes the whole process of a  System copy a lot simpler . The only limitation would be that the target schema would still remain as source.

The idea of this blog is to explain the process of performing  a simple homogeneous system copy of a HANA based system using the recovery of the source backup on the target HANA DB using HANA Studio.

In this case ,we will be  considering a situation of copying a Prod backup and refreshing it in a already running quality system

HANA Studio on High resolution displays

If you try to work with SAP HANA Studio on HiDPI (High resolution display), like Apple retina or Microsoft Surface, you will see that there is a problem with the size of the icons:

In Surface 4 at 2736x1824, icons are tiny, unusable, as you can see in the screenshot (compare it with the size of the fonts):

SAP HANA Extended Application Services

We introduce an exciting new capability called SAP HANA Extended Application Services (sometimes referred to unofficially as XS or XS Engine). The core concept of SAP HANA Extended Application Services is to embed a full featured application server, web server, and development environment within the SAP HANA appliance itself. However this isn't just another piece of software installed on the same hardware as SAP HANA; instead SAP has decided to truly integrate this new application services functionality directly into the deepest parts of the SAP HANA database itself, giving it an opportunity for performance and access to SAP HANA differentiating features that no other application server has.

Demystifying SAP HANA Administration

Since its release, SAP HANA represented a radical change in the direction of SAP's product architecture. As an SAP Instructor, I’ve been wondering how easy it would be to manage the new SAP HANA platform. Can I use platform and administration tools that are currently in place? Or, do I need to learn a new set of gadgets?

After reading through some of the documentation available in SAP Learning Hub, and reviewing SAP courses such as SAP HANA Introduction (HA100), SAP HANA - Operations & Administration (HA200), and SAP HANA Implementation and Modeling (HA300), I realized that the learning curve is quite easy – if you get some guidance up-front. That’s why I’m here! This blog will demystify SAP HANA administration by listing tools you can use to handle periodic administrative tasks, and by explaining the key capabilities of each and when to use them.

DB Refresh of HANA Based systems using HANA Studio Backup/Recovery without SWPM

DB Refresh using HANA Studio DB Restore  with SID Modification -  NON SAPinst

HANA Studios DB restore option and hdbuserstore there after makes the whole process of a  System copy a lot simpler . The only limitation would be that the target schema would still remain as source.

The idea of this blog is to explain the process of performing  a simple homogeneous system copy of a HANA based system using the recovery of the source backup on the target HANA DB using HANA Studio.

In this case ,we will be  considering a situation of copying a Prod backup and refreshing it in a already running quality system

These are the salient steps involved in achieving this

Step 1 ) Take a complete DB backup of the source Database
Step 2) Move the database backup to the Target system
Step 3) Using HANA Studio recover the source db in the target HANA box
Step 4) Supply the license text so that the HANA Studio can automatically apply the license after install
Step 5) Modification of Schema access at the target DB
Step 6) Modify the default key  using the hdbuserstore on the application servers  and DB instance.
Step 7 ) Start sap
Step 8 ) Post activities.

SAP HANA: Achieving Set operations using Joins

Now we can have multiple discussions. As we know that achieving with UNION is better than JOINS. But again it depends on the volumes of the data and the place at which you are applying it.

As per our experiences, we also know that if we can achieve with the help of Attribute /Analytic Views it is better than doing the same with Calculation View Graphical / SQL. In this document i have tried to achieve with Attribute views as much as possible and while doing this i came to know about the Full Outer Join option through graphical models is not possible anymore.

These are 7 questions on which Jody has discussed,

Here are our Tables:

Table 1:

Table 2: