Sap hana

Background: I had to upgrade the HANA One (Developer Edition) in AWS from Rev 48 to Rev 56 as part of the openSAP Introduction to Software Development on SAP HANA class. Rev 48 client setup: My Win7,…

As the Beasty Boys once pointed out “You gotta fight for your right (to party)”. Well if you want to party with HANA views and tables it helps to know how to handle privileges. Problem 1: Data Preview Error after successful…

This example is referenced in my other post about the usage of the join cardinality settings in SAP HANA Calculation Views. Please have a look at the other post to get a better understanding of the context for this example. The…

First of all, I think that IT is still a dynamic environment. I know that if you go to SAP TechEd, or DSAG (here in Germany) or any other IT fair, you can see the slowly increasing average age. Not so many young talented engineers are…

In my previous blog I have covered how to UNPIVOT data in HANA, in this blog I am covering how to PIVOT data in HANA. While converting MS-SQL procedures into HANA procedures, we came across PIVOT statement in one of the select…

High CPU Utilisation Whilst using HANA i.e. running reports, executing queries, etc. you can see an alert in HANA Studio that the system has consumed CPU resources and the system has reached full utilisation or hangs. Before…

Transposition Use Case There are cases in which “horizontal” data in HANA needs to be transposed into a “vertical” format. Reasons for this transformation include: 1) Data may need to be combined from multiple fact tables…

Introduction The best security procedures are clear and straight forward.  In this video by the SAP HANA Academy Denys justifies the role of SAP_INTERNAL_HANA_SUPPORT in SPS09.  This topic could be complex but Denys tells you…

HANA is really a great product but from an operations point of view it’s not that handy yet compared to other SAP Solutions. As an HANA Admin you have to run SQL statements, console commands and other manual actions to operate the…

Monitoring Memory Usage Used Memory The total amount of memory in use by SAP HANA is referred to as its Used Memory. This is the most precise indicator of the amount of memory that the SAP HANA database uses at any time When…