There used to be a time when you needed to be a SAP Basis professional with a lot of knowledge of systems and SAP itself to be able to set-up a working SAP system. With the rising popularity of containerizing applications, it has become common for developers to set up their own personal (local) application […]
Continue ReadingCategory: HANA
Expensive statement in DB02 differs from Planviz (execution trace)
You notice that there’s a difference between DB02 expensive statement trace for the runtime and memory consumption if you compare it with the generated execution (PlanViz file). In our example below we have a query that behaves erradically. At one point it will take a few seconds to return data, at another time it will […]
Continue ReadingAnonymous block in SAP HANA
If I would have received a cent for each time in my career I have seen a select within a select within a select, I would probably be in the same financial situation as I am now. However, if I would receive a cent for every time someone executes a subselect in a subselect in […]
Continue ReadingInstalling HANA studio for BW & HANA
Before going into the details of how-to install HANA studio, let us first have a brief look at the evolution of SAPs interfaces: where it all started, where we are now, and where we are headed. History CLI There are few among us which still remember the revolution when the SAP GUI was first launched […]
Continue Reading