Basis Engineers’ Ultimate Guide for SAP Debugging

I think that every Basis engineer and SAP developer will agree with me when I say:

It can be REALLY painful to find the root cause of an issue in a complex SAP system.

Salesforce.com adapter for SAP SDI: replication of Salesforce data into HANA tables.

1. Overview

The Advantco SFDC adapter is an adapter for SAP HANA Smart Data Integration (SDI), its purpose is to batch load or to replicate changed data in real time from Salesforce.com to the SAP HANA tables.

This blog describes in detail how to replicate Account data from Salesforce.com in HANA tables.

Using Busines Data for Better IT Outcomes

SAP IT Operations Analytics (SAP ITOA) brings a lot of value to IT organizations:

• Embedded Predictive Analytics makes it easy to anticipate and respond to issues before they happen
• Realtime monitoring and alerting lets IT respond immediately when issues do occur
• A holistic view helps simplify root-cause analysis and reduce meantime to resolution

Smart Data Streaming: Guaranteed Delivery Part 1

It’s common for streaming projects to use guaranteed delivery, or GD, which is a delivery mechanism that ensures all of the data going into a project, and all of the data processed by a project, reaches its destination – even if the client somehow becomes disconnected when the data is produced. Using log stores and checkpoints, GD works with streams, windows, as well as SDK publishers and subscribers, to prevent data loss.

Successful implementation of Cumulative Sum in SAP HANA

A cumulative sum is a sequence of partial sums of a given sequence. For example, the cumulative sums of the sequence {a, b, c, ...} are a, a+b, a+b+c, .....Cumulative sums.

Cumulative Sum: Cumulative sums, or running totals, are used to display the total sum of data as it grows with time (or any other series or progression). This lets you view the total contribution so far of a given measure against time.

Step by step how to create a local SAP HANA connection with Analysis for Office 2.x

Create HANA local connection to an SAP HANA server with Analysis for Office 2.x version it easier and simple to configure. A local SAP HANA connection is created in the Select Data Source dialog.

With right click on the “select data source” you will be able to create the connection as you can see on the below images. Before create the connection you need a specific configuration that you can see below:

How to Subscribe to SAP Product Support “SAP HANA” WhatsApp Broadcast List

The new SAP Product Support “SAP HANA” WhatsApp Broadcast List is now available for SAP customers.  SAP customers can get the latest and most relevant SAP HANA updates.

Here are the instructions to subscribe to the list:

1. From your mobile device, click here to access to the Product Support “SAP HANA” broadcast list subscribe link. Make sure to have WhatsApp downloaded to your device.

2. After clicking on the subscribe URL, you will see below widget. Click on the WhatsApp box in the widget as shown here.

Core Data Services [CDS] in SAP S/4 HANA

A data model represents framework of what relationships are in a database. Data models are the foundation of software development. They provide a standardized method for defining and formatting database contents consistently across systems, enabling different applications to share the same data.
Professional data modeling tools provide a way to generate SQL from a modeled ER diagram although some developers often prefer writing SQL directly. Below is a look of a data model.
​

SAP HANA Security: Granting Object Privileges with Repository Roles

This blog explains how to use the SAP HANA Web-Based Development Workbench to grant object privileges with repository roles in SAP HANA.

SAP HANA Web-Based Development Workbench

The SAP HANA Web-Based Development Workbench editor, hosted within the XS engine, provides an interface that you can use to build and test development artifacts. From a security perspective, we can use this interface to create and manage repository-based roles. This interface offers all the advantages of repository-based roles without the need to define those roles using scripts. The interface is not exclusive, meaning that you can edit repository-based roles created using scripts with the GUI interface, and you can edit a repository-based role’s scripts, those created using a GUI, in SAP HANA Studio. This flexibility allows the security administrator to manage the repository role using either interface.

Migrating the SHINE Purchase Order Worklist Application from SAP HANA XS Classic to SAP HANA XS Advanced.

Prerequisites

To perform a migration you need to be aware of the files that are not supported by the migration assistant und migrate them manually in advance. How to do this manual step, is described in the official documentation.

Prepare the XS classic source system.