BW SAP HANA Modeling Tools (Eclipse)

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 »

Greetings ! As promised in my earlier blog post, in this article I will be explaining the possibilities of using the view for external access or the external SAP HANA SQL view for aDSOs or the generated ‘8’ view of aDSOs. The main idea... Read More »

Hello there! Context In this blog post, I would focus on some of the key aspects of the generated view for external access  or the external SAP HANA SQL View for aDSOs in BW/4HANA 2.0 by a use case scenario. The view is generated with naming... Read More »

Context This blog post has a post reference to my previous blog post, where I had explained a scenario which involved aloading scenario where data target was an aDSO having several source aDSOs with similar structure. In the runtime we read the... Read More »

Basic rule of thumb on any system development of a 2 tier architecture, is that complex formula or logic be push down to the Database rather than the application layer. As Databases are designed to handle more complex formulas. In the SAP... Read More »

Hello, For many of us existing BW consumers, while moving to BW/4HANA platform it’s quite common a scene these days that we change the existing BW transformation routines from ABAP to AMDP to leverage the HANA performance in better possible... Read More »

Introduction: In this blog, I am going to explain how we achieved calculating the number of days in a month, without using the date field in the HANA Calculation view, by using a simple formula. This was a requirement from one of our customers and... Read More »

This Blog would give us most of the information about calendar attributes or date attributes through ABAP CDS. I am involved in Group Reporting implementation where we have to deal with lot of date attributes. Little background on Group reporting,... Read More »

Stored Procedure – Introduction Stored Procedure are frequently used Objects in SAP HANA. Stored Procedures allows to group the SQL statement into a single block and can return data in the form of output parameters. In Mixed modelling... Read More »