SAP Datasphere: Seamless extraction of business insights in multi-cloud environments with HANA Machine Learning and FedML

This blog post describes how SAP Datasphere can be used to provide a seamless data science experience by facilitating the training of machine learning (ML) models on different platforms (e.g. using hana_ml in SAP HANA and using FedML on hypercaler landscapes). Furthermore, it shows how those ML models can work hand-in-hand to provide data-driven insights to business users without the need of expensive data replication and fully preserving the business context of the data. To illustrate the point, a real-life use case is reviewed and the selection of an ML runtime is discussed in the context of data gravity, availability of the required ML tools on the platform and business criticality of the data. The objective of this blog post is to provide a high level concept and consideration guidelines for data scientists and architects when working on similar multi-cloud cases.

SAP Commissions – Data Anonymization @ Database side

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 for statistical analysis, it must be protected to ensure privacy. Trivial modifications to the data like replacing information that directly identifies an individual such as name or social security number (pseudonymization) or simply removing the information is not enough. Re-identification is still possible, for example if additional information is obtained (referred to as a linkage attack).

RISE Migration with Tenant Copy Strategy

The most particular case about migration is the downtime, estimate the windows that customers need to achieve and perform a good project, but this not always happen and with the native HANA methodology of HANA System replication (HSR) we can mitigate some risk about Downtime, but as you well know to execute HSR is necessary to have the same SID in both HANA Nodes (and others prerequisites – help.sap.com – General prerequisites for HANA System replication),  when the customer already have the same SID of HEC/RISE is good because we review the others prerequisites and we can move forward but when the it cannot be completed we will face issues and the downtime is impacted.

One of this common scenarios is when a customer has already on HEC all infrastructure and wants to move on RISE Contract, if the SID of BD HANA for example is D01 On premise and RISE is D10 and 10TB of size in HANA DB and the Business windows is just 24hrs, in this scenario we cannot move with HSR and is when enter Tenant Replication (Copy / Move) , with this new feature in HANA DB we can move or copy a tenant in few hours (Depend of the bandwidth), for this case mentioned above is possible with good VPN of 100MB/s transfer the tenant to RISE in just 4 hours and later perform the finalize replica and startup the HANA DB in the new target (RISE), then we will proceed with the next steps in app server, post migration and deliver to RISE for post activities migration, we can explain in more details but first we need to fill the prerequisites:

S/4HANA 2022 What’s New – Target PSA in EWM with Automatic WT creation

Definition

The target production supply area (PSA) defines the production supply area of the next production step. It is used if a semifinished product remains in production and is needed for a subsequent production step.

Dependencies --> If the storage location, where the semifinished product is placed upon order confirmation or goods receipt, is not managed by the warehouse, the field is only for information character.

ssl connection from hana studio to sap hana DB

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.

Here are the steps we followed to establish a connection from SAP Hana Studio to the HANA DB.

1. Export the Hana server certificate using sapgenpse as per note 2475246.

Advanced Foreign Currency Valuation in S/4HANA Cloud (Cloud ERP)

Advanced Foreign Currency Valuation

Advanced Foreign Currency Valuation is part of Advanced Valuation in Financial Accounting. Advanced Valuations support you in following accounting standards, for example, IFRS9. The following processes are part of advanced valuation and are realized as job templates in the Schedule General Ledger Jobs app.

1. Post Discounting of Long-Term Assets and Liabilities

2. Advanced Foreign Currency Valuation

3. Post Credit-Risk Based Impairment

4. Post B/S Reclassification

Event Based Revenue Recognition – Sell from Stock (1K2)

The concept of this scope item is to help speeding the revenue recognition process in SAP S/4HANA Public Cloud.

The classic problem is that the revenue is not always recognised at the same time as COGS as the COGS is posted during Goods Issue to customer and then the revenue will be posted during the billing.

With this new feature of Event Based Revenue Recognition – Sell from Stock, system automatically posted the revenue adjustment at the time of Goods Issue (depends on the EBRR Key that you have selected but in this example, I will focus on the Revenue Recognition Key – SFS.

Field Status Variant in SAP

The purpose of this blogs to explain about the field status variant in SAP.

What is Field Status Variant?

Streamlining Process with SAP’s Mass Maintenance Order Confirmation: A Guide to Efficient Order Confirmation

Introduction:

In a manufacturing environment, maintenance orders are crucial to ensure the smooth operation of equipment and machinery. Tracking the progress of maintenance orders and confirming their completion is essential to maintain efficient operations. SAP Fiori provides a user-friendly interface that allows users to perform tasks quickly and easily, including the Mass Maintenance Orders and Operations tool. In this blog, we will discuss the steps involved in using this tool in SAP Fiori.

Steps:

The first step is to access the Create Maintenance Order app in SAP Fiori. You can do this by logging in to SAP Fiori Launchpad and searching for the app in the App Finder. Once you have found the app, click on it to open it.

Connect SAP Web Intelligence to HANA Cloud with just two steps

Yes, it is so easy to connect SAP Web Intelligence to an SAP HANA Cloud tenant into just two steps.

In this blog post, I want to share how we can work with SAP HANA Cloud and SAP Web Intelligence to create BI reports on HANA calculation views with a Step-by-Step approach.

I will split this blog post into two sections:

◉ Creating a OLAP connection to SAP HANA Cloud

◉ Consuming HANA Calculation Views from SAP HANA Cloud