SAP HANA studio

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 that, 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 Output 11:03:00 PM 23:03:00 PM 11:03:00... 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 »

Time flies, when you’re on a mission — a mission to enter the next decade of customer success with SAP HANA! After having released SAP HANA 2.0 SPS 05 in 2020 with a 5-year maintenance window as well as achieving incredible customer adoption,... Read More »

last changed: 18th of May 2022 SapMachine is an OpenJDK released maintained and supported by SAP. You can replace the in-build JAVA Support from the SAP HANA Studio with SapMachine. You can use this to replace any existing JAVA (owned by Oracle)... Read More »

This blog post content is to explain budding SAP HANA and MDG Developers and consultants help them to understand on some SAP HANA Search Annotations of Fuzzy Search that is also used in Matching feature of MDG Consolidation. The budding consultants... Read More »