Friday 18 February 2022

SAP Analytics Classification algorithm: Predict the potential profits of marketing campaigns

Profiling the client’s attributes that influences the positive response to sales

Classification is one of the Machine Learning algorithms of SAP Analytics cloud to find what are the variables that have more influence to get a positive result.  Based on this information we can calculate what is the maximum profit of a marketing campaign. The algorithm takes past information and evaluates the results to give how good is the data to do predictions.

We are going to train the Classification process with the data of a past marketing campaign to know the possible effectiveness percentage of a campaign based on:

Monday 14 February 2022

Forecasting Intermittent Time Series with Automated Predictive (APL)

Starting with version 2203 of the Automated Predictive Library (APL) intermittent time series are given a special treatment. When the target value has many zeros, typically when the demand for a product or a service is sporadic, APL will no longer put in competition various forecasting models, but it will systematically use the Single Exponential Smoothing (SES) technique.

For SAP Analytics Cloud users, this functionality is coming with the 2022.Q2 QRC release in May.

Let’s take the following monthly quantity as an example.

Friday 11 February 2022

Move data FAST from an SAP HANA Cloud database to a HANA Data Lake

If you’ve ever been stuck wondering how you can move data from your SAP HANA Cloud database to your SAP HANA Data Lake with minimal effort, this is for you. In fact, it might be the fastest way to move your data depending on your data lake’s configuration. Plus, it’s simple enough that a single Python function can do all the work for you!

This blog will outline how you can leverage remote servers in the data lake to make a connection to your HANA database and pull the data from HANA to data lake. I also experiment with different data lake configurations to see what parameters affect the speed of this data transfer the most, that way you know how to scale your data lake instance to achieve the best performance.

Thursday 10 February 2022

Reduce SAP HANA Memory Footprint and TCO of SAP HANA with NSE

Efficient Data Management strategy is important for SAP HANA customers to achieve low TCO (Total cost of ownership) and maintain memory footprint.

SAP HANA Data growth comes with its associated challenges and leave customers in Dilemma about the actionable to manage the growth, TCO and performance as depicted in below graph

SAP HANA Exam Prep, SAP HANA Career, SAP HANA Learning, SAP HANA Prep, SAP HANA Preparation, SAP HANA Guides

Wednesday 9 February 2022

Can data modeling be enhanced by incorporating business knowledge?

If the answer is yes, then in what extent and how?

In this blog post we will try to answer the question by approaching a real-life scenario. We will discuss the challenges related to high amounts of data and the resulting processing times if the access to that data is not optimally planned and the structure of the data is not designed in a proper way. Finally, we will see how business knowledge about the scenario will provide information about the data modelling, which will boost the performance significantly.

Wednesday 2 February 2022

Presales capability in SAP S/4HANA


This blog post provides an overview of SAP S/4HANA On Premise (and PCE) Presales Management features (or Sales Force Support – don’t get confused with a 3rd party “SaleForce” solution).

It is not a secret that SAP S/4HANA architects’ strategic goal is to build a comprehensive core ERP solution which may also contain capabilities from other formerly standalone SAP applications. One of those is CRM functionality coming from the good old SAP CRM 7.0.

Historically, SAP offered its “classic” SAP CRM solution which has been evolving over years from version 3.0 to its final 7.0 EHP4. SAP CRM 7.0 is a part of SAP Business Suite 7 for which SAP is going to provide mainstream maintenance until the end of 2027 with optional extended maintenance until the end of 2030 (according to official announcement made on Feb 04, 2020). However, no major improvements will be delivered for SAP CRM 7.0.

Tuesday 1 February 2022

External HANA view configuration in BW4HANA


SAP Introduced new functionality from BW 7.4 on HANA where we can generate HANA view directly from B4HANA and BW on HANA application during BW object activation, The external HANA view enables to create scenarios where data, which is modeled in the BW system, are merged with data modeled in SAP HANA with SAP HANA tools.

This document will provide you an overview of the external HANA view configuration from the SAP BASIS point of view.