Friday, 29 September 2023

BW/4HANA Security: SAP BW/4HANA Migration (Remote Conversion)

Introduction


SAP BW/4HANA is a next generation data warehouse solution developed by SAP. The underlying foundation of SAP BW/4HANA is the SAP HANA in-memory database, which means that the data is stored and processed in the main memory of the server resulting faster data retrieval, processing, and analytics compared to traditional disk-based databases.

SAP BW/4HANA simplifies data modeling, enables real-time analytics, and supports integration with advanced technologies like big data and machine learning. It helps organizations consolidate, manage, and analyze large volumes of data, providing timely insights for data-driven decision-making.

Monday, 25 September 2023

Calculation View In SAP HANA

Introduction


SAP HANA, or “High-Performance Analytic Appliance,” refers to a database management system and application platform that uses in-memory technology. SAP HANA is a well-liked option for businesses looking to speed up their decision-making processes because it is built to manage enormous volumes of data and perform real-time data processing and analytics.

First, let’s see what’s a view in general

A view is a kind of imaginary table that will have the results linked to the SQL statement. Note that the data from the SQL query need not come from a common database table.

Saturday, 23 September 2023

Detecting Implausible User-Entered Weighing Notes using Data Science with an SAP S/4HANA (On-Premise) System

After connecting an SAP S/4HANA System with Python and Jupyter Notebook using an ODBC driver we can now work with the data we retrieved.

In the world of data science, detecting anomalies and errors is an essential task. In this blog, we will explore a data science project (from my practical phase in my dual curriculum) focusing on detecting implausible, manually-entered weighing notes where for example the weighing unit was mixed up.  These anomalies can have significant consequences in inventory, billing, or logistics.

Friday, 22 September 2023

How to use Smart Data Integration Replication Task to get delta from SAP Analytics Cloud to HANA

Motivation


This blog is about how to use Replication Task in Smart Data Integration to replicate data from SAC to your on premise HANA.  You can replicate SAC planning transaction data not only with delta but also only full. The full load also applies to the analytic models in SAC. We will focus on delta in this blog.

Some customers have chosen this way as an implementation and like the flexibility in HANA replication task like filters, monitor and field mapping from SAC models to HANA DB tables. The others especially in S/4 HANA have concerns or restriction in company policies not to access the HANA DB level thus using SDI directly on HANA DB is no go for them. I would like to hear your feedback what are your preferred way for this integration.

Wednesday, 20 September 2023

Migration Monitor (FINS_MIG_STATUS) – How to analyze errors and information and recommend possible solutions.

As Part of the conversion process to S/4HANA, the migration monitor (FINS_MIG_STATUS) is responsible for coordinating the migration of Finance data into the new S/4HANA data model. To access details about a data migration run, click the Overview tab and see the list of activities and their respective statuses.

Incomplete steps or those with errors are displayed with a red status. The data migration process stops, preventing any subsequent tasks from being executed by the system. To continue with the migration, it is critical to fix the errors found in these tasks. The omission of this activity will delay the migration process.

Friday, 8 September 2023

Deadlock issue Analysis

Introduction:


The problem is the Database dead lock that occurred on every week at particular day and time in the production environment. Due to this database deadlock issue, the system would halt the background process, the users would not able to login into the system and would not able to process any document creation or change in the production system. The database table lock entries are being created spontaneously without releasing lock entries. For instance, within the short span of time more than 600k entries are created. So, there is no system resources free to process the rest of the operation/process.

Wednesday, 6 September 2023

[MDG-F]: New hierarchy upload modes for file upload

From a long time hierarchy restructuring process in MDG-F has been tedious and time consuming and customers have requested SAP to provide better way to handle the overall hierarchy restructuring process. With the customer connection program for MDG 2023 SAP has provided new options in file upload to restructure the hierarchies.

CURRENT CHALLENGES


Customers with bigger hierarchies >75~100K nodes, restructuring has been always been challenging since the file upload application goes for timeout or memory issues. It happens as the only option currently to restructure is to use “Delete ALL” mode while using file upload and the system takes a lot of time to delete the entire hierarchy and re-create the new one. For customers where hierarchies are re-structured multiple times during a year, the file upload process creates a bottleneck in their operations.

In this blog post we will cover basic details of these upload modes.

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

INTRODUCTION


The new hierarchy upload modes are released with the note 3258404, this note is applicable from S/4 HANA 1809 onwards. The 3 new modes introduced are listed below:

1. Replace nodes -> For each uploaded edge in the file, the system deletes all direct children of the edge’s parent node and creates only the children specified in the upload file. The sequence of the children from the file is considered. This mode could also be used to simply change the sequence of nodes without applying other changes.
2. Move children-> For each uploaded edge in the file, the system checks whether the child of that edge also exists under different nodes within the same hierarchy and removes it from those. Then, this child is placed under the new parent as the last object.
3. Remove Edges-> For each uploaded edge in the file, the system deletes such edge in the system if it exists. There will be a warning if it does not exist.

MAIN CONTENT


1. In the file upload application, the upload mode now has these 3 additional options when the type of transfer is “Hierarchies”.

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

2. Let’s take an example of a sample CC hierarchy and see how each upload mode works.

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

3. MOVE CHILDREN: Now we want to move CC1_YK cost centre under group PARIS, to JAPAN. Here we will use move children option since we want to just move one of the children of a node to a different node.

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

4. REPLACE NODES: Lets’ say we want to reorder the CC groups, currently PARIS is first and then JAPAN. But in the new hierarchy structure we need to move JAPAN to top and then PARIS, then we will use replace node.

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

5. REMOVE EDGES: Now suppose we want to remove CG121212 from the below hierarchy then we upload the file with remove edges option

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

SAP HANA, SAP HANA Career, SAP HANA Learning, SAP HANA Guides, SAP HANA Certification, SAP HANA Preparation

Saturday, 2 September 2023

saptune 3.1 on the Horizon

In a few weeks saptune 3.1 will reach the public repositories of SLES for SAP Applications. Time to talk about the changes and new features.

As always saptune 3.1 will be released for all Service Packs still in support, namely:

  • SUSE Linux Enterprise Server for SAP Applications 12 SP5
  • SUSE Linux Enterprise Server for SAP Applications 15 SP1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2
  • SUSE Linux Enterprise Server for SAP Applications 15 SP3
  • SUSE Linux Enterprise Server for SAP Applications 15 SP4
  • SUSE Linux Enterprise Server for SAP Applications 15 SP5