Monday 29 November 2021

SAP & Dell Technologies – Transforming Data at the Edge, Cloud & Core

SAP & Dell Technologies, SAP HANA Exam Prep, SAP HANA Guides, SAP HANA Certification, SAP HANA Career, SAP HANA Tutorials and Materials

Organizations understand that, to thrive in the digital economy, they must derive better insights from the data they own — and do it in a more automated, reliable way. The faster this process, the faster the time to insights.

Friday 26 November 2021

Large-scale forecasting using HANA, APL and Node.js


Last year I became involved in a project for a retailer based in The Netherlands who had finished construction of a new distribution center. This new innovative DC is fully mechanized and is operated with a minimal amount of personnel, which is different from conventional distribution centers where sudden large order spikes are fulfilled by having more staff pick these orders in parallel. The automated nature of the machinery in this new DC means that the order picking process has a fixed capacity and cannot be scaled up easily by adding more personnel on the fly. In order to optimize its capacity, the DC will therefore also be performing tasks during quiet hours.

These tasks are derived from a forecast the client must supply to the DC controlling software. In practice a 7-day’s forecast needs to be provided to the DC on a daily basis.

Wednesday 24 November 2021

Linking Latitude and Longitude to Countries with SAP HANA Cloud

SAP HANA Exam, SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Career, SAP HANA Jobs

The actual solution of the question above is super-easy and comes down to a single select statement using a spatial join. So, the major part of this explanation will be about data import of the following files:

1. We need a dataset with global latitude and longitude data. On Kaggle there is a nice data set with Global Power Plants. This dataset already contains a country column, which we will of course ignore (otherwise the question above does not make much sense). Instead of this, you can also use your own dataset, where the problem statement makes more sense.

Monday 22 November 2021

New Message Monitors for Integration Experts and Administrators

Let’ start with the Message Monitoring for Integration Experts.

Message Monitoring for Integration Experts

In the Fiori launchpad, select the Message Monitoring for Integration Experts tile below the Message Monitoring space.

SAP HANA Exam, SAP HANA Certification, SAP HANA Learning, SAP HANA, SAP HANA Preparation, SAP HANA Skills, SAP ABAP Jobs

Saturday 20 November 2021

Integration of Plant Maintenance(PM) with Extended warehouse management (EWM) in S/4HANA 2021 Release

SAP scores over other ERPs’ on its integration capabilities between its modules / Business processes and applications. SAP’s default warehouse management solution EWM (Extended warehouse management) has strong integration with business processes like Order to cash (O2C), Procure to Pay (P2P), Production and Transportation. However, EWM was lacking in its capability to integrate with Maintenance processes till its S/4HANA 2020 release. This limitation of integration of Plant Maintenance (PM) order with EWM has been eliminated in S/4HANA 2021 release.

A typical process flow diagram for EWM – PM integration with delivery is depicted in below image.

Friday 19 November 2021

Estimating the costs of SAP HANA Cloud

SAP HANA Cloud offers organizations a lot of flexibility. Flexibility means that the price for SAP HANA Cloud varies according to your needs. Because SAP HANA Cloud is a service inside the SAP Business Technology Platform, it uses the same billing logic, which is based on capacity units. 

That’s why we’ve created an SAP HANA Cloud capacity unit calculator to help organizations make decisions about what they need to make the SAP HANA Cloud instances as robust as necessary. Let’s see how to get your price estimate:

1. To get started, go to the SAP Business Technology Platform Price Calculator.

2. From there, select SAP HANA Cloud as the service you want to estimate.

3. Click on the calculator icon to open the Capacity Unit Estimator.

Wednesday 17 November 2021

Enabling Dynamic Fiscal filtering in SAC (BW Live)

At time of writing, SAP Analytics Cloud (Q4, 2021.20) does offer dynamic calendar-based time filtering. This enables users to quickly analyse data for periods such as Current Year, Quarter and Month to Date. The same functionality is also exposed when working with SAP BW Live models containing a 0CALDAY dimension.

The limitation is that for BW Live models, the platform has no awareness of Fiscal / Financial periods. SAC offers no native mechanism to dynamically present common reporting scenarios such as Financial Year to Date, or even just Current Financial Year. All dynamic options Calendar based only.

Monday 15 November 2021

SAP BW*: Spotlight on HANA Transformations on ODP Sources

This blog post focuses on leveraging this Push-Down concept for ODP DataSources. As ODP is the key source system type for SAP data in BW/4HANA, most customers dealing with conversion projects will have to gain new expertise in this area. Here I would like to share some valuable lesson learned from customer projects.

Let´s assume, an in-place conversion goes roughly through following four phases:

1. The starting point are often legacy data flows, based on S-API interfaces, and maybe even with 3.x objects in combination with the RSA7 delta queue in the source system.

2. The evolution to ODP includes moving to the new Operational Delta Queue as replacement for the RSA7 predecessor.

Wednesday 10 November 2021

SAP Intelligent Robotic Process Automation Content in SAP S/4HANA Cloud 2111 – (Deep Dive)

In this blog, we will expand on the new capabilities with SAP Intelligent RPA latest innovations providing complete cloud experience, simple interactions for business power users and simple to test from browser.

Fast and cost-effective implementation and deployment of cloud studio based bots via pre-defined best practices SAP Intelligent RPA content, enables the Intelligent Enterprise for customers by driving business process improvements.

SAP S/4HANA Cloud, SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Learning, SAP HANA Career, SAP HANA Skills, SAP HANA Jobs
SAP Intelligent RPA 2.0

Monday 8 November 2021

7 Best Practices for Creating a High Availability Infrastructure

Cloud computing has revolutionized the way an IT company works in the present age. Without cloud power, many small and large organizations would have massive trouble conducting their functions and serving customers.

The cloud makes all hardware and software resources flexible, accessible, and efficient through its interface and features. But to avail this service productively, it needs to be working at all times.

With increasing demands for cloud computing services, companies rely on them fully to be stable whenever they are needed. Thus, any downtime for applications or services creates issues for the business and its customers. This is where high availability infrastructure comes in.

Saturday 6 November 2021

Top 10 Insights from the openSAP course “A First Step Towards SAP HANA Query Optimization”

I’m hoping that the title starting with ‘A First Step…’ implies that we will be continuing the journey with them with a second more detailed course.

Here are my top 10 interesting insights from the course, I hope this will entice you to go do the course yourselves. Here is the link to the course:

Wednesday 3 November 2021

What characterises the HANA SQL Data Warehouse?


As known from many articles and publications, SAP offers three solutions for data warehousing.

SAP HANA Exam Prep, BW SAP HANA Data Warehousing, SAP HANA Career, SAP HANA Tutorial and Materials, SAP HANA Guides, SAP HANA Certification, SAP HANA, SAP HANA Data Warehousing Foundation
SAP Data Warehouse Solutions (Source: SAP)

The SAP Business Warehouse (BW) was first published in 1997 and has therefore been a constant figure in the SAP Data Warehouse range for more than two decades. BW / 4 HANA as a HANA-optimized variant integrates the old ABAP world with the new SQL orientation of the SAP HANA platform.

Monday 1 November 2021

A Step-by-Step Blockchain Creation Tutorial for Beginners

Cryptocurrency trading remains the latest trend in the financial sector. As a digital stepping stone to decentralization, it has piqued people’s interest. The true crypto believers have proliferated over the years despite the skepticism. As such, its global expansion continues amidst the economic downturn. 

In the world of cryptocurrency, blockchain is one of the fundamental components. Blockchain keeps everything intact and organized. To ensure your success in crypto trading, you must know how to create or at least navigate blockchain. Hence, we will discuss the basics of a blockchain and how to create your own from scratch. 

What is Blockchain?

Blockchain is a broad concept in the financial world. In the cryptocurrency market, it is a digital network across independent databases. As such, it enables widespread financial decentralization. In essence, it is simply a digital ledger that accounts for all crypto transactions. According to Coinjournal, its name Blockchain makes sense, it is composed of blocks of codes chained together and arranged chronologically.