This blog post helps to connect with SAP HANA DB (Version 1.0 SPS12) then extract the data from HANA table/View and analyze the data using Python Pandas library. Then you can clean and select independent variables/features data to feed the Machine learning algorithms to predict dependent variables or find insights. Scenario: I am taking the […]
SAP HANA customers are often requesting the integration of SAP HANA data with data stored in AWS S3 object storage. In this blog I am relaying some work of an esteemed colleague. We will describe the easiest possible integration with zero coding effort by simply using the AWS Storage Gateway product. The main steps covered […]
BW/4 HANA Query Creation on Composite Provider using variable for selection 1.Create a query 2. Go to sheet definition Section 3. Click on Info provider 4. Select needed Characteristics in Rows and key figures in columns section respectively As following 5. Now if you need selection / Input screen when a user runs a report, […]
Purpose The purpose of this blog is to highlight backup solution that can be designed for HANA database on AWS without any overhead of using third-party tool. The idea of specifically mentioning AWS is because I’m using AWS Simple Service Storage (S3) for this solution, otherwise you can incorporate this approach in any other cloud […]
Have you ever wanted to combine HANA’s many engines but didn’t know how to? Perhaps you’re still waiting for the right use case? Here we wanted to identify people or places within unstructured documents, PDF and Word documents. Surface some intelligence, perhaps the relationships between the people. For the purpose of this blog, we have […]
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 […]
Introduction: The goal of this documentation is to give detailed step by step instruction on how to create a static tile pointing to URL. Prerequisites: User id should be having Launchpad admin access “SAP_UI2_ADMIN_700” in Gateway for using Launchpad Designer for creation of Tile. Creating Tile in Launchpad Designer: Login to Launchpad designer by using […]
Hi, nice blog Do you have any example of employee central (...)