Tuesday 31 March 2020

SAP S/4 HANA On-Prem Fiori Business Roles Activation

Starting with SAP S/4HANA 1809 FPS00 and SAP S/4HANA 1709 FPS01, SAP has introduced Rapid Activation methodology for its on-premise deployments. This methodology helps companies cut efforts required to activate business content.  Using this methodology companies can activate business content in much reduced time than before.

In this blog, I am going to cover one primary aspect of this activation process.  I will provide details on Fiori Content activation for Business roles. By activating business roles through this process activates all apps associated to the selected business roles including ICF nodes and ODATA Services.

Monday 30 March 2020

Series Data in SAP HANA

When we collect data at a measurable interval such as time, the data is called series data. Analysis of series data allows you to draw meaningful conclusions and predictions from the patterns and trends present in the values.  Examples of time series are sensor data generated by IoT, weather station, daily closing value of the stock ticker etc.

Series table operations are performed like column table operations with a few features to consider.

SQL statements

SERIES clause of the CREATE COLUMN TABLE statements which support both equidistant and non-equidistant data

Friday 27 March 2020

Consume Qualtrics survey results in SAP Analytics Cloud with live connection to SAP HANA service

More than ever businesses around the world are recognizing the importance of treating their customers and employees like ‘real’ people and not “users”, “buyers” , “resources”et al. Welcome to the experience economy! It is time everyone understands the importance of experience management and the powerful outcome and business value generated through the insights obtained by combining X-data and O-data.

SAP offers some powerful solutions to enable such an experience economy. SAP Business Technology Platform at the core and center helps businesses in by connecting X-data from Qualtrics and O-data from various SAP Line of Business services together. SAP Analytics cloud is the go-to analytical solution offering on the platform, that can be leveraged for data-driven insights connecting O-Data from  Line of Businesses to X-Data from Qualtrics, enabling decisions that create “people experiences”

Wednesday 25 March 2020

SAP HANA Persistent Memory using IBM’s vPMEM – Configuration

In my last blog, I highlighted different Persistent Memory approach for SAP HANA by different vendors – Intel & IBM. But now in this blog, I will elaborate on the configuration steps that needs to be followed in order for SAP HANA database to use IBM’s vPMEM.

But before that, I would like to highlight Technology Overview of Persistent Memory and followed by IBM’s adoption of Virtual Persistent Memory (vPMEM)

Tuesday 24 March 2020

Security and DPP Law compliance in Investigative Case Management for SAP S/4HANA


Investigative Case Management (ICM) is now available on SAP S/4HANA since 1909 FPS00 release.

Data Protection and Privacy

ICM provides specific features and functions to support compliance with the relevant legal requirements and data protection and privacy.

Monday 23 March 2020

Simplification with quality inspection in embedded Extended warehouse management (EWM) in S/4HANA 1909 release

Extended warehouse management (EWM) was embedded within S/4HANA in 1610 release, however it was not possible to use ‘Inspection types’ of QM (Quality management) module of S/4HANA core for the quality inspections with warehouse operations through EWM. Inspection rules had to be defined in EWM (T code : /SCWM/QRSETUP) for creation of ‘Inspection lot’. The ‘Inspection type’ or  Inspection rule’ determines how an inspection is to be carried out.

Sunday 22 March 2020

SAP HANA, Enterprise Edition for SAP S/4HANA

You’ve just made the decision to move to SAP S/4HANA, the intelligent ERP system. Now the question stands: go live with SAP HANA, runtime edition, or upgrade to SAP HANA, enterprise edition?

For some context, SAP S/4HANA is optimized to run on the column-based, in-memory database, SAP HANA. You have the option to go live with SAP HANA, runtime edition, or SAP HANA, enterprise edition to fully unleash the capabilities of SAP S/4HANA.

Friday 20 March 2020

Asset Legacy Data Migration in New Assets Accounting (S/4 HANA 1909) – Current year Acquisition Scenario Techno-Functional Solution


In FICO Asset Legacy Data Migration in New Asset Accounting, the procedure is explained below for current year acquisition scenario. Both the Functional and Technical Solutions along with the sample report for BAPI are explained in detail.

Thursday 19 March 2020

Wednesday 18 March 2020

Access SAP ERP data from SAP HANA through SDI ABAP Adapter

Do you want to use data residing in SAP ERP for analytics or machine learning?

SAP offers several options to extract data residing in ABAP-based systems. We will explore one of these options in this blog : SAP HANA smart data integration (SDI). SDI provides tools to access source data and provision, replicate, and transform that data in SAP HANA on-premise or in the cloud. You can efficiently connect to many sources to provision and cleanse data for loading into SAP HANA. For supported systems, you can also write back from HANA to the original source.

In this blog, we will set up the ABAP Adapter for a real time data replication from SAP ERP to SAP HANA as a Service.

Tuesday 17 March 2020

Dynamic tiering and Extended tables

What is dynamic tiering?

Let me begin by telling you what is dynamic tiering.

SAP HANA dynamic tiering is a native big data solution for SAP HANA. Dynamic tiering adds smart, disk-based extended storage to your SAP HANA database. Dynamic tiering enhances SAP HANA with large volume, warm data management capability. When you use SAP HANA to place hot data in SAP HANA in-memory tables, and warm data in extended tables, highest value data remains in memory, and cooler less-valuable data is saved to the extended store. The extended store can reduce the size of your in-memory database.

Monday 16 March 2020

Code-to-Data Paradigm in ABAP with SAP HANA

I have started learning ABAP with SAP HANA and I understand that Code pushdown is nothing new, It’s just “new” for many ABAP developers. So I want to share my exploration on this.

Traditional ABAP coding Style:

In traditional ABAP coding, it’s a standard practice to limit the number of hits to the database by bringing data as much as possible to the application server and then performing the operations on it to produce the desired output. Even though retrieving a large amount of data from a database is time-consuming.

Saturday 14 March 2020

Removing Duplicates while fetching Data from Multiple tables in SAP HANA Modelling


While we try to pass data from one table to other in SAP HANA Modelling, there is a possibility for data duplication to occur. In my case, as per the requirement of my customer I wanted to calculate pipeline stock based on order quantity from EKPO table and delivered quantity from MATDOC table. As the data came from these two tables, when we passed data from one table to other table, data duplication occurred. In this blog post, I have discussed the solution for this problem.

Friday 13 March 2020

Installing HANA Express 2.0 and XSA: Installation

Remember from our deployment options discussion that our objective is to have a fully functioning SAP HANA instance available over the internet while being hosted in the cloud. In this post we’ll walk through the necessary installation steps for native Linux deployments on AWS.

Wednesday 11 March 2020

Stored Procedure to identify dependent/ reference/ consumed modelling objects across the system


I worked on a migration project where we are supposed to create a new system and migrate few specific models from one system to another. The challenge faced is to identify dependencies and end-to-end flow of models created in the system.

In HANA, Data is consumed from different systems in the form of different objects.

Monday 9 March 2020

Partition Pruning in SAP HANA 2.0: Managing Sliding Window

An important partitioning strategy to improve performance is to match partitions wherever possible with the most frequently queried data so that data pruning is possible.

Partition pruning takes place automatically in the background and tries to eliminate any unnecessary partition from the selection which is not essential for the query result. If your partition schema are designed to support this, pruning can avoid accessing and loading into memory partitions which are not required which reduces the overall load on the system and improve memory usage. The classic use case for effective pruning is where date-based partitions are used. For example, if a table is partitioned by day, month or year, a query restricted to the data of a specific date period is executed only on the partition with data for the selected date period.

Saturday 7 March 2020

Sorting dynamically using Label Columns in Power BI using Hana Calculation Views


There may be certain situations where we would need the Axis labels in Charts to be sorted Alphabetically or sort as per the requirement of Customer. This is not possible to be done directly over the Row labels. So, in this blog post I have discussed the workaround for this problem.

Friday 6 March 2020

SAP Analytics Cloud: Publication based on SAP HANA live connection

In this blog, I will guide you through the additional configuration steps you need to perform to enable the scheduling of publications of stories that are based on an SAP HANA live connection.

Configure on-premise SAP HANA system in SAPCP Cloud Connector

Connectivity between SAP Analytics Cloud and your on-premise SAP HANA system will be handled through the SAP Cloud Connector.

Wednesday 4 March 2020

Best experience: Creation of HANA Indexes part II


1. Starting with indexes (part I)
2. Limitations (part I)
3. SAP recommendations (part I)
4. Evaluate expensive statements (part I)
5. Analyzing the system
6. Performance comparison
7. Tools

Monday 2 March 2020

Best experience: Creation of HANA Indexes part I

May be some of you know that it is a myth that HANA needs no indexes. Every primary key in an ABAP system has a single index on each column. If for example a primary key is created on columns MANDT, BELNR and POSNR, implicit single column indexes are created on column MANDT, on column BELNR and on column POSNR.