Comparative Analysis of Data Selection Techniques in SAP

In SAP systems, selecting the right data extraction method plays a pivotal role in ensuring system efficiency and performance. With vast amounts of data stored in SAP databases, it's essential to choose the right method for data retrieval, especially to keep operations responsive and well-optimized.

In this article, we will explore various SAP data selection techniques such as the Open Cursor, Core Data Services (CDS) views, Database views, and some other advanced strategies. Each has its strengths and weaknesses and understanding them will help you determine the best fit for your specific use case.

HANA Calculation View - Division by Zero Error

A short post on the fix for the Division by Zero error due to expressions in HANA calculation views

In SQL, a division by zero error occurs when an expression attempts to divide a number by zero, leading to execution failures. In HANA, this can disrupt calculations within your views, especially when working with dynamic datasets where divisor values may be unpredictable.

The Calculated column is a feature in the calculation view that helps modelers insert information based on the other columns from the data sources.

How to Connect S4HANA Public Cloud With SAP Datasphere

Introduction:

After reading this article you will be able to establish a connection between SAP S4HANA Public Cloud with SAP Datasphere Public Cloud

Benefits:

You will be able to replicate data from S4HANA Public Cloud to SAP Datasphere Public Cloud

What is SAP Approuter and its importance?

Introduction

SAP Approuter is a lightweight service, which acts as a single point of entry for various back-end services and applications in SAP ecosystem. In many SAP cloud foundry enterprise applications, Approuter plays an essential role in tying together different pieces of the application landscape and ensuring smooth user experience. In this blog, I am going to share my learning on Approuter and its usage.

What is SAP Approuter

SAP Approuter is a Node.js library used as a single point-of-entry to an enterprise application. The Approuter is used to serve static content, authenticate users, rewrite URLs, and forward or proxy requests to other micro services while propagating user information.

SAC Content Transport (Migration) Using CTMS

Different ways to transport SAC Content

SAC Provides three ways to transport your content from one tenant to another,

File System mode - In this method, using the menu option Transport > Export > File System, you create a package of your SAC content & its dependencies and download it to your local system in a .tgz file format, and import this .tgz file in your destination environment using the menu option Transport > Import > File System. This option is as simple as downloading from one location and uploading to another location.

Coupa Adapter for SAP Integration Suite

We are happy to announce that Cloud Integration introduced a Coupa adapter this month. For those customers using Coupa, the Coupa adapter for SAP Integration Suite is the ideal solution to enable a fast and robust adoption of Coupa in your business.

You can now seamlessly integrate data from diverse sources into the Coupa spend management platform and elevate your organization’s efficiency by reducing efforts to create a listed set of integration workflows with the Coupa adapter.

RISE with SAP: Multi-layer Defense in Depth Architecture of SAP S/4HANA Cloud, Private Edition

Introduction: The SAP S/4HANA Cloud, Private Edition is at the core of “RISE with SAP” offering which holds customer’s mission critical data and business processes. SAP Enterprise Cloud Services (ECS) provides a managed private environment with multi-layer defense in depth architecture handling infrastructure and technical managed services. This includes end-to-end SLA for the full solution stacks and a proven security architecture, minimizing risk for our customers. Multi-layer security requires security to be handled at people, process and technology levels. In this blog, we will discuss high level multi-layer "defense in depth" architecture offered to customers. For the sake of simplicity, only high level and abstracted approach is presented.

Approach to Multi-Layer Defense in Depth Architecture:

SAP S/4HANA Cloud, Private Edition is a “single tenanted” managed private environment for customers where SAP creates a separate account (AWS) or subscription (Azure) or project (GCP) for each customer. The applications and database virtual instances are solely dedicated to a single customer. Security by Design and Security by Default are deeply embedded into the multi-layer architecture.

What Is SAP HANA Streaming Analytics?

SAP HANA streaming analytics enables you to analyze high-volume, high-velocity data event streams to extract data. This post will introduce you to SAP HANA streaming analytics fundamentals.

Let’s get started with some basic information. Events are messages that are sent when something happens, for example, a stock price went up or a plane landed (too early, too late, or on time). Internet of Things (IoT) devices constantly send out messages, often in different formats, making processing these messages and generating alerts for exceptions difficult. Especially for the most interesting events (exceptions), the goal is to store this information in the database for further analysis to identify patterns, detect problems, and predict trends.

Testing SAP S/4HANA Cloud Implementations

To accelerate testing activities, SAP S/4HANA Cloud comes with a test automation tool, detailed test scripts, and prepackaged standard automated tests (called test automates) for most business processes.

The test automation tool and test automates are ready to run as part of SAP S/4HANA Cloud and can be used without prior automation tool experience. The tool offers a simplified way to develop custom test automates to achieve automated testing for specific customizations of business processes. Considering the delivery pace of SAP S/4HANA Cloud, SAP extends support for automated testing by triggering tests in SAP S/4HANA Cloud customer quality tenants with each upgrade using the tool called the post upgrade test. Furthermore, while the test automation tool is native to SAP S/4HANA Cloud, you can also use this tool with SAP Cloud ALM.

Exploring ML Explainability in SAP HANA PAL – Classification and Regression

1. Introduction

In this blog post, we will delve into the concept of Machine Learning (ML) Explainability in SAP HANA Predictive Analysis Library (PAL) and showcase how HANA PAL has seamlessly integrated this feature into various classification and regression algorithms, providing an effective tool for understanding predictive modeling. ML explainability are integral to achieving SAP's ethical AI goals, ensuring fairness, transparency, and trustworthiness in AI systems.

Upon completing this article, your key takeaways will be:

• An understanding of the concept of ML Explainability.
• How to utilize HANA PAL for ML Explainability in classification and regression tasks.
• Hands-on experience with Python Machine Learning Client for SAP HANA (hana-ml) through an example.

SAP Cloud Integration Manage Artifacts Of Design Time

Introduction:

In cloud integration, the processes of creating, deleting, or modifying a flow are done manually by entering the package. I will show how to perform these processes through the CPI link. The aim of this blog is to highlight the flexible structure of CPI.

Required:

◉ SAP BTP and Integration Suite 

Cloud Integration Steps:

To demonstrate how all the processes work, I have covered them all in a single flow. This includes flow deletion, updating, creation, and the information we can retrieve related to the flow.

Remote Monitoring of HANA Database from Solman

As I find many SAP HANA databases wrongly configured in Solman for efficient, I felt there's a need to publish the steps I follow for the benefit of many.

#Note All the screenshots are taken by me from my internal system 

1. Install DBSL Libraries for remote monitoring of HANA DB

If Solman and the target database are on different databases, install HANA DBSL libraries on solman host for data collection.

Grant System Privileges Like Export Or Import Into A (Hdi) Hana Deployment Container

In order to get the system privileges someone has to give them to your HDI container. This are the steps you have to follow to get them into the container. In this a sample the IMPORT/EXPORT privileges could be given.

1. [optional] A user with DBA-ADMIN role creates a usergroup  [HELP] such as "HDI_CONTAINER_RIGHTS"

Either use the HANA Cloud Central to create a USERGROUP

How to enhance the Focused Build Post-Cutover Activities

Introduction

The Focused Build standalone extension 'Cutover Checks and Post Cutover Activities' was introduced several years ago. Besides the Cutover Checks it also provides a set of activities to ensure seamless synchronization of changes between implementation and corresponding maintenance landscapes. Users can create and import Transports of Copies (ToCs) for each system within the maintenance landscape directly from the cutover system.

ST-OST SP13 has brought improvements to these activities. Nonetheless, it can still happen that an activity does not meet your requirements fully or lacks a particular feature. In such situations, users can easily develop and integrate their own activities to enhance or replace the existing ones.

Syniti RDG provides a simplified design to create Multi Value Validation and Derivation Rules

Syniti RDG is an SAP-endorsed application on the Business Technology Platform (SAP BTP) to facilitate MDG implementation with intuitive UI and process automation. RDG automates many of the technical configuration steps that are required to implement SAP MDG and it offers a user-friendly interface to be more relatable to business users.

◉ A multi-value check rule is for validating multiple attribute values against a logical condition.

◉ A multi value derivation rule is to derive multiple attributes values based on a logical condition.

The below example is used to create Multi value validation to be triggered for a specific Change Request Type to validate attribute values of Entity ‘BP_CENTRL’ of data model ‘BP’.

Import Data Connection to SAP S/4HANA in SAP Analytics Cloud: Technical Configuration

In this blog we’ll discuss complete steps for Import data connection from S/4 hana on-premise system to SAP Analytics Cloud. The Operating system we are using on which S/4 Hana system is installed is SUSE Linux SP 15.

Here, Our Data source is S/4 Hana from which the SAP Analytics Cloud is connected using the SAP Analytics Cloud Agent and SAP Cloud Connector.

Developing & Deploying the UI5 App to Cloud Foundry and Accessing from App-router End-to-End Steps

In this Blog I am going to explain the minimal steps required to setup App router, HTML5 Deployer for the UI5 application to be able to develop and deploy the application to Cloud Foundry Space. We are going to setup destination and consume the same in the UI5 application using App Router.Before Getting started Let's understand the architecture to access the application from Cloud Foundry Space -

Empowering Retail Business with a Seamless Data Migration to SAP S/4HANA

I’m happy to find time to start SAP blogging. In the dynamic realm of retail, transitioning to SAP S/4HANA is a pivotal move towards enhancing operational efficiency and competitiveness. Central to this transition is the intricate process of data migration, particularly concerning master data. With its criticality underscored, ensuring the accuracy and governance of SAP master data becomes paramount. This brief explores the fundamental importance of data management in retail's seamless migration to SAP S/4HANA, highlighting key strategies for success.

Implementing SAP ERP hinges greatly on managing data, especially master data, as SAP ERP relies heavily on it. Data migration remains the most critical aspect of this process, carrying the highest risk. If your SAP master data lacks accuracy and governance, you may encounter significant challenges.

Nested JSON to SAP HANA Tables with SAP Integration Suite

In this blog post, I will demonstrate how to send data to SAP HANA Cloud using the Integration Suite. Additionally, I will explain how to handle nested JSON data and distribute it across multiple tables utilizing parallel multicast and mapping functions.

Problem Statement:

We have exposed an API endpoint through which we push data in JSON format and in response we get the insert count in particular tables. The input data contains user details and role details in nested form. We are supposed to insert the user details in User Table whereas in the User-Role mapping table for each role associated with a user, we ensure the creation of a corresponding entry, linking the user's details with their roles. Our requirement is to process the JSON data via CPI and populate these two tables.

Workload in the SAP HANA

Options for Managing Workload

Workload management can be configured at multiple levels: at the operating system-level, by using global initialization settings, and at the session level.

There are a number of things you can do to influence how workload is handled:

• Outside the SAP HANA system on the operating system level you can set the affinity of the available cores.
• You can apply static settings using parameters to configure execution, memory management and peak load situations.
• You can influence workload dynamically at system runtime by defining workload classes.

All of these options have default settings which are applied during the HANA installation. These general-purpose settings may provide you with perfectly acceptable performance in which case the workload management features described here may not be necessary.