SAP HANA studio

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 »

SAP HANA System Replication is a reliable high availability and disaster recovery solution that provides continuous synchronization of a HANA database to a secondary location either in the same data center or remote site as a disaster recovery... Read More »

Requirement Sometime we gets requirement to Round Up\Down any Fraction number to the nearest integer number in HANA View or HANA Sql. Expected Round Up Result Input Fraction Number  Expected Result 1.1 2 1.298 2 1.8978 2 Expected Round... Read More »

Hello folks, I am Vasu Sharma, SAP ABAP on HANA expert, have provided SAP solutions in various domains like manufacturing, aerospace industry, banking, finance and insurance. With the help of this blog, you will be able to set null values in Core... Read More »

Over years I posted quite many Geospatial Tuesday posts — short examples of what you can do with SAP HANA Spatial SQL. Some of those examples were based on the public free geospatial data available in Esri Shapefile format that you would... Read More »

Requirement This blog is intended to show how we can fill the dates if dates are saved in two columns as StartDate or EndDate ( Refer Sample Data of Date Rang Table Screenshot). We have one Transaction table which is having data for each day... Read More »