Wednesday, 30 September 2020

Reduction of Disk Size by Packed LOB Container

Summary

On the purpose of prevent further increasing of LOB entries on table /AIF/PERS_XML, the deletion strategy was carried out on the production system. After the records, which is out of data retention, had been deleted, the number of LOBs on table /AIF/PERS_XML had reduced accordingly; However, the disk size of packed LOB container had never been reduced. This issue had brought the following concerns:

Monday, 28 September 2020

Driving Adoption of New Innovation SAP MaxAttention Services

In this blog, you will learn about some great innovation ideas and insights that you can leverage to address your business needs and requirements and achieve valuable business outcomes and experiences in a number of different solution areas.

Friday, 25 September 2020

SAP HANA Enterprise Cloud Vs SAP Cloud Platform Vs SAP HANA Cloud

In this blog post, I am trying to bring 3 different concepts with SAP cloud offering and demonstrate how these are different from other. First, we will discuss about SAP HANA Enterprise cloud and then narrow down to discuss about SAP HANA Cloud platform to understand about cloud foundry environment and then we will further narrow down to understand SAP HANA Cloud database features and new innovations.

Thursday, 24 September 2020

Single Sign-On with SAP HANA Scale-out System using Kerberos and Microsoft Active Directory

Preamble: Being an SAP technology consultant, throughout my career I have been getting so many helps from the contents written by the experts of SAP Community , hence I thought this is the pay-back time.

If you are well aware of the architecture of SAP HANA Platform and Kerberos , then needless to say this SSO works for a SAP HANA Scale-out system as well. But when I had implemented it for a customer , I found it hard to find any relevant documentation that could’ve supported my understanding and made my life bit easy. So, as I dealt with it already ,here I am with this blog , that will depict the exact configuration steps for the aforesaid to move forward.

Wednesday, 23 September 2020

Proximity Placement Groups in Azure : Testing the Impact on Query Performance in HANA

Network Latency in SAP Environments:

Network latency is a very important metric to be measured, which has a direct impact on runtime of jobs or transactions run by users. Many SAP applications ( custom and standard ) run queries as part of application logic which requires multiple round-trips to database sometimes based on the program design. Examples could be a SELECT … UPTO 1 ROWS in a loop etc.

A slight increase in latency can multiply as the number of times the loop is run and fetching records from database. During a migration of SAP to a IaaS or on-premise provider,  it is difficult to identify these changes from an application level if the change is very insignificant per record, however it can multiply many fold if the logic is run in a loop.

Monday, 21 September 2020

How to find HANA disk size,memory size,record count,memory usage of COLUMN TABLES in HANA

Simple but Important commands in HANA DB on M_TABLE_PERSISTENCE_STATISTICS Vs M_TABLES Vs M_CS_TABLES


A. Different use cases of using M_TABLE_PERSISTENCE_STATISTICS

1. Wanted to find the disk size of your HANA DB

select sum((disk_size)/1024/1024/1024) from m_table_persistence_statistics;

Saturday, 19 September 2020

Establish a live connection with SAP Analytics Cloud from SAP Cloud Platform- Cloud Foundry

I have described the end-to-end steps it takes to establish a live data connectivity between SAP Analytics Cloud and SAP Cloud Platform HANA database which runs on Neo Platform.

But now that the SAP Cloud Platform runs on Cloud Foundry – a few steps in the process would change as well as some new steps needs to performed.

Friday, 18 September 2020

Office Check-In App using Cloud Apllication Programming Model and React.js

 SAP has always helped its customer to run their best. And in this pandemic situation it is no different.

Bearing that in mind, we, from the Brazilian Presales Platform & Technology team, proudly developed an application that controls office access as an effort for a safe return to normality. It is a very simple application, which its source code will be distributed freely to customers. The goal of this app is to ensure that the office always respects its available capacity and employees are able to perform social distancing, in a very simplified manner and at an extremely low cost of implementation. The application flow is demonstrated on the picture below:

Wednesday, 16 September 2020

Altering HANA behavior during peak load via ADMISSION CONTROL

Altering HANA behavior at peak load using Admission Control in HANA 2.0


Below are the details which helps us understand how HANA 2.0 uses admission control to handle higher system load in a simple question and answer format. Hope it helps!

NOTE:You might not be able to find some of system views (M_ADMISSION_CONTROL_*) specified here if you are not in HANA 2.0 SP05 , though HANA 2.0 has a default admission control enabled.

Monday, 14 September 2020

S/4HANA in 5 minutes or less – Interaction between CO and FI

During the last S/4HANA conversions, which I was fortunate enough to accompany, it became particularly apparent that, in addition to the technological challenges and the adaptation of new functions, the cooperation between departments had to be adapted, sometimes drastically.

One of the most popular challenges was the need to bring internal accounting (CO) and financial accounting (FI) closer together. Here, the responsibilities were reassigned with every S/4HANA transformation I know of.

Friday, 11 September 2020

Connect MS-Excel to SAP HANA Database/Analysis in excel with HANA data

SAP HANA is a high-performance in-memory database that accelerates data-driven, real-time decision-making and actions and supports all workloads with the broadest advanced analytics on multi-model data, on premise and in the cloud. We all know that the HANA is a database technology which provides data to the users very fast.

On the other hand, MS Excel is one of the most widely used data representation, analysis and reporting software of all time and still it is one of the most important software used throughout the world.

Wednesday, 9 September 2020

SAP HANA Sizing Essentials – A quick guide to HANA Sizing for license calculation

1. Overview and conciderations


A proper HANA Sizing is important for any customer who wants to switch to SAP HANA as platform to run the SAP Business Suite or SAP Business Warehouse. It is mandatory for calculating the SAP license for Enterprise Edition (in-memory metric based) and it is as well important to assure the optimal performance of SAP HANA.

Whereas the SAP HANA memory requirement is most important for the license calculation there is also a sizing for CPU cores, disk space and network load which are important for the expected performance of the HANA-System. In this article we concentrate on the HANA-in-momory sizing.

Tuesday, 8 September 2020

How-to Master Data Planning in SAP BW/4HANA

Introduction


In a BW project a typical requirement is that business wants to change or enrich Master Data. Until now this was mostly done with customized solutions like having a special aDSO working as control table with a class for master data update or doing it in the BPC Master Data Administration. Since BW/4HANA 1.0 SP 08 there is a simple solution available, which I will show in a short use case.

Monday, 7 September 2020

How to analyze S/4HANA tables with proxy objects

Since we, the BI folks need to deal with ERP quite a bit, it is also sometimes handy to understand how things are structured “out there”. So, this writing is about proxy-objects / replacement views and associated topics. I will do it based on two examples that came from real-life questions so we can generalize afterwards.

First and foremost, we are dealing with a “new” ERP now, which is called S/4HANA. You may ask me now why is this important? Well, because that has changed things for us (BW folks) under the hood. To illustrate it I have made a GIF out of a slide that has been ever presented on a TechEd, wherein it is visible per area which of the tables lost their original importance and have been at least partially replaced by something.

Friday, 4 September 2020

Import large flat files into SAP HANA using Python and SQLAlchemy

Introduction


SAP HANA provides and supports various capabilities for data integration and data provisioning to realize lots of different integration scenarios. However, there are also certain scenarios in which you just want to load data from local flat files once, without putting effort in setting up a proper data integration landscape.

As part of my daily work with SAP HANA, this requirement usually pops up when working on demos, proof of concepts or performance/load tests. In such cases, I sometimes receive large flat files with the data I need to load into SAP HANA.

Wednesday, 2 September 2020

SAPS/4 HANA 1809: End to End Implementation of customized workflow for Bank Account Management

Introduction:


During recent changes (SAP S/4 HANA 1709 onward) SAP has moved the Bank Account Management (BAM) to Fiori Application known as ‘Manage Bank Accounts’. SAP has provided step by step configuration guide for Cash Management which covers the basic configurations and to trigger the standard WF associated with it.