BW SAP HANA Modeling Tools (Eclipse)

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 »

Summary This Document explains about handling ADSO  Inbound Table deletion in SAP BW Author       : Bala.G.Reddy Company   : Cognizant Technology solutions. Created on: 8TH Dec 2014. Author Bio I am Bala.G.Reddy working as Technology... Read More »

last changed: 15th September 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... 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 »

Hello Everyone, currently I suffered the issue that at a customers sandbox system that the Eclipse debugger did not stop at break point when: Running console output via F9  classes classic reports Unit Test In classic runs via F8 during... Read More »

Hello There! This blog post is an extension of one of my previous blog posts regarding replication of the methods in p_r_request into AMDP TRFNs in BW/4HANA 2.0 context. As already stated in the earlier blog post,  a set of predefined parameters is... 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 »

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 »