1. Introduction SAP HANA Views do not support binary/bitwise operations in calculated attributes and measures. In HANA SQL Procedures one can use BIT* functions (not available in HANA Views) instead of binary/bitwise operators to manipulate bits of an integer variable as it is possible in Java, C, C++ or other languages with e.g., & or […]
In this blog I will show how to build machine learning models in Rstudio and run the training directly in SAP HANA. The main benefit with this approach is that it allows you to utilize the power of SAP HANA both in terms of scalability and performance through R scripts. In a nutshell, there is […]
Introduction The COPA, the forecast and many other S4HANA, ECC and legacy tables contain hundreds of measures in their record structures. This format is not suitable for efficient processing in BI front end tools; e.g., WebI reports. The WebI P&L reports are performing the best when dealing with only one or few measures at most […]
This article describes new features in the SAP HANA Plan Visualizer (PlanViz) in SQL Trace (transaction ST05). These new features are available from the following SAP_BASIS Releases / Support Packages: 7.52 SP3 (and higher) 7.53 SP1 (and higher) 7.54 All SPs Background Figure 1: Link to Execution Plan tool from ST05 trace display The Execution […]
Manufacturing Cycle (MTS / MTO) using Fiori After the Release of HANA from 1509 the Usage of Fiori Application is becoming mandatory day by day and with every New Release of HANA it’s becoming more and more So many of Us are not aware of how to Use those Fiori Apps in our Manufacturing Cycles […]
Background Whenever there is a requirement for Currency Conversion, the time reference plays a dominant role for determining exchange rates. Exchange rates vary on daily basis and which exchange rate should be applied for currency conversion is always a question. BW – Currency Conversion Types People who are familiar with BW, must be knowing Currency […]
This blog will explain the basics of the Plan Visualizer tool, which is the performance analysis tool inside HANA. The different sections show: How a plan can be created directly from HANA Studio, how and why you should invest in a consistency check before the analysis, what the overview page and the links to the […]
Motivation In May 2018 the European Union enforced the laws on data privacy to protect its citizens in an environment which is increasingly based upon information and data. Following the media around topics like General Data Protection Regulation (GDPR) there are examples of major technology and social media companies who already were in the situation […]
What this is all about? Within a company you have various user groups eg Users with full access, key user authorizations or end-user authorizations limited to for example one company code or one costcenter. With the addition of new applications like SAP Lumira creating powerful Dashboards, SAP Analytics cloud creating interactive stories from BW models […]
SAP HANA Table Functions Recently I spoke to multiple developers working on SAP HANA Native system for developing reports. What really surprised me was the fact, that most of them are still using calculation views of a SQL Script type instead of Table Functions. What is more, some of them were even not aware that […]
Hi, nice blog Do you have any example of employee central (...)