In today’s world where data is crucial, it’s really important to have analytics solutions that fit our business needs perfectly. With SAP Analytics Cloud (SAC), we can create custom analytical applications that are just right for our needs. One cool thing we can do with SAC is develop custom widgets. These widgets help us add […]
SAP HANA Studio
SAP HANA DB Authorization concept
SAP HANA SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. SAP HANA Security Sap Hana Security is protecting important data from unauthorized access and ensures that the standards and compliance meet as per the security standard. User Type in SAP HANA Depending on the different security policy […]
Handling Long Text – Migration Perspective
Long texts are a powerful asset in data management, providing detailed information beyond standard text descriptions. They allow businesses to capture essential details like ingredient descriptions, vendor remarks, and item details. However, long texts cannot be uploaded using data objects in the SAP Data Migration Cockpit (Migrate your Data Fiori App in S/4 HANA 2020). […]
SAP HANA SLT – Performance Tuning on customer developed ABAP program
Introduction In this post, I would like to share one of my project experience on performance tuning for Customer developed ABAP program from 38% improvement to 260%+ improvement after implemented SAP HANA SLT side car. I will share some of the techniques for using sap transactions (SCI, SE30, etc) to analyze the performance bottleneck for […]
Excel File Upload From SAP Analytics Cloud Analytic Application
There was a requirement to upload an Excel file directly from the SAC Analytic Application. I would like to share here how I did it. We will create a custom widget in SAC with library from SheetJS with a little modification. We will also create table, view and stored procedure in HANA. I am using […]
Using SAP BW characteristic attributes in SAP PaPM
SAP Profitability and Performance Management (PaPM) is a flexible solution due to its independency of any data models. PaPM can be integrated with the help of information functions such as Model Table, Model View, Model BW to various data sources such as SAP HANA Tables, Data Dictionary Tables, SAP BW aDSOs and so on. Since […]
End to end XS Application development in hana studio
In this blog we are going to implement an end to end sap hana xs application by using hana studio. Introduction Hana Studio is the best development environment to implement end to end application development i.e. Front-end(UI) + Back-end(Server-side Logic + Database stuffs). In this blog we are going to create two employee details custom […]
Looking forward for the next available value in a table without using LEAD or LAG function or LOOPING in SAP HANA
REQUIREMENT This blog is regarding the calculation of “Production Ratio” in Supply Chain Management for the monthly bucket in SAP HANA. The client wanted to see, Production Ratio of a year for each month for a particular Product, Location and Product Version combination. In my case Production Ration was calculated as (Quantity / Total Quantity […]
Sum of Multiple Rows based on a condition (validation) without using LOOP in SAP HANA
REQUIREMENT This blog post is regarding the validation of “Production Ratio” in Supply Chain Management for the monthly bucket in SAP HANA. Read More: SAP HANATEC 12 Certification Preparation Guide The client wanted to see “Production Ratio” of each month for a particular Product, Location and Product Version combination with validation. In my case, when […]