SAP HANA studio

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 »

In this blog, I would like to spread awareness and share my experience of how we can easily start UI5 / Fiori app development locally using VS Code. Step 1: 1. Install Node.js  – Node.js® is a JavaScript runtime built on Chrome’s V8 JavaScript... Read More »

Introduction: I am working for a customer and their business is mainly in the oil and gas industry. As you may be aware of SAP’s solution IS-Oil (Industry Specific – oil & gas) is tailor-made for the oil and gas industry. With the... Read More »