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

Importing Entities with Semantic of CDS views from S/4HANA On-Premise in SAP Datasphere

Introduction

This blog will explain the details of accessing the CDS views from S/4HANA On-Premise in SAP Datasphere with semantics. This feature helps accessing the data from ERP system with business context and logic intact through CDS views. 

Prerequisite

SAP S/4 HANA version should be 2021, or newer with SAP_BASIS Release 756 or newer. The below note has all the prerequisites in detail

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.

Embedded Analytics Architecture and Integration

SAP S/4HANA Embedded Analytics Architecture and Integration

 

SAP S/4 HANA Embedded Analytics architecture comprises of 4 layers, namely

1. Persistency layer
2. Modeling layer
3. Access layer
4. Visualization layer

In this blog I will be emphasizing more on persistency and modeling layer.

Configuring Standard API in S/4 HANA Cloud

Generating OData of standard API:

First we have to login to SAP business accelerator hub account and go to SAP S/4 HANA Cloud Public edition.

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.