Friday 29 March 2024

Efficient Memory Storage and Data Loading of SAP HANA Column Tables

Memory storage and Computing Power are fundamental blocks of Cloud Platforms and Infrastructure. The abundance of Memory storage and cost-effective computing power has ensured a lower baseline for cloud adoption. However, anything in excess without considering its consequences can corrupt our practices. I see a similar pattern with the cloud data models.

In SAP HANA, we replicate data predominantly from SAP systems through tables and CDS. Data replicated for tables may range from 1000s or rows to millions of records per month. The queries that join multiple tables without optimal selection of columns and filter conditions can consume the working memory resources. Eventually, despite the promise of infinite data and computing capacity(CC), the reality is there is a finite amount of memory and CC.

Wednesday 27 March 2024

Connect & Visualize: SAP Datasphere with Qlik Sense

In this Blog, We'll explore how to consume data from SAP Datasphere through ODBC (Open Database Connectivity) and Visualize the data in Qlik Sense which is one of the leading Data Visualization Tools.

Why SAP Datasphere over others?

SAP Datasphere allows seamless connectivity with a wide range of data sources, including on-premises and cloud-based systems. SAP Datasphere is designed to handle large volumes of data efficiently, making it suitable for organizations of all sizes, from small businesses to large enterprises. Its scalable architecture ensures optimal performance even as data volumes grow over time. Graphical low-code/no-code tools to support self-service modeling needs for business users. It has Powerful built-in SQL and data flow editors for sophisticated modeling and data transformation needs.

Friday 22 March 2024

An overview of XSA commands for beginners


In this article I'll try to explain the expected outcome of XSA commands when executed in Linux environment via command line (xs cli). This blog is aimed at helping understand the xs commands. At first, I also faced the similar dilemma of how XS command works and what is expected outcome. So learning by my experience, sharing most commonly used commands which you can easily use to understand and monitor xs too.


1. OS level access via <sid>adm on HANA DB host

2. User credentials of xsa_admin

Wednesday 20 March 2024

Updating an SAP HANA System Landscape - Overview

Updating an SAP HANA System Landscape - Overview

Revision Update

1. Support Packages (SPS) Update
2. Version Upgrade – SAP HANA 1.0 to SAP HANA 2.0

SAP HANA system components like,

  • SAP HANA Database
  • SAP HANA client
  • SAP HANA studio

Additional system components like,

Friday 15 March 2024

Effectively adopting Recurring Service process from S/4 HANA Service Management into your business

Regular maintenance aids in maintaining a customer's assets at their best performance levels while reducing the likelihood of breakdowns and the costs associated with repairs.

Our preventive maintenance solution, designed to sustain customer assets, facilitates consistent production by mitigating unexpected breakdowns. This solution creates and executes orders at specified intervals/usage, drastically improving asset production efficiency and minimizing breakdowns. Notably, this solution also reduces maintenance costs and contributes to recurring service revenues for customers. It adeptly manages both commercial aspects through service orders, as per the service contract, and technical aspects through execution orders.

There are different types of Maintenance Plans, namely: Single cycle plans based on time or performance, strategy plans, or multiple counter maintenance plans that are implemented on need basis . Once you create a maintenance plan, you can schedule the plan to generate call objects when the system is due for maintenance.

Wednesday 13 March 2024

How to attach documents to a Journal Entry within SAP S/4HANA Public Cloud from ABAP


In this blog, we describe a method to attach document files to a Journal Entry (BKPF) instance within the same SAP S/4HANA Public Cloud  using ABAP.

How to attach documents to a Journal Entry within SAP S/4HANA Public Cloud from ABAP.

This requires us to expose and consume the Attachment API as described in the SAP Business Accelerator HUB - Attachments.
I believe this blog can be very useful since existing documentation primarily focuses on exposing the services, but we encounter conceptual problems when consuming them locally.

Monday 11 March 2024

SAP IQ NLS-The Cold Storage Solution for SAP BW/4HANA

Introduction –

As we know B systems contain a large volume of data that is only accessed rarely. The data is either never or rarely needed in Data Warehouse processes or for analysis. The main challenge of implementing a multi-temperature memory strategy is to seamlessly integrate the warm and cold memory areas and to make these areas invisible to the outside, in order to ensure that all required functions are applied to this data. SAP offers various solutions, which help to reduce TCO SAP IQ NLS is one of them to reduce load by cold data 

Friday 8 March 2024

Protecting Your SAP HANA Cloud and SAP HANA with Credential Rotation Best Practices

In today's cyber-threat landscape, prioritizing data security is more important than ever. Security is one of the key cornerstones of SAP BTP and SAP HANA Cloud strategies. 

SAP HANA Cloud takes a comprehensive approach to security, providing a layered defense system encompassing authentication, authorization, encryption, and auditing. 

At the heart of this security strategy lies strong credentials management practices, one of which is the credentials rotation. For example, organizations can significantly reduce the risk of unauthorized access and data breaches by enforcing regular password rotation.

Wednesday 6 March 2024

Global Explanation Capabilities in SAP HANA Machine Learning

Machine learning (ML) has great potential for improving products and services across various industries. However, the explainability of ML models is crucial for their widespread adoption. First, explanation helps build trust and transparency between the users and the models. When users understand how ML model works, they are more likely to trust its results. Moreover, explainability allows for better debugging of complex models. By providing explanations for models’ decisions, researchers can gain insights into the underlying patterns, which helps identify potential biases or flaws. Furthermore, the explainability of models enables auditing, a prerequisite for its usage in regulated industries, such as finance and healthcare.

Monday 4 March 2024

Create sales order automatic extraction -Maximize the value of SAP Business AI for SAP S/4HANA

SAP has released several prebuilt AI use cases in each of the process area. These are referred to as Basic AI providing out-of-the-box solutions. The base for this is of course SAP S/4HANA.

Create sales order automatic extraction -Maximize the value of SAP Business AI for SAP S/4HANA

The graphic above provides a rough summary of what is available.

Friday 1 March 2024

Clone SAP HANA Database Instance via Template based cloning

The cloning template essentially serves as a database backup, encompassing the schema and data of the clone while excluding its configuration details, such as the options chosen during provisioning. It's important to note that restoring a backup from a more recent SAP HANA version into an older version is not supported and results in an error.

Clone SAP HANA Database Instance via Template based cloning

Cloning templates are stored in a template container within HANA Data Lake Files, specifically in the Files service of the data lake. To create a cloning template, and to create an instance based on a template, your subaccount must therefore have a data lake Files service; note, however, only data lake Files is required — without the additional option of the data lake relational engine.