SAP HANA studio

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 »

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: 12th of April 2023 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 »

Hello everyone, REQUIREMENT To access previous row value in a table. When we have null value in the current row then we have to look backward for the previous rows till we find a value . In this blog post we will discuss how to get previous row... Read More »

Hello everyone, REQUIREMENT To access next row values in a table. When we have null value in the current row then we have to look forward for the upcoming rows till we find a value . In this blog post we will discuss how to get next row value in a... Read More »

Requirement – This blog explains how we can Implement Error Handling in HANA Sql to maintain data reliability, durability & consistency during execution of multiple DML statements in a single code block. Implementation Scenario –... Read More »

As a fellow HANA Model developer the concept of  partitioning in HANA modelling really intrigued me, however in many of the blogs I found it to be very informative but I wanted to see something more like from the modelling stand point how its helps... Read More »

Business Example: There is a requirement from a client where the client wants to calculate the distances between their customers and their stores. Typically, locations or addresses in a database are stored in text fields, making it difficult to... Read More »