SAP HANA studio

Requirement – Sometime we have to divide two numbers in Hana Sql or in Hana views. If denominator comes as 0 there is no logic implemented handle 0 in denominator then Hana will throw Divide by 0 error during Query execution. Also this is good... Read More »

Knock knock! Anyone else also looking for handy illustrations of the hierarchy functions introduced with HANA 2.0? Well count me in then ;). While trying hard not to write SQLs with recursive self joins to flatten a hierarchical data format... Read More »

CONTEXT To effectively monitor reporting solutions and underlying HANA view objects used in your IT project, SAP Analytics Cloud can help you to highlight information such as broken views, broken procedures, attributes details, dimensions details,... Read More »

In this blog, you will learn how to troubleshoot HANA DB authorizations / privileges errors using SQL Script procedure GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS OVERVIEW SAP introduced a procedure GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS with HANA... Read More »

It was almost a year since my last Geospatial Tuesday post. That time it was how-to Import zipped shapefiles into SAP HANA Cloud using Database Explorer. But I still used an external tool called DBeaver to visualize data imported into SAP HANA... Read More »

In HANA XS classic, to get access on all analytical privileges(classic AP) in the system _SYS_BI_CP_ALL can be granted to an user(directly or via a role), generally for developers/ HANA Admin. But in HANA cloud or XS advanced using HDI container... Read More »

Task Try the SAP HANA Modeling functions and possibilities with the SFLIGHT demo database. Reason of the Article To illustrate the process by a concrete example based on the SFLIGHT database. During the process there are many additional steps and... Read More »

Requirement – Many times working in Hana Modelling we have to use Stored Procedures to perform multiple DML operation on a single or multiple tables. One scenario is that in stored procedures we need to perform multiple DML operation... Read More »

Requirement The requirement is to convert 12 hour format time into 24 hour format. We are saving Time in a column in 12 Hour format but in the output we need to show the time in 24 Hour format. Example below – Source Time Format Expected... Read More »

Consider a scenario where you do not have data in the underlying table. Could be a customizing or application table or any other table. You need to test, build your SQL query logic. Since there is no data in the underlying table what do you do? Try... Read More »