Browsing Category

Sap hana

Battling with Privileges

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…

PIVOT Data in HANA

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…

How To: Dynamic Transposition in HANA

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…

HANA Monitoring Handy SQL’s

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…