Wednesday 29 September 2021

Cascading Filter Prompts in SAP HANA Modelling

Cascading filters are a group of prompts where the selection of one filter regulates the list of values accessible for selection in the successive filters. The key intention for this cascading is to make sure a better user experience by providing users with valid combinations of input parameter values. This feature is liked by many customers as it allows them to have a preview of their data through prompts before essentially seeing the information.

For Instance: We have two filter prompts for our HANA calculation view Country and State filter, So if we select India as country in our first prompt so we’ll automatically get only states of India in list of values like below:

Friday 24 September 2021

SAP IBP Order Based Integration Architecture Real Time Integration (RTI)

SAP Integrated Business Planning for Supply Chain (SAP IBP) is one of the fast growing planning tool across the various industries. IBP application offers five core modules which are tightly integrated to achieve one business model within the organization.

It eliminates the silos in the planning process. During the COVID-19 pandemic most of the organizations effects with supply chain disruptions and companies are learning from the COVID-19 impact and trying to build the best supply chain planning process across the organization to support current and future disruptions.

Now coming to importance of this blog post to provide the update on latest innovation from SAP IBP production development team with regards to integration between SAP Order Based Planning (OBP) with SAP and Non-SAP systems integration.

Thursday 23 September 2021

Mapping Risk in a Stormwater Network using SAP HANA Spatial and Graph

In this blog post I will show how to estimate the water load in a stormwater network and calculate the risk of an overload. Sure, I’m not a water network expert, but here is the idea: a stormwater network is a directed, (in our case mostly acyclic) graph made up of a set of edges/pipes and vertices/junctions. For each vertex we can calculate the catchment area, i.e. the area from which rain water most likely will enter the network via that vertex. Each vertex then propagates the load to its downstream network. By looking at the ratio of the pipe’s load and cross-section, we can estimate the overload risk for each pipe.

SAP HANA Spatial, SAP HANA Graph, SAP HANA Exam Prep, SAP HANA Certification, SAP HANA Tutorial and Materials, SAP HANA Career, SAP HANA Preparation

Wednesday 22 September 2021

Employee Integration to Business Partner without HCM


To use Some Fiori apps are required to have the employees ID or employee business partner integrated with the user ID to use the app such as Manage Purchasing Categories (F0337). This post shows how to create an employee business partner without integrating HCM using Fiori App Maintain Employees (F2288A). We can use Fiori app Maintain Employees (F2288A) to create employee data. With this app, we can integrate the business partner with the user ID. when we create employee data using the app Maintain Employees, the system will automatically create business partner data BUP003 role. Later on, you can modify your employee data using T-Code BP or Fiori app Maintain Employees.

Tuesday 21 September 2021

Upcoming Workshop: Collaborative Database Development in SAP HANA Cloud

Collaboration is the key to successful database development. And as part of our Virtual Data and Analytics Forum, which began last week, we’ll be holding a special workshop session on Collaborative Database Development in SAP HANA Cloud, HANA Database.

This workshop will use hands-on sessions to guide participants through a number of important tasks, from changing data structures and automating application deployment to setting up template projects for use by your colleagues. SAP HANA Cloud’s flexible data management capabilities will be on full display.

Monday 20 September 2021

Boost performance of SAP Analytics Cloud tables by using proper styling techniques

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Guides, SAP HANA Career, SAP HANA Tutorial and Material, SAP HANA Preparation, SAP HANA Study Materials

Does styling of my SAC table cause performance drawbacks?

In fact, every story designer can try out whether sophisticated styling is a performance driver of a table widget. Do the following to test whether performance issues of your table widget is caused by filthy formatting: Measure the performance of your table widget with styling and without styling and compare results. To remove all styling definitions of the table widget we can make use of table templates (figure 1) – switching the table template will prompt the story designer to eventually delete all styling definitions (figure 2) previously applied. In other words, styling will be reset after selecting a predefined template. Thereupon, we can use the refresh button at the toolbar to measure performance of the table widget without any applied styling. In case the table loads quicker without any formatting applied, this can be interpreted as a strong hint that previously applied styling definitions cause performance issues.

Friday 17 September 2021

Gain first hands on experience with the new automated S/4HANA deployment in Microsoft Azure

Try out the new SAP S/4HANA 2020 FPS02 production-ready deployment in Microsoft Azure with the quick and easy approach of SAP Cloud Appliance Library ( SAP CAL). It applies to standards aligned by SAP and Microsoft and follows their best practice.

We are looking for customers and partners who want to register and share their feedback with us before end of November 2021. Our target group are SAP System administrators with access to Microsoft Azure.

The deployed system allows for integration into Landscape Management Cloud to leverage its possibilities for system operations. The deployment itself will also soon be part of a comprehensive integration with Software Logistics Toolset starting with system design in maintenance planner, running the installation and offering an integration with SAP Software Upgrade Manager and notes implementation.

Wednesday 15 September 2021

How-to Review and Set SAP HANA Parameters Following Updated Recommendations

I have always found myself in below situations during my career as consultant for SAP HANA specifically in projects for implementation, migrations/upgrades, and even daily operation:

1. SAP HANA Parameters setup during initial installation, following SAP best practice or recommended value(s).

2. Review HANA Parameters of existing systems in case of HANA Support Pack Stacks or HANA Revision update.

It could be of company own systems, managing systems for customers, or from migration project taking over from other vendors.

Monday 13 September 2021

Dynamic OData from “any” API through SAP BTP Kyma

SAP HANA Exam Prep, SAP HANA Learning, SAP HANA Tutorial and Material, SAP HANA Guides, SAP HANA Career

Greetings! Today we will be bridging 3rd-party and SAP applications easily with the help of SAP BTP Kyma runtime. Let’s go! 🏃

Sunday 12 September 2021

Editable field selection in Verify Data Flow App

In this Blog, I will provide information you the information regarding how to visible editable field in Verify Data Flow App.

Verify Data Flow

We can use this component to post documents in Financial Accounting (FI) via a correction layer and suspense postings. We transfer documents from source systems into Financial Accounting. In these documents, there can be errors in the header or in the line-item data, for example, an incorrect company code or an incorrect balance. To perform these checks and automatically correct errors before posting, you can use the functions of Error Correction and Suspense Accounting (ECS).

Saturday 11 September 2021

Hands-On Tutorial: Script and deploy Python with the new Jupyter operator in SAP Data Intelligence

The new Jupyter operator brings interactive Python Notebooks into your SAP Data Intelligence pipelines. Script your notebook directly in the pipeline and deploy exactly the same notebook and pipeline into production. No need to script in one place and to copy / paste the code into a Python operator.

Learn how to use the operator with a Machine Learning example, that forecasts multiple time-series in SAP HANA using the embedded Automated Predictive Library.

With Python you can implement a million things, other than Machine Learning by the way. Data retrieval or data preparation or just two further uses cases.

Friday 10 September 2021

Using Multiple Identity Providers in SAP HANA Cloud Administration Tooling

Recently, we introduced support for multiple identity providers (IdPs) in the SAP HANA Cloud administration tools (SAP HANA Cloud Central, SAP HANA cockpit, and SAP HANA database explorer). The benefit of using a custom IdP is that SAP HANA Cloud users can now be authenticated by their company’s IdP, as opposed to authentication via SAP ID Service. An identity provider creates and manages an organization’s user identity and associated identity attributes. With the user’s consent, IdPs offer authentication services to websites, applications, and other services by federating the identity and authenticating an end-user to the service provider using the identity the IdP manages, but without sharing actual login details. The basic mechanism of using custom IdP is as follows:

Thursday 9 September 2021

Pre-built Workflow Content to Handle Credit Memo Request in SAP S/4HANA

SAP Workflow Management enables the digitalization of workflows, decision management, and visibility on end-to-end business processes (SAP & non-SAP). It empowers business experts to configure new process variations in an LCNC (low-code/no-code) approach and provides business users with SAP Fiori-based user interfaces.

With SAP Workflow Management, our customer gets access to pre-built process content templates/samples across applications. A workflow content package can include re-usable workflow models, decision logic, dashboards to monitor the process, user interfaces, and integration flows to connect with the backend system. This enables our customers to import such templates, change them as per their requirements, and run the process in a limited time.

Wednesday 8 September 2021

NSE: Systematically Measure Memory Savings

This guide will show a methodical approach to finding data with a large memory footprint and calculating the memory storage savings after moving them to disk via Native Storage Extension. The TPC-H dataset is used in this guide.


◉ Reader has access to a provisioned SAP HANA instance SPS04+

◉ Reader has familiarity with Database Explorer, SAP HANA Cockpit, and HANA System Views

Monday 6 September 2021

Cloud Integration (SAP CPI) – API_CV_ATTACHMENT_SRV (OData API for attachments)


Recently I faced a use case in which a integration flow needed to add an attachment to a supplier invoice, we have standard OData/SOAP API to perform operations like create, read, rename, and deletion of attachments, In this blog I’m going to discuss adding (creating) an attachment to supplier invoice by consuming OData API.


1. Before consuming the OData API make sure that API_CV_ATTACHMENT_SRV oData API is active ,system client ID and alias name maintained.

2. Check the entity list and make sure “AttachmentContentSet” entity set is present to create an attachment.

Saturday 4 September 2021

Near Zero Downtime Maintenance

Maintenance windows for SAP systems can be very limited because companies cannot afford extended downtimes since some of these systems are really key to production, for example the Supply Chain Management or the Customer Relationship Management among others,

Any SAP Basis, OS and Infrastructure engineer knows how challenging it can be to finish successfully and in time a maintenance on the SAP servers of the company and besides if it is for production hosts they should be carried out outside business hours which is an added effort.

Another challenge the IT departments need to deal with quite often when it comes to the SAP estate is to get the buy from the business so that the servers can be kept up to date regularly with all the recommendations from SAP notes, security fixes, patches, etc. Many times they get push-back because the users cannot afford too regular maintenance windows and the systems risk becoming not compliant or vulnerable.

Thursday 2 September 2021

SAP’s Data Warehouse Strategy for Healthcare Providers

In this blog post, I am going to present SAP’s latest strategic statement of direction for data warehousing and show the consequences for typical health care providing companies. The goal is to establish a common understanding of requirements and to show a way forward for healthcare companies on their way to become intelligent enterprises and data driven companies. With this, you will get clarity and confidence for future investments in the BI field.

Requirements and Challenges

Time To Value: Fast development and deployment cycles are key for healthcare companies to react to changing environments and new challenges. Self-service capabilities like modelling in non-tech business languages or a common business catalog describing the data foster the collaboration of business and IT and help to accelerate BI projects.