This blog is out-dated – please approach silvia.backes in case of questions. — SAP Hybris Marketing offers two options for triggering campaigns based on customer actions or events: If you need a near real-time reaction from SAP Hybris Marketing you can use what we call trigger-based campaigns (e.g. a product registration requests the customer to rate the product, change in loyalty membership).....
This blog post informs you about how to install multiple SAP Customer Checkout manager in the same machine, and how to update/upgrade them. This blog focuses on SAP Customer Checkout manager only. For SAP Customer Checkout kindly read this blog LINK . When you download SAP Customer Checkout manager from SMP you get a .zip file and you extract....
The process of gathering data from numerous sources is an essential prerequisite for organizations to carry out advanced analytics, data science, and machine learning. However, ingesting and consolidating this data to establish a trustworthy, unified data repository is an arduous and expensive task. In this blog post, I will demonstrate the process of ingesting data from....
Moving data from one system to another with some transformations is Data Integration. This is fine for ad hoc integrations but if such a pipeline is executed regularly and part of an entire ecosystem, I would add more requirements to a data integration process. Let’s coin it Enterprise-grade Data Integration. To make things more obvious,....
We already covered SHAP-explained models for classification and regression scenarios in a previous APL blog post, and at the time we talked briefly about the main effect of a predictor and its interaction effect with the other predictors of the model. Now with HANA ML 2.17, you have the ability to visualize the interaction between variables....
Although the database instance was up and all HANA services were active, a database unavailability alert appeared in the “Focussed Run” or in the CCMS alert. In this article, identify the root cause of the HDB connectivity issue and also check whether the KEY entry corresponding to the database user was present in the hdbuserstore.....
AWS Launch Wizard is a service from AWS that helps accelerate the SAP implementation cycle by easy & quick deployment of SAP applications and databases on AWS, in standard, distributed and high availability configuration with best practices built in. In this blog we are going to walk you through, step by step on how to....
In this blog post, we will learn how to build the XSODATA services used to expose our data model to the user interface. This tutorial is designed for SAP HANA on premise and SAP HANA, express edition. It is not designed for SAP HANA Cloud. I have used SAP HANA XS Advanced (SAP Web IDE).....
updated date: 31.May.2023 Business data has become a strategically crucial asset for enterprises after they have digitalized their business management with enterprise software. According to HBR insights, companies can derive value from data. For RISE with SAP customers, they are running their business transactions in SAP system for their corporate finance, supply chain, production, warehousing, sales and....
SAP HANA, the in-memory database platform, has revolutionized the way organizations handle their data-intensive workloads. As with any complex technology, troubleshooting occasional issues is essential to ensure optimal performance and reliability. Hello all, in this blog post, we will delve deep into SAP HANA troubleshooting, exploring common challenges, best practices, and advanced techniques to effectively....
Introduction: Side-by-Side Extension in SAP refers to the approach of extending or enhancing existing SAP systems without modifying their core functionality. It allows for the development and deployment of additional custom applications or functionalities alongside the existing SAP landscape, minimizing the risk of system disruptions. In a recent project, I was assigned the development of....
In this blog post, we will learn about the rolling average, it’s also called a moving average, a running average, a moving mean, or a rolling mean. You’ll very often see rolling averages used in time series data to analyze trends, they are calculated as the mean of the current and a specified number of....
Under this blog, I have outlined how to configure an SAP Web Dispatcher (WD) so that it acts as the reverse-proxy server for an XSA instance where SSL is terminated at the XSA server. The WD will simply route requests to the XSA instance. This setup allows the XSA host to be hidden from the....
After longtime, I’m writing blog in SAP , hope it will be useful who are working with CDS Views. About Author: I Nanda Anantha working in SAP BW/ABAP and HANA for last 18 years and written few blogs in past and my interest is exploring and learning new things in SAP. Why I’m writing this blog?....
In this article, the method of connecting Service Now with HANA SDA connection is explained along with the set up for the delta connection is described. The scenario described here will explain the connectivity with Service Now and the data extraction techniques. Connectivity with Service Now Connectivity with Service Now from HANA is possible through....
This blog relates to generation of an Adobe Form via transaction code CORRHIST in SAP HANA. Normally when selecting a document to print and output to PDF as a spool file there is no issue, but in some instances the document may fail to produce due to Adobe Document Services (ADS), encountering an error with....
First we will discuss about why analysis for office is useful for Business intelligence reporting and what are the advantages and the steps to create a report, scheduling it to specific users. SAP Analysis for Office is a plugin from Microsoft which can be used with excel and power point. When Excel plugin with SAP....
This blog would give basic idea on different concepts which are used in the S4HANA CDS view. It will be helpful for new beginners on basic concepts which we can use while creating a CDS views @AbapCatalog.sqlViewName:It is mandatory annotation and which is created in SE11 (16 Characters length) after activating and it will not....
(Jana Subramanian serves as APJ Principal Cybersecurity Advisor for Cloud Security and has been recognized as a Fellow of Information Privacy (FIP) by the International Association of Privacy Professionals (IAPP). As part of his responsibilities, Jana helps with strategic customer engagements related to topics such as cybersecurity, data privacy, multi-cloud security integration architecture, contractual assurance,....
Hello Colleagues, Im part of HANA LAC team that help with the most complex migrations in the region, thanks for take some time in read this blog about Tenant replicacion, this method will be the most common in the next years due a some restriction we will face in on premise and RISE infrastructure. The....
Data Anonymization in SAP HANA Anonymization methods available in the SAP HANA database allow you to gain statistically valid insights from your data while protecting the privacy of individuals. Why Anonymize? In a data-driven world, a growing amount of business data contains personal or sensitive information. If this data is to be used by applications....
After activating the sslenforce parameter in the hanadatabase, our attempts to connect to the hana database via hana studio were unsuccessful due to an “only secured connections are allowed” error. Here is one of the methods we employed to establish a secure connection with the hana database. This change was implemented based on the....
Using CAP CDS (Cloud Application Programming – Core Data Service) one would expect that this is working with HANA Cloud out of the box. That is unfortunately not the case. But with a little switch things are getting better. In the beginning CAP CDS for HANA was generating HDBCDS. This was also seen as the....
OData annotations in SEGW with example and consume it in visual studio to create a fiori application
In this blog you will understand how to create Odata annotations in SEGW with example and consume the service in visual studio and display the output in fiori launchpad. When ever you are adding annotations to odata service in segw we are suppose to write the coding in MPC_EXT class inside DEFINE METHOD( you have....
There is huge knowledge available about SAP HANA High Availability and Disaster Recovery topic, but the knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). The aim of this article is simplify and make content consumption easier with a centralized page. There is no reason to duplicate the already well prepared content,....
Today’s blog will be very niche, but like all things niche, it will find a reader. 🙂 I’ll be discussing the impact of the VARBINARY data type when trying to do “Remote Join Relocation” with SDA (Smart Data Access) functionality. In addition we’ll see the following: How to monitor your statements executed against the remote databases How....
Today in the first part I will discuss about the table functions and its utility in HANA . Why we will use table functions? 1.Table function : Table function is a piece of code written is SQL script in HANA which used to return data as a tabular format after calculating a business scenario logic.Complex logic can be can....
Imagine you were given a map divided into blocks, with a lake marked on it. And now you’re supposed to decide to which block this lake belongs. Map with blocks and lake For purposes of this post, let’s assume we should select the block with the biggest overlap with the lake itself. In this case,....
last updated: 2023-04-14 16:00 CEST After we identified our bottlenecks, understood the workload and configured the right parameters for our instance, we have to check if we should go for a new HANA workload class or use the possibility for user parameters. At first you should know that your first choice should always be to use workload....
Useful Queries to know for HANA SQL Script Development. In this session I will discuss about few sample queries that can help fo individual script developer for script project. Query 1 : How to get top 10 salary data in sql query : /*--- Solition 1 -------------*/ SELECT * FROM table WHERE ( sal IN (....
VMware as a leader in the virtualization industry is obviously the first choice when it comes to running SAP on an elastic, agile, complete (top to bottom) and certified virtualized platform. Most likely when we look at a running SAP workload on VMware, we will intuitively think of running workload on-premise or private data center....
The SAP HANA supportability toolset provides a consolidated set of tools for performance analysis and troubleshooting. The tool is available as an extension for Microsoft Visual Studio Code and includes a range of reports that can be used for online and offline analysis. Key Value Simple The tool integrates SAP HANA database knowledge from SAP....
Today, I am going to discuss the basic of AMDP script and implement a SAP BW transformation logic using AMDP script. First question is what is AMDP script and why we will use AMDP instead of normal AMAP script for different types of routine like Start End and expert routine. AMDP is ABAP managed Database Procedure which used to run in HANA runtime. All the....
With the release of SAP Web IDE SPS07 and HANA 2.0 SPS07, new features in the area of calculation view modeling will become available that had only been released in SAP HANA Cloud before. Below is a short description of newly released features. For examples of the individual features have a look at the respective....
Today I am going to discuss about what you can do in terms of Optimization in HANA. A. Performance tuning on database design Level : 1. Check all tables by high amount of records and determine the growing rate. Select from table GLOBAL_TABLE_PERSISTENCE_STATISTICS. Therefore, you can use the select SQL to check. Only tables where DISK_SIZE....
In this blog, I will discuss about the summary of the XSC to XSA HANA artifact migration. Below are the steps need to perform – 1. Migrate all the SQL Calculation view, analytical view, attribute and and table functions into Calculation view using migrate tool used for Migrate option available in the quick view. 2.....
In this session we will discuss about the file base persistence of a local file using a simple CAP application developed in SAP Business Application Studio. SAP CAP (Cloud Application Programming Model) is a framework on Cloud Foundry environment provided for boiling service and application which can use to solve different business scenario for enterprise corporation. The Core Data &....
———————————————————————————————————————————– Cross container access ———————————————————————————————————————————– 1. When Source and Target HDI container exists in the same HANA server – A. Create a key and value in the Source-DB AND in Tagged-DB mention the Key and HDI Source Service in the service of Type – type: com.sap.xs.hdi-container B. Create two Hdbrole – One for the object_owner....
————————————————————————————————————– Scenario when use odata and XSJS is preferable ————————————————————————————————————- When required this two use oData – 1. Select data from the database and Expose as a service. 2. Do n’t used to perform CRUD operations (CREATE, READ, UPDATE and DELETE). When required this two use oData – 1.Crud Operation is needed. 2.Sending data to another....
Here we will see one quite useful in-built Hana function $rowid$ and it usages. $rowid$ – Returns the internal row ID value for each row of the table. Whenever any new row is inserted in a Hana table new unique numeric ID is internally assigned to that row. This id is not available in the table in the....
HANA XSA DESIGN Principle to optimize the database performance – 1.If you partition a table by a sensible key (date, or an attribute like active/inactive). partitioning strategy: On a single node appliance 3-5 partitions is normally a good number for optimal insert performance. On a scale-out appliance, you can multiply this by the number of....
Rollout of Partner Technology Innovation for SAP Customers IBM Power systems and SAP HANA Technology Innovation Network recently rolled out Power10 support for SAP HANA 2.0 (SAP HANA). This informational blog will discuss keynotes from the Power10 technology validation for SAP HANA. Partner hardware builds the technical foundation of the SAP HANA environment, be it....
In this topic we will discuss about the main ASDO’s and their functionality which will help to understand the basic BW project design in the next blog I am going to discuss about. The below is very important . Common ADSO’s available in BW 7.5 on HANA, BW4/HANA 1.0 and BW/4HANA 2.0 – 1. Data Mart ADSO : Memorable point : ....
(Jana Subramanian serves as APJ Principal Cybersecurity Advisor for Cloud Security and has been recognized as a Fellow of Information Privacy (FIP) by the International Association of Privacy Professionals (IAPP). As part of his responsibilities, Jana helps with strategic customer engagements related to topics such as cybersecurity, data privacy, multi-cloud security integration architecture, contractual assurance,....
Today I am going to discuss about BW7.5 on HANA,BW/4HANA Migration Post and pre steps from BW/BI development perspective. Most of the work done by the SAP basis team of any project but some responsibility also rely on SAP BW/BI consultant. The standard Steps is given below – 1 Pre-Cutover First of all create a Process chain where put all....
Today I want to draw your attention to the visual aspect of information presentation. The human brain is incredibly good at getting and interpreting visual information. We spent years in our high schools and universities analyzing graphs of functions and getting common with this form of information. A huge part of those charts has time....
Hello SAP Community Members, My Name is Zeshan Shafaqat. I’m Expert in SAP BI/BW and SAP Analytics Cloud. I found many peoples having trouble that how can we add HANA servers in eclipse to develop CDS Views. In this Blog, I show you how can you add HANA servers and develop CDS Views using eclipse.....
Security is one of the top priorities for enterprise customers. For enterprise end users, having a seamless log-in process to different systems automatically without manually inputting credentials, can not only improve user experience but also increase enterprise security. With that being said, SSO plays a key role in the process. In this article, we are....
In this beginner blog post we are going to see how we can create Factory Actions in ABAP Restful Application Programming Model. Ref: https://help.sap.com/doc/abapdocu_cp_index_htm/CLOUD/en-US/index.htm?file=abenbdl_action_nonfactory.htm NOTE: We are using same application code base which we have used to demo Large Object (LOB) or File Upload Blog. Refer below URL: https://blogs.sap.com/2023/02/13/abap-restful-application-programming-model-rap-abap-rap-file-upload-large-objects-lob/ Before starting on....
Recently I had to work around some limitations in SAP Business One’s Service Layer. As a result, I had to decode some BASE64 string that was stored in our customer’s database, modify the (unencoded) string and then save it back, all from within a native SAP HANA Stored Procedure. To my surprise, there is no....
(Jana Subramanian serves as the APJ Principal Advisor on Cybersecurity and is a Fellow of Information Privacy (FIP) awarded by the International Association of Privacy Professionals (IAPP). Jana provides expert support on cybersecurity, data privacy, cloud security integration, contractual assurance, audit, and compliance to strategic customers in APJ.) Introduction RISE with SAP is a comprehensive....
SAP HANA XSJS applications are based on synchronous API. On the other hand, Node.js is an asynchronous runtime. Thus, for XSJS applications that run on Node.js there is a certain code incompatibility. Up until Node.js 14, this incompatibility has been handled by an NPM package called @sap/fibers (forked from laverdet/node-fibers). Unfortunately, @sap/fibers is not compatible with Node.js version 16 and higher. Also, Node.js supports....
This paper focuses on listing down the technical details and sequence of steps which are needed to accomplish the automation of Google Cloud Virtual Machine deployment along with SAP HANA DB instance installation using Terraform and Ansible scripts. Intention is not to teach about terraform or/and ansible scripting or SAP HANA but sharing my hands-on....
SAP HANA is an in-memory database architecture. This architecture is the heart of the concept. Huge knowledge available about SAP HANA memory topic, but the knowledge is fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). In order to simply and make content consumption easier I have created a centralized page, a single source....
SAP Mobile Platform (formerly Sybase Unwired Platform) is a mobile enterprise application platform designed to simplify the task of creating applications that connect business data to mobile devices for workflow management and back-office integration. Scenarios: Below scenarios where SAP Mobile platform can be used and can be implemented No Back-end OData service in SAP Cloud....
Under this blog, I have outlined the SAP analytics cloud to on-premise SAP HANA SAML SSO setup via AZURE identity provider. SAP SAC cloud and backend systems should be connected via the same IDP provider. DISCLAIMER The content of this blog post is provided “AS IS”. This information could contain technical inaccuracies, typographical errors, and....
Hope you all are doing Great! Welcome back to my data migration blog series. Purpose of this Blog : With introduction of S4 HANA, SAP has introduced us to many new tools built in the system. Today we will talk about one such tool used for data migration in S4 HANA, SAP Migration Cockpit. I will....
In many companies the business application system landscapes over time have become very large and extremely complex. This scale and complexity slows down innovation, because even a small change can have a huge impact on the whole system landscape. The impact could be business process related, so extensive testing in all affected systems is required.....
What is Dynamic Tiering? SAP HANA dynamic tiering is a native big data solution for SAP HANA. Dynamic tiering adds smart, disk-based extended storage to your SAP HANA database. Dynamic tiering enhances SAP HANA with large volume, warm data management capability. SAP HANA dynamic tiering adds the SAP HANA dynamic tiering service (esserver) to your....
Hi, I’m Solution Finder, I’ll be your server for today. Can I take your order? The Solution Finder for SAP EarlyWatch Alert app will publish a new feature on 27th of February 2023 which is remarkable: Now it is the customer’s choice which alerts are relevant and which not. The service will stop bothering with any unwanted....
Note: Adjusting SAP DWC to SAP Datasphere with the presentation of SAP Datasphere today. Repeatedly in recent years I have been confronted with the question of how to evaluate “hybrid” development” in BW, i.e. creating virtual models with SAP HANA native Calculation Views built on BW-generated HANA Calculation Views, often with the subsequent use....
I’ve been searching for a solution for a while now, but I’ve been unable to find one that meets my requirements, even after consulting multiple blogs. It took some effort, but I’ve finally found a solution that fits my needs. Letsss goo(Nervously excited) Introduction- Dealing with multiple rows of data can be challenging, especially when....
In this blog I am going to discuss how we can expose Calculation view as a service via OData in HANA XSA using Web IDE. Then either you can consume it in SAPUI5 or other front end interface applications. Before that we need to understand the architecture of HANA XSA which is given below – When....
In the first blog in this series, we looked at how the HANA platform’s capabilities reduce technical debt and complexity by eliminating the need for ETL when integrating your SAP S/4HANA and ArcGIS Enterprise systems. In talking to a number of utilities, they have described their frustration with a file based interface between the two most important....
In this section I will discuss about the create a XSJS application consume calculation view and sent it to Http response to SAPUI5 in SAP HANA XSA using WEB IDE. Architecture : Steps : 1. Create a Calculation view using required tables in the HDI container. For our case we created a CV CV_EMPLOYEE from....
This Blog explain the restore steps of using backint from Dell EMC netwoker software Expample: Source machine name: s4hhdb1 Source Bakup pool: S4HPRD Source tenant DB: SH1 Target machine name: testdbr2 Backup media server name: emcbackup137 Target tenant DB: SH1 FQDN= yoonus.local The following Changes to be made in source client GUI.. login Networker > select source> modify the property....
In Earlier Versions of HANA, to improve performance of the Model/Calculation view, it was suggested to stage the data in some physical table using a procedure and then create the calculation view on top of that staging table. This help us to fetch huge amount of data quickly as there are no calculations involved.To Avoid....
In some business scenario need to parse the data and need to implement the loop and using calculation view it is not possible. The Cursor in SAP HANA procedure can be used for other purpose also. Let’s implement one scenario by creating a procedure using cursor – Cursor Syntax – DO BEGIN DECLARE CURSOR DEMO_CUR1....
As well as previous SAP S/4HANA product versions, this document aims to guide you, in preparing the landscape when planning to carry out a conversion to SAP S/4HANA. Some activities can be started early in your current environment and will be very effective in making the conversion successful. There are some activities you may not....
In the last two blog I have discussed about the expose of the DB artifacts like calculation view using XSJS and Xsodata service. This this blog I am going to discuss about the creation of a web module and integrating the Web application or module with XSJS and OData service which consuming consuming Database artifacts.....
last updated: 2023-01-09 18:00 CEST Ok, you already read part I of the deep dive series of HANA workload management. You are waiting for more insides after you identified some HANA resource bottlenecks? Then you are on the right track. In this part I will describe how you can get an overview of your systems workload and....
In this blog I am going to discuss about the pure node js module (without xsjs support) to populate with HANA DB artifacts in HANA XSA. Here we will populate a table from HANA HDI container. Pre steps : 1. Create a Cloud DB instance : A. Log into the trial account and go....
This document demonstrates the steps required to automate the installation of an SAP HANA scale out system with non-shared storage. Participating hosts have the mandatory file systems (XFS) mounted locally, such as /usr/sap, /hana/data/, and /hana/log. For this demonstration, two nodes have been considered, but the design can be scaled up as needed. The only file system that is shared....
There is huge knowledge available about SAP HANA reclaim / shrink / defragmentation topic, but the knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). In order to simply and make content consumption easier I have created a centralized page, a single source of the available information regarding SAP HANA persistence.....
Today I am going to discuss how when a query executed in SAP HANA, How it is processed and Optimized and generated a plan and push to a engine. This concept is will help you to optimize HANA Query in latter stage. The summary architectural diagram is given below which is provided by SAP in....
In my previous blog posts, I wrote about GDAL with SAP HANA driver in OSGeo4W and how it enables GDAL utilities in the command line. During my SAP TechEd community session, we discussed as well the possibility of coding this in Python. “The GDAL project maintains generated Python bindings for GDAL and OGR. Generally speaking, the classes and....
Today I am going to summarize the point how we can target to achieve best performance for a query and calculation view in HANA 2.0 SPS 03 and afterword’s version with scenario. There are few ways by which we can analyze performance and tune it to get optimum one from the model – 1. Using EXPLAIN_ PLAN....
This is my first Blog so please conisder;-) As a technical sap consultant working for large companies we are facing several challenges concerning big SAP- and HANA-landscapes. There are a lot of automated processes for administrating of these landscapes and this leads to problems in connection with HANA databases. One of these challenges I wan’t....
Hi all, SAP HANA is no more a new name or new Technology Jargon now. Most of us would be either have already started using it, are in mid of a transition to SAP HANA, have attended training or workshops or read blogs about the same. SAP HANA (High-performance Analytic Appliance) is a multi-model database that stores data in....
From S4HANA system we are extracting data to SAC using HANA CDS Views: S4HANA— HANA CDS Views— SAC Core Data Service (CDS) Views: are virtual data models of SAP HANA which allows direct access to underlying tables of the HANA database. SAP CDS Views came into being with SAP’s new programming model. SAP CDS Viewsaim to push....
The query optimizer uses statistics to select the best query plan. The query optimizer may be unable to choose the best query plan if certain statistics are missing. If database statistics for HANA Virtual Tables have not yet been created, query performance on BW Providers using Smart Data Access may not be at its best.....
Starting with SAP Landscape Management (LaMa) Support Package (SP) 21 the cluster integration for the SUSE Linux Enterprise high availability extension was implemented. Now with LaMa SP25 it also integrates with Red Hat Enterprise Linux High Availability Clusters, which means that the pacemaker support is completed for all SAP HANA database environments. This blog describes....
We are familiar with getting data from a table using AMDP procedure or AMDP table function. But, how about CDS View, I tried a case and got the following error Basically, AMDP will get data from database, and it will get all client (assume your system have several clients), that is a reason why you....
With the new evolving modern methodologies around many SAP applications and database technology, i am trying to contribute with some idea that can be helpful or spark a new idea for others. The thought is … What if we can create HANA docker container with database filesystems mounted to the container using NFS filesystems from....
To best follow this post and try things out yourself, you should: Have some basic knowledge of the Python programming language Have a data lake Instance provisioned and configured. For instructions on how to provision an instance one can refer to the following – Configure the SAP HANA data lake File Container. Managing Data Lake Files |....
Today I am going to discuss about the MTA project Integration with GitHub as a source control in Web IDE: HANA XSA. Before perform the steps, I want everybody know the flow and keep the diagram so that you have a clear concept on this migration – Integration Steps : 1. Open your project....
Today I am going to discuss about the MTA project Integration with GitHub as a source control in SAP Business Application Studio: HANA XSA. earlier I discussed integration with Web IDE which is slide difference. SAP Business Application studio support Personal access tokens instead of passwords and to access GitHub repo in a SAP Business Application Studio....
Data Cleansing and Data Matching with SAP HANA – Smart Data Quality (Source: SAP) Introduction Today, companies leverage data from a variety of internal and external data sources. In order to integrate these successfully, the data must not only fit semantically, but also have a common key in order to be able to merge them....
Today I am going to discuss about the Transport and Deployment of Artifacts in WEB IDE : HANA XSA. In the below diagram I am going to discuss about the different deployment option for MTA Application. Now describe each and every Application Artifact’s deployment process in Details : 1. Artifact Deployment using....
NSE Implementation Experience ** All the screenshots are taken by me from one of our HANA implementations. Introduction: NSE is a fully functional warm data store on HANA database, which we can leverage to move less frequently accessed data without loading fully into memory. This is a very good feature, where we can avoid increasing....
We all know the world is evolving. So is SAP. 🙂 In the era of SAP ECC, there used to be Workflow builder (Transaction Code – SWDD) which ties together all the workflow component and the approval cycle very tightly with all the building blocks. SAP HANA came up with yet better solution design for generalized....
In this blog, I wish to discuss the high-level technical details on ZDO upgrades/updates that can be performed by any basis expert who has completed the learning journey and assessment ADM330. If you want to have a quick overview on what this assessment is about, do check out my other blog =>”Why should a basis....
This blog shows to integrate AWS S3 Buckets, AWS Lambda Functions and SAP S/4 HANA OData APIs. For those unfamiliar with AWS S3 and Lambda functions, here are descriptions from the AWS websites: AWS (Amazon Web Services) Lambda is a serverless, event-driven service that allows you to execute any type of application logic dynamically without the....
Before Driving deep into Technical details . let me give some brief about why we need to do this ABAP Development Tool (ADT) is an Eclipse based tool provided by SAP, You will need ADT if you have to work on the ABAP CDS views. Even though,CDS views are emdedded into the ABAP Dictionary, there....
Before Driving deep into Technical details . let me give some brief about why we need to do this ABAP Development Tool (ADT) is an Eclipse based tool provided by SAP, You will need ADT if you have to work on the ABAP CDS views. Even though,CDS views are emdedded into the ABAP Dictionary, there....
In the previous blog, we saw how tenant onboarding works, tenant-specific schema creation and dependency injection. In this blog we are going to focus on the following topics: Accessing Tenant Specific Data and improving the performance of data access from the database. How to access destination data coming S/4HANA Cloud/on-premise system from the subscriber subaccount in....
The SAP HANA Deployment Infrastructure (HDI) is a service layer of the SAP HANA database and helps to create runtime database objects from design-time artifacts. It uses containers to store design-time artifacts and the corresponding deployed run-time objects. Inside the database, the HDI container is represented as a schema but is owned by a technical....
This blog describes installing HANA database automatically in less than 15 minutes in AWS with some prerequisite like VPC, AMI, Subnet, Security Group, IG, EC2, EBS, AWS CLI, AWS Access Keys and SAP HANA media others mandatory services available in place to host the HANA workloads in AWS cloud. Operating System (AMI): AMI is created....
This blog is part 2 of 2 in this series of Automating SAP Installation in minutes, refer the part 1 of this blog for the prerequisite to get started. (https://blogs.sap.com/?p=1649584?source=email-global-notification-mod) This article provides detailed steps and commands required to get an EC2 instance provisioned, with the ‘XFS’ file system built automatically with a successfully SAP....
Some of our asset intensive customers, like utilities, who are implementing ArcGIS on HANA with SAP ERP have asked me: how do the pieces fit together and where can I read about this in one place? While the value that the HANA platform brings to ArcGIS Enterprise is based on the same capabilities that HANA....
The SAP EarlyWatch Alert service covers many topics regarding system health, performance and security. This blog describes how you can self-organize your consumption of the service to get the most benefit out of it: Stay informed about urgent topics by setting up notifications, schedule regular meetings to follow-up the comprehensive alert list and pro-actively seek....
This Blog explains how you can leverage native SAP HANA development artifacts with CAP. In particular we look at the use of Calculation Views, inside Cloud Application Programming (CAP) Applications. This includes OData access to Calculation Views. Solution: Pre-requisites: Set Up SAP Business Application Studio for Development Launch the Business Application Studio (BAS) and choose Create Dev Space NOTE:....
Hello Everyone, The following process will shed light on how to Restrict to Create Duplicate ERS Invoice by using Transaction Code – MRRL. Problem Statement: The problem is that duplicate ERS invoices are produced during business transitions for the same reference# in the account of the corresponding vendor, and as a result, double payments are....
本ブログでは、SAP S/4HANA(以下、「S/4」) と SAP HANA Cloud (以下、「HANA Cloud」) とのデータ連携の設定について解説します。 S/4とHANA Cloud の連携のシステム構成図は下記の通りです。 機能概要と設定手順解説 本Blogでは下記の動画にて設定方法をガイドします。 ※ 画面サイズを調整する場合は、再生時に画面右下に表示されるYouTubeロゴをクリックして別画面でご確認ください。 また、動画中に出てくる関連情報/補足情報を下記にまとめていますので併せてご確認ください。 関連情報 SAP HANA Smart Data Integration – SAP HANA Cloud との接続 SAP HANA Cloud, SAP HANA Database Data Access Guide – Supported Remote Sources SAP HANA Smart Data Integration – Installation and Configuration Guide – SAP ABAP....
Problem: SAP HANA Cloud uses BTP services and service keys. There might be the need to update the service-keys. Solution: Warning: This is advanced scripting and you could harm your configurations. Please test carefully with dedicated spaces before you are applying this to production instances. This includes also development environments/spaces. Writing a script that automates....
Marketing campaigns need to be relevant for the recipient, and worthwhile for the sender. It is not worth sending a promotional offer about a product or service if you know that your customer will buy it anyway. It is not worth calling a subscriber to persuade him to maintain his subscription if you know he....
There are a lot of things you can parameterise on JAVA connection as well as on the connections pool. Some of the parameters support the communication with database or the caching behaviour and others influence the management of connections. Each case is different and you have to bring some experience as well as experiments to....
本ブログでは、SAP Business Technology Platform (BTP) の Free Tier サービスでの SAP Data Warehouse Cloud (DWC) のインスタンス作成方法について解説します。 Free Tier は言葉の通り、無償で利用可能なBTPのサービスです。 ※ BTPのFree Tier の始め方はこちらのブログに分かり易くまとめられているので参考にして下さい(KATO Mino さん、ありがとうございます)。 何と言っても、SAP S/4HANAとのデータ連携を試すことができるので、まずは色々と悩む前に、色々と試して手応えを感じていただけたらと思います。その環境をそのまま有償版に切り替えることが可能で、検証/評価やPOCで作成した成果物をそのまま本番環境として利用することも可能です。 設定手順解説 本Blogでは、下記の動画にて設定方法をガイドします (動画時間:約8分)。 ※ 画面サイズを調整する場合は、再生時に画面右下に表示されるYouTubeロゴをクリックして別画面でご確認ください。 注意事項 Free Tier での DWCは、稼働環境のリソース制限 (メモリサイズ : 64GB, ストレージサイズ : 128GB) や連続利用期間の制限 (90日間)、使用可能な機能の制限(下記、関連情報参照)があります。 ※ 基本的な操作確認や機能確認には十分かと思います。 関連情報 Free TierではじめるSAP Data Warehouse Cloud BTP環境でのSAP Data Warehouse Cloud インスタンス作成....
Introduction: This blog explains a reference architecture of a High available SAP system in Windows in Azure Cloud with DR solution. This is one of the recommended architectures from Microsoft & SAP in Windows in Azure cloud where we will be utilizing Windows DFS-N to support flexible SAP shared file systems. We will be referring shared....
This blog post is aimed to share my experiences working on data migration activities migrating data from a SAP S/4HANA Cloud system to a SAP S/4HANA On-Premise system and the usage of SAP Migration Cockpit together with SAP HANA Smart Data Integration (SAP HANA SDI) helping on this purpose. There are a few challenges on this scenario....
While you’re developing any enterprise applications under HANA Server, you must have came across such tables which are not of use and we should delete to avoid memory consumption of a HANA server.But it can’t be performed without any validation which will cause major issues to performance of web applications developed. Hence, We have taken....
This is a BTP blog series, where we will discuss the right way of S/4 HANA implementation and … Why we should adopt Keep-Core-Clean (S/4 HANA) approach How SAP BTP helps to keep-core-clean (S/4 HANA) & What a Business can achieve with keep-core-clean (S/4 HANA) In the first blog of this series, we will discuss each topic above at....
Let’s see how you can automate your processes easily by leveraging the powerful iRPA and a very strong backend technology like SAP OData. Problem Statement: Send your Excel data to SAP System – Just Store it somewhere in custom table Simple Solution Proposed: Develop one RPA bot and integrate OData Endpoint and Make a POST Call....
For SAP Landscape hosted in cloud Infrastructure, keeping Linux patching up to date is a very key requirement to address security hardening, vulnerability assessment and for other mandatory compliance requirement on a regular basis. Applying Linux patching for a large SAP Landscape is a very time-consuming efforts, as it does require a clean stop and....
A typical Business requirement in today’s world is to send certain Finance Outputs via email automatically from SAP as soon as you generate them. In S/4 HANA on-premise (and ECC as well), to be able to achieve this. Here I am sharing the BTE (Business Transaction Event) which can help us to achieve this functionality.....
This simple blog post helps you get an understanding of how data from an SAP S/4HANA on-premises system can be Analysed using SAP Analytics Cloud which is connected using Data Warehouse Cloud in SAP Business Technology Platform (BTP). This blog post covers – Connectivity of SAP S/4HANA On-premise system to SAP Data Warehouse Cloud. Creation....
This simple blog post helps you get an understanding of how data from an SAP S/4HANA on-premises system can be Analysed using SAP Analytics Cloud which is connected using Data Warehouse Cloud in SAP Business Technology Platform (BTP). This blog post covers – Connectivity of SAP S/4HANA On-premise system to SAP Data Warehouse Cloud. Creation....
I was going through the blog by Vishwa Gopalkrishna about the CI/CD automation approach for hybrid developments focusing on HDI container-based developments for SAP HANA Cloud & Space level Developments within SAP Data Warehouse Cloud .My blog would be a pre-requisite for the automation approach and would provide the hands-on and step by step tutorials for accessing SAP....
Introduction Big Data is a term created in 1980 by American sociologist Dr. Charles Tilly in his article “The old-new social history and the new old social history” and although the context for the use of the term Big Data in this article was different at the time it was published in 1997 two NASA....
“Every company will become a technology company, and every company will become a data company” – Steve Brown ‘The Innovation Ultimatum’ Please read PART1 In SAP world, almost every company intended to use S/4HANA as their digital core. But to run any sort of business, many companies also need various other SAP and non-SAP systems/SaaS solutions. (On....
Below a list of some of the important standard SAP tables in a SAP Business Warehouse (BW) system with their description. Also there are some recommendations with reference SAP note on how to perform housekeeping and cleaning up of these BW tables. For more information you can see SAP note 2388483 – How-To: Data Management for Technical Tables. ....
Through SAP ADT or Hana Studio, we can load the CSVFlat file without the need to use SAP S/4, facilitating the process and gaining speed in execution. Let’s see how to do this procedure. Imagine performing the following task: Import some CSVFlat files to Z tables in the S/4 Hana environment. The most common possibilities....
I am writing this blog to define HANA tables and upload data to the table using python package hana_ml. Environment Environment is as below. Python: 3.7.13(Google Colaboratory) HANA: Cloud Edition 2022.16 Python packages and their versions. hana_ml: 2.13.22072200 pandas: 1.3.5 scikit-learn: 1.0.2 As for HANA Cloud, I activated scriptserver and created my users. Though I....
I am writing this blog to show data visualization using python package hana_ml. DatasetReportBuilder is a EDA function and show report as below. I used famous titanic dataset, which is easy to understand. Environment Environment is as below. Python: 3.7.13(Google Colaboratory) HANA: Cloud Edition 2022.16 Python packages and their versions. hana_ml: 2.13.22072200 pandas: 1.3.5 seaborn: 0.11.2(just....
I am writing this blog to show basic classification training procedures using python package hana_ml. Wtih class UnifiedClassification, you can use several classification algorithms. Besides, training result can be exported as HTML report easily. Environment Environment is as below. Python: 3.7.13(Google Colaboratory) HANA: Cloud Edition 2022.16 Python packages and their versions. hana_ml: 2.13.22072200 pandas: 1.3.5 scikit-learn:....
I am writing this blog to show basic model management using python package hana_ml. Wtih class ModelStorage, you can save and load models. Besides, I show State Enabled Real-Time Scoring Functions for faster prediction process. Environment Environment is as below. Python: 3.7.13(Google Colaboratory) HANA: Cloud Edition 2022.16 Python packages and their versions. hana_ml: 2.13.22072200 pandas: 1.3.5 scikit-learn: 1.0.2....
In a series of blog posts, we address the topic of how to develop a Machine Learning Application on SAP BTP. The overall sequence of steps performed by the involved personas is depicted below: In this particular blog of the series, we focus on the data scientist’s work, i.e., understanding the business problem, performing experiments,....
last updated: 2023-01-09 18:30 CEST We all know that HANA needs a lot of system resources due its in-memory design. When we are not monitoring the prod. systems well the system can get overloaded by too highly parallelized applications, a memory leak or a SQL which was not restrictive enough ending up in a OOM....
Overview: What are Materialized views? A materialized view is a database object that holds a query’s results. It might be a local copy of distant data, a subset of a table’s rows and/or columns, the outcome of a join, or a summary produced by an aggregate function, for instance. What are the benefits of....
HANA SPS upgrade from HANA 2.0 Rev 37 to HANA 2.0 Rev 59 on the DR server when primary and secondary server setup as replication are present There are many environments and larger landscapes where we have cluster environment.But in this environment we have Primary DB replicated with the secondary DB where the primary system....
Hello World! Recently I worked on data-science challenges of my engineering team. During this work, I needed a way to persist a Pandas DataFrame (often known from Jupyter Notebook) in SAP HANA. In this blogpost, I want so share with you how this can be accomplished. The goal is to persist a Pandas DataFrame in....
I would like to share with you a project I’m starting. The aim of this project is to generate easily a documentation for HANA database module. Motivation One of the projects I was working on has a lot of calculated columns in its calculation views. Therefore I needed to deliver a proper documentation about these.....
1. Introduction This simple tutorial should give you an idea of how to extract the flat files from MS Sharepoint 365 to BW/4HANA. Many thanks to Andrei Paul Andreianu for co-authoring this blog! 2. Use-case Load the flat files from MS Sharepoint 365 to BW/4HANA. Store the Flat File changelog and snapshots in BW/4HANA. Enhance....
I am writing this blog to show training with APL using python package hana_ml. With APL, you can automate preprocessing to some extent. Environment Environment is as below. Python: 3.7.14(Google Colaboratory) HANA: Cloud Edition 2022.16 APL: 2209 Python packages and their versions. hana_ml: 2.14.22091801 pandas: 1.3.5 scikit-learn: 1.0.2 As for HANA Cloud, I activated scriptserver....
This blog provides general concepts for manually migrating from the on-premise database to the SAP HANA cloud. Begin with available paths for migrating the objects and explain each process step by step to do the migration manually using different methods. First, let’s introduce database migration, why should we do migration and how can we do....
The SAP HANA Cloud 2022 QRC3 release is happening. You can read about the major enhancements in Thomas Hammer’s blog post here. This post describes one of the features: the abstract-sounding “multi-environment” support. Part 2 describes how to get started with the multi-environment SAP HANA Cloud tools. With the 2022 QRC3 release in October 2022, SAP HANA Cloud....
The SAP HANA Cloud 2022 QRC3 release is happening. You can read about the major enhancements in Thomas Hammer’s blog post here. This post is the second of a pair that describe one of the features: “multi-environment” support. Part One tells you what SAP HANA Cloud “multi-environment” support means and sketches the benefits it brings you. This companion....
Hello, Developers/Architects/Managers Thank you for your overwhelming responses to my last post on SAP BTP Roadmap – “Developer is the KING” I got lots of queries from many of you regarding the certification in SAP BTP. And that’s a good sign, it’s the right time to upgrade your skill set in SAP. Like : “Partha, I’m....
Hope you are doing great!! And wishing you a very happy read. We see that AI is touching almost every corner and helping people in getting their job done easily. Yeah AI is trying to fill the gap of repetitive activities easily and providing helping hands to the users by giving them the exact....
Earlier this year the first version of the SAP HANA Database Explorer Visual Studio Code extension was released to the Visual Studio Code marketplace. You can find the features introduced in previous versions in my other blog posts. What’s New in the SAP HANA Database Explorer Visual Studio Code Extension Version 1.6 What’s New in the SAP HANA....
One of most common requirement in Hana is to move user defined table from one Hana environment to another (Ex: Dev > QA > Prod). Here is one of the method i.e. Export & Import we can use. Solution – Will migrate the Hana Table from Source Hana Environment to Target Hana Environment. Step 1 Export....
I am writing this post how we can combine AppGyver and SAP CAI together to achieve business goals. Let’s see how AppGyver can help in increasing the productivity in your day-2-day business activities – you can be so close to your relevant information which can improve decision making and off-course a fast way to take....
本ブログでは、Oracle データベースとSAP Data Warehouse Cloud (以下、「DWC」) とのデータ連携の設定について解説します。 Oracle とDWCの連携のシステム構成図は下記の通りです。 機能概要と設定手順解説 本Blogでは下記の動画にて設定方法をガイドします。 ※ 画面サイズを調整する場合は、再生時に画面右下に表示されるYouTubeロゴをクリックして別画面でご確認ください。 また、動画中に出てくる関連情報/補足情報を下記にまとめていますので併せてご確認ください。 関連情報 SAP Data Warehouse Cloud – データプロビジョニングエージェント接続の準備 SAP HANA Smart Data Integration – Oracle との連携 SAP Support Portal – DP Agent のソフトェアダウンロード SAP Development Tools – DP Agent のソフトウェアダウンロード SAP HANA Smart Data Integration – Product Availability Matrix (PAM)....
In this blog, we would like to explain HANA Installation and how to monitor the HANA Landscape systems using HANA Cockpit. In older HANA 1.0 SP12 by default cockpit was installed along with HANA Server but the newer version after HANA 2.0 SP01 higher SP level, we must install COCKPIT on a separate server to manage and....
As a follow-up to the blog post below, i will describe the specific configuration we tried with the following applications in depth and step by step. https://blogs.sap.com/2021/06/14/setup-multiple-identity-providers-for-sap-analytics-cloud/ The following applications were used to test the configuration. 1. SAP Identity Authentication Service – Act as IdP proxy 2. SAP Identity Authentication Service – Corporate IdP 3.....
Multiple Identity Providers for END2END SSO with SAP Analytics Cloud and SAP HANA Database – Part 1 https://blogs.sap.com/2022/09/30/multiple-identity-providers-for-end2end-sso-with-sap-analytics-cloud-and-sap-hana-database-part-1/ Live Data Connection with SAML SSO using Multiple IdPs In this scenario, we have two options to configure SAP HANA with SAML SSO Using IdP proxy to Multiple IdP Directly using IdP 1. Using ldP proxy to....
Interested to get SAP BTP certified? Here is a video tutorial series from the SAP HANA Academy to help you reach your goal. Get Certified – SAP HANA Cloud Development << this article Get Certified – SAP HANA Cloud Administration Get Certified – SAP BTP Extension Developer (Extension Suite) Get Certified – SAP Integration Suite Get....
In our previous blogs we created CFL enabled custom fields. Refer blog: “How to prepare and enable your existing custom fields in tables EBAN and EKPO and show on GUI” before going through below for better understanding. Here we will see – “How to enable BAPI to update the custom fields”. BAPI to be enabled – ‘BAPI_PO_CREATE1’....
Most the business model cost center or profit center are located in different country and with different currency profit and cost is generated. At the end of the year finance team try to calculate total cost or profit against a target currency(USD,EUR or different one) which is the headquarter of the company located to generate....
Knock knock! Anyone else also looking for handy illustrations of the hierarchy functions introduced with HANA 2.0? Well count me in then ;). While trying hard not to write SQLs with recursive self joins to flatten a hierarchical data format presented in parent-child relationship, the hierarchy functions in HANA can be a saviour for sure. Let’s....
Use Case – As a maintenance technician, I want to be able to see all the open , Closed , In progress , Completed and Archive notifications on a functional location so that I can check if the malfunction has already been reported. Inputs : • Plant (single value) • Functional location (single value) •....
In my previous blog posts, I wrote about the OGR driver for SAP HANA available in the most wide-used geospatial data processing software GDAL/OGR. I also wrote about how to build the software from the source on macOS. I got great news from our SAP HANA multi-model engineering team: now OGR driver for SAP HANA is included in OSGeo4W too!....
This is part 2 of my previous post about a tool that can query and bulk-provision various SAP Data Warehouse Cloud artifacts. The previous post can be found here: link. Since the last post, the Python tool has been published as a repository on the SAP-samples GitHub organization and is available for download. Please keep in....
Hello All, Hope everyone is doing great things and safe. Introduction In this blog, we will find the Step-by-Step procedure to perform the addition of custom fields to SAP Fiori Applications and an SAP GUI transaction through the Extensibility features provided by SAP S/4HANA. Example Scenario As we know that after system conversion, the code....
How can we leverage Python programming language in SAP infrastructure? – in multiple ways I must say. In this blog we will try to understand how we can establish connection with the database/s and how can we execute some basic queries. But why Python? Python is easy to learn, flexible, supports connectivity for almost....
This is a second blogpost about RybaFish Charts tool, If you never heard about the tool – please check the introduction article. The real power of RybaFish Charts is in custom KPIs. RybaFish supports three KPI types: regular, gantt and multiline. Today we are going to create regular KPI to track the memory consumption by a certain column....
This blog demonstrates a simple use of SAP Client for Python with SAP HANA HDI SQL APIs (stored procedures) in an on-premise SAP HANA Database. TL;DR: A simple example of a Python wrapper on top of the SAP HANA Client for Python (https://pypi.org/project/hdbcli/) is provided in the Git repository https://github.com/nklinked/hana-task-runner with one predefined example for containers deletion.....
わけあって、パラメータありCDS Viewが HANA上でどう生成されるかを確認しました。 パラメータありCDS Viewを定義します。DDICが生成される少し古いやり方です。 @AbapCatalog.sqlViewName: 'YSAPTEST00' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'Test CDS View with parameter' define view YSAP_Test00 with parameters aaa:abap.dats as select from t000 { $parameters.aaa as TEST } HANAのレイヤではこんなTable Functionが作られています。t-cd:SE11 からDDIC View詳細画面でユーティリティ -> データベースオブジェクト -> 照会で 確認。 CREATE FUNCTION "YSAPTEST00" ( "AAA" NVARCHAR(000008) ) RETURNS TABLE ( "TEST"....
Need to be able to select data in a CDS view where the records selected are less than 12 months old. This needs a comparison of a date field in the view with the system date less 12 months. The WHERE clause should look something like the following. Where row_date >= DATS_ADD_MONTHS ($session.system_date,-12,'UNCHANGED') The problem....
A big live style topic these days is finding the right balance, either your work-life balance or with yoga and mindfulness your inner balance. In Data Science this is not always so easy. There is quite often a natural imbalance, so we very often deal with such data sets. Let’s start at the beginning: What....
I once received a question to mark the production instance of a HANA Cloud Database in the database explorer. They wanted to have the exact same behavior as mentioned in this blog post, section “Visual Clues for Production Databases”: https://blogs.sap.com/2021/09/28/recent-innovations-in-the-sap-hana-database-explorer-q3-2021/ In the earlier on-premise HANA database and HANA Express version this was automatically available without....
Interested to get SAP BTP certified? Here is a video tutorial series from the SAP HANA Academy to help you reach your goal. Get Certified – SAP HANA Cloud Administration << this article Get Certified – SAP HANA Cloud Development Get Certified – SAP BTP Extension Developer (Extension Suite) Get Certified – SAP Integration Suite Get....
Being a BASIS consultant or a HANA administrator, we face situations several times where we have to connect DB with an application server. Although it is pretty much a straight forward process, but sometime a situation arises where this “NOT SO DIFFICULT” process throws errors at us. One such scenario that i faced was due....
Overview of the blog: Ever wondered how will you load data/file from your local machine into HANA Cloud, Data Lake without hesitation? Then you are at the right place. This blog will provide you a step-by-step guide as to how anyone can easily load data from their local machine to the HANA Cloud, Data Lake using Data Lake File....
Since integration topics are currently the talk of the town when it comes to SAP Profitability and Performance Management Cloud (SAP PaPM Cloud), it would just make sense to let the community know that one of the most popular data warehousing service that is: SAP Data Warehouse Cloud (SAP DWC) could be easily integrated to your SAP PaPM Cloud Tenant. If you’re curious....
The EarlyWatch Alert team has released a new feature to get a notification if there was no new SAP EarlyWatch Alert report generated in the last 14 days. In most cases, this happens because the SAP system has stopped collecting or sending analysis data to SAP. It is important to fix the underlying issue....
Sometime we have to divide two numbers in Hana Sql or in Hana views. If denominator comes as 0 there is no logic implemented handle 0 in denominator then Hana will throw Divide by 0 error during Query execution. Also this is good practice to handle denominator 0 case whenever we do any division in....
This tutorial will walk us through the end-to-end steps in SAP HANA capture and replay tool. What can I do with SAP HANA capture and replay? Capture and replay tool could capture the real workload from source SAP HANA system and replay the captured workload to a target SAP HANA system. Both source system and....
In continuation to my previous blog: Here. Let us now see if we can utilize Python for some of our real case scenarios. Data is an integral part of business growth and so is the availability of database and validity of backups. Monitoring Database backups and its validation is a part of routine job of SAP Basis....
There are tons of different ways how you can performance traces on SAC for troubleshooting. In this blog I will talk about one of the tracing methods called (TIMELINE TRACES) that can be very helpful when there are performance problems being observed in SAP Analytics cloud (SAC) regardless if the connection is with BW or....
Active/Active (Read Enabled) enables SAP HANA system replication to support read access on the secondary system. It reduces the load on the primary and has been available with SAP HANA 2 SPS00 to route SQL requests to the secondary system. Now with SAP HANA 2 SPS06, it is possible to route SAP HANA InformationAccess Service (or....
I am writing this blog post about Dynamic Joins in HANA. I found some blogs on Dynamic Join in HANA but they are confusing and did not give clear understanding what is exactly happening when we select Join as Inner join and then we make Dynamic Join as True. As of now just see the Picture....
I am writing this blog post on SAP HANA Input Parameters.There are few blogs on HANA IPs but they are not giving clear understanding. Here I am giving a basic example which will make the understanding easy for HANA developers. Those who are working on HANA for quite sometime and developed SAP HANA CVs they....
Hello Friends, I am writing this blog post on Calling a Table Function Inside a Stored Procedure OR Vice Versa in SAP HANA. As you all know scripted Calculation views are obsolete and Table function is the replacement for scripted CVs. in HANA 2.0 we have table function as a node too. Which means just....
In case you have missed the news: recently version 3.5 of GDAL has been released, which now includes an OGR database driver for SAP HANA in autoconf & cmake builds: https://gdal.org/drivers/vector/hana.html. This new functionality was contributed to the GDAL project by SAP HANA multi-model engineering team. The Geospatial Data Abstraction Library (GDAL) is an open-source computer software library for reading and writing raster and vector geospatial....
In the previous post “GDAL with SAP HANA driver: use it” I described examples of using some GDAL tools with SAP HANA. Here I will describe the steps it took me to build GDAL with SAP HANA driver on my MacBook laptop with Apple M1 (ARM-based) chip. The driver for SAP HANA is not included in....
As a Functional Consultant, one may wonder what a Role is and how different it is from the Authorization Object and Profile. While it is mostly the job of the Security team to assign the required Role for a user, it is also the Functional Consultant’s responsibility to provide inputs about the required Transactions, restrictions....
Transmission line repair GEF is integrated into SAP Plant Maintenance. GEF allows Plant Maintenance users to do their tasks using a map – regardless of whether the customer is running SAP ERP Central Component (ECC), SAP Business Suite powered by SAP HANA (Suite on HANA), or SAP S/4HANA. The benefits of geospatially enabled business processes....
As our customers adopt SAP Data Warehouse Cloud, we often need to help them set up new users for both training and productive use. This can be a significant administrative task when there are many users, spaces, connections, and shares needed for each user. NOTE: SAP provides the SAP Data Warehouse Cloud command line interface (CLI) for....
Hello Everyone, Welcome to the technical series of the SAP Transportation Management where we are aiming to learn basic codes that are used in SAP TM. Since, this blog post is continuation of the previous blog post, hence Please visit the below blog post if you have not gone through yet. Transportation Management : Read....
Sizing is an integral part of the SAP HANA migration process. Be it an SAP Business Suite on SAP HANA or an SAP S/4HANA conversion project. The first look of sizing is provided by the sizing report /SDF/HDB_SIZING. It is important to understand that the sizing report as per SAP Note 1872170 provides not only the output....
HANAで検証時によく使うSQL。たまにしか使わず、すぐ忘れるため、メモしておきます。 Select と Insert SOURCE_TABから抽出してそのままTARGET_TABへINSERT INSERT INTO TARGET_TABL( SELECT * from SOURCE_TAB) 大量データ挿入 大量データを挿入するときに使います。System View の objectsをクロスジョインすることで8000万件くらいまで挿入できます。項目は乱数を入れています。 ROW_NUMBER Function (Window) OBJECTS System View DROP TABLE "TEST_TAB"; CREATE COLUMN TABLE "TEST_TAB" ("Id" INTEGER, "fld001" INTEGER, "fld002" INTEGER, "fld003" INTEGER); insert into "TEST_TAB" ( select top 100000 CAST(ROW_NUMBER() OVER() AS INTEGER) AS "Id", round(rand(), 0,....
Hello Everyone, Welcome to the technical series of the SAP Transportation Management where we are aiming to learn basic codes that are used in SAP TM. In this blog post, we will learn how to get Default Route details from freight unit. The system considers default routes as possible routes for a shipment between two....
Hello Everyone, Welcome to the technical series of the SAP Transportation Management where we are aiming to learn basic codes that are used in SAP TM. In this blog post, we will learn how to get the freight settlement documents using query. Freight settlement documents are created to perform freight settlement with your suppliers or....
This blog shows an example application combining SAP AppGyver with the spatial engine of SAP HANA Cloud by making use of GeoServer on BTP as a middleware. Everything has been done on the free tier and can be replicated without involving any license costs. Fast Food Finder: Fill your belly with SAP AppGyver and SAP....
SAP HANA (HANA Cloud , HAAS ..) offers comprehensive functionality to safeguard your database i.e. SAP HANA offers automatic Backup to back up your database and ensure that it can be recovered speedily and with maximum business continuity even in cases of emergency. The recovery point objective (RPO) is no more than 15 minutes. A full backup....
This blog demonstrates an approach of collecting information about applications, service instances and other entities from SAP HANA Extended Application Services, Advanced Model (XSA) using XS Controller APIs. TL;DR: The blog provided an overview of a command-line tool that utilizes XS Controller APIs to simplify some of maintenance operations. The tool is based on a....
This Blog post will be very useful for Technical as well as functional consultant for preparing or providing technical specification and functional specification. With the help of this blog post you will be able to get External Calls, Database Operations, Internal Table Operations, Internal Objects performed on report without Debugging it. Solution : Get program....
SAP Cloud Connector serves as a link between SAP BTP applications and on-premise systems. Runs as on-premise agent in a secured network and provides control over on-premise systems and resources that can be accessed by cloud applications. In this blog, you will learn how to enable cloud connector for HANA Cloud Instance, install and configure the cloud....
This blog post is targeted to data enthusiasts/ data architects and those looking for privacy preservation of data in SAP applications like SAP S/4HANA based on SAP HANA Database. Introduction In 2019, when customers were still struggling with data privacy solutions available for application data, SAP Customer Engagement Initiative project, showed up with a promising....
Today am going to discuss about a very useful topic about exception aggregation in term of concepts and usage scenario in SAP Analytics Cloud, BW/BI and HANA. In all the Analytics reports or dashboards Key figures are shown in the aggregated level. But the main question is how the aggregation done and shown in the....
Hello there! I will not bother you with some enticing introduction anymore and get straight to the point. If you are: (a) Directed here because of my previous blog post SAP PaPM Cloud: Uploading Input Data Efficiently or; (b) Redirected here because of a quick Google search result or what not… Either way, you are curious on how....
One of the most important task during S4 Hana conversion is CVI integration. When functional consultants run report SAP readiness check for S4 Hana conversion. Usually MasterData BP error comes. SAP Readiness check In order to resolve this issue SAP has provided many tools tcodes and reports. In order to develop these tcodes SAP....
Some time ago I wrote about a way to quickly load data from CSV files into SAP HANA table using hana_ml Python package. It became quite a popular post. But it does require running some code to get a file loaded. Recently I was asked if that hana_ml functionality can be wrapped into some kind of UI and made available as an....
During S4 Hana conversion SUM sometimes give following error. SUM error In log file system was stuck at following place. SAPup> Starting subprocess with PID 26421 at 20211104101611 ENV: DIR_LIBRARY=/usr/sap/PRD/SUM/abap/bin ENV: LD_LIBRARY_PATH=/usr/sap/PRD/SUM/abap/bin:/usr/sap/PRD/SYS/exe/run:/usr/sap/PRD/SYS/exe/uc/linuxx86_64:/usr/sap/PRD/hdbclient ENV: PATH=/usr/sap/PRD/SUM/abap/bin:/home/prdadm/bin:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/sap/PRD/SYS/exe/uc/linuxx86_64:/usr/sap/PRD/SYS/exe/run:/home/prdadm:.:/usr/sap/PRD/hdbclient ENV: RSEC_SSFS_DATAPATH=/usr/sap/PRD/SYS/global/security/rsecssfs/data ENV: RSEC_SSFS_KEYPATH=/usr/sap/PRD/SYS/global/security/rsecssfs/key ENV: SAPSYSTEMNAME=PRD ENV: dbms_type=HDB *DBENV: dbs_hdb_schema=SAPABAP1 ENV: rsdb_ssfs_connect=0 *DBENV: (auth_shadow_upgrade) PWD: /usr/sap/PRD/SUM/abap/tmp EXECUTING /usr/sap/PRD/SUM/abap/bin/SAPCAR -cvrf /usr/sap/PRD/SUM/abap/log/SAPup_troubleticket.sar....
Earlier this year the first version of the SAP HANA Database Explorer Visual Studio Code extension was released to the Visual Studio Code marketplace. You can find the features introduced in previous versions in my other blog posts. What’s New in the SAP HANA Database Explorer Visual Studio Code Extension Version 1.5 What’s New in the SAP HANA....
If you are a ERP/NetWeaver system administrator, you will face many scenarios where you experience high resource utilization in the HANA DB. In order to correct these situations, you need to analyze the root cause of this load. This blog post will help you in the analysis process to find the root cause of the....
Refresh Scenarios With SAP Landscape Management (LaMa), Part 3: Using Backint Agents for AWS and GCP
This is part 3 of the blog series covering various options available in SAP Landscape Management (LaMa) to perform System/Database Refresh when using HANA as the database. Part 1: Refresh Scenarios With SAP Landscape Management (LaMa): Across Azure Regions and Subscriptions Part 2: Refresh Scenarios With SAP Landscape Management (LaMa): Across IaaS with LaMa SP21 (HANA Single Tenant Database....