Wednesday 29 April 2020

SAP HANA Cloud Overview Webcast Summary

Overview of latest HANA product released to the market

How can you use it?

What are the use cases?

Features, benefits

Tuesday 28 April 2020

Create graphs on SAP HANA Cloud

Start there to learn how to create your own SAP HANA cloud instance and develop with SAP Web IDE Full-Stack.

Our goal is to create a graph workspace that represents routes travelled between airports by different airlines.

Monday 27 April 2020

Extending the Migration Cockpit “Material” Object with EXTENSIONIN for Subscription Data Fields


The requirement is to mass load new material master records of material type SUBS (Subscription Product) into a greenfield implementation of SAP S/4 BRIM (Billing and Revenue Innovation Management). The SAP S/4 Migration Cockpit is being used; however, the “Material” migration object does not include the Subscription Data fields: Billing Cycle, Billing Cycle Determ, and Assignment Schema.

Sunday 26 April 2020

Code Pushdown

As we know when we move to a HANA database the idea is to go pull on for “code pushdown”.

SAP HANA Study Materials, SAP HANA Certification, SAP HANA Guides, SAP HANA Exam Prep

The bottleneck for performance has traditionally been moving records between the database and the application server.

Saturday 25 April 2020

SAP Fiori for SAP S/4HANA – Adaptation Transport Organizer

This blog post is a summary of detail steps for setting up Adaptation Transport Organizer, which is a pre-requisite for using in-app extensibility.

In-app extensibility covers the most common changes most customers need to make to their SAP S/4HANA solution, including:

Friday 24 April 2020

Transferring data from On-Premise SAP HANA to SAP HANA Cloud using SDI


In this blog, I will transfer data from On-Premise SAP HANA to SAP HANA Cloud using SDI (Smart Data Integration).

SAP HANA Cloud includes SDI which is an ETL tool, this means that you can easily integrate various kinds of source systems into SAP HANA Cloud without installing ETL application. Moreover, you can develop ETL jobs as same as developing tables and views, this makes it easy and quick to develop ETL jobs.

Thursday 23 April 2020

Part 1: How to Create Dynamic Images in SAP Analytics Cloud Story


In SAP Analytics Cloud, we can add static images or dynamic images (stored in a remote database Ex: SAP HANA) to a Story.


To create a dynamic image, you will need a model based on a HANA view with the following attributes:

Wednesday 22 April 2020

Connect to SAP HANA from Windows PowerShell using ODBC

There Dan described how to use ODBC Data Source application to configure connections to SAP HANA on Windows and then how to use MS Excel as a client to get data from SAP HANA using configured ODBC connections.

What can I use to try this out programmatically out of the box on Windows 10?

After a bit of research, it looked that scripts using Command Line and PowerShell are the “programming” environments (again, out-of-the-box, meaning no additional installation required).

Monday 20 April 2020

Getting MAX/MIN Date on BW Query Designer (BEx), Compatible with BusinessObjects


The maximum and minimum with regarding to date subject has been on my mind for quite a while. I searched for it a couple of years back and did not come to a significant answer but to make the date as a Key Figure then use the query conditions to retrieve the TopN based on that date Key Figure, or BottomN in case of minimum, this solution will work only on the Analyzer, or Analysis for office level, however once this query is consumed bw Web Intelligence for example, conditions will not work, consultants mostly preferred doing this on the report level.

Friday 17 April 2020

Creating HANA (Cloud Foundry) connection with SAP Data intelligence and Applying Random Forest

Data being one of the most important assets for any Enterprise , its exploration and analysis becomes very crucial.

SAP Data Intelligence is a very powerful tool , which lets you do those complex processing on the data .

What is SAP Data Intelligence and how does it relate to Data Hub?

In this blog, you will be able connect HANA database as a service with Data Intelligence, explore the data via meta explorer and apply Random Forest Classifier algorithm on it.

Wednesday 15 April 2020

Secure connection from HDBSQL to SAP HANA Cloud

First things first

By default an SAP HANA Cloud instance allows access to the instance only from SAP Cloud Platform. All other IP addresses must be explicitly whitelisted by an administrator.

If the IP address of a machine running your HDBSQL is not whitelisted, then you get the error while trying to connect:

Tuesday 14 April 2020

Geospatial Data Processing in SAP HANA


To create a location enabled model in SAP Analytics Cloud from a live HANA calculation view, Location Data must be prepared through SAP HANA Studio.

The Latitude and Longitude can be converted in to Location Dimension using Spatial data types like Geometry (ST_Geometry) and POINT (ST_Point).

Monday 13 April 2020

Migrate Calculation Views from On-Premise SAP HANA to SAP HANA Cloud – Part 3


The objective of this blog series is to share the experience of migration test from SAP HANA On-Premise to SAP HANA Cloud. In Part 1, I have converted classical Calculation Views to XSA based HDI Container model. In Part 2, l have migrated the model from SAP HANA On-Premise to SAP HANA Cloud. In this blog, I will transfer data from SAP HANA On-Premise to SAP HANA Cloud.

Saturday 11 April 2020

Migrate Calculation Views from On-Premise SAP HANA to SAP HANA Cloud – Part 2


The objective of this blog series is to share the experience of migration test from SAP HANA On-Premise to SAP HANA Cloud. In Part 1, I have converted classical Calculation Views to XSA based HDI Container model. In this blog i will migrate the model from SAP HANA On-Premise to SAP HANA Cloud.

Friday 10 April 2020

Migrate Calculation Views from On-Premise SAP HANA to SAP HANA Cloud – Part 1(EN)


SAP HANA Cloud was released in March 2020 and many of you, especially SAP HANA On-Premise users, are interested in the next generation “Database as a Service” product. The objective of this blog is to share the experience of testing migration from SAP HANA On-Premise to SAP HANA Cloud.

Thursday 9 April 2020

SDI – DP Agent and Remote Source Configuration in HANA to Read Data from S/4HANA

HANA Smart Data Integration (SDI) Introduction:

SDI is HANA database native technology to support all styles of data integration. It can be used for data federation (Smart Data Access), real-time data replication and to apply complex transformations on the data.

SDI is available on SAP Cloud Platform and every HANA database since HANA SPS09.

Wednesday 8 April 2020

SAP HANA Result Cache: Static and Dynamic

Caching is used widely in SAP HANA as a strategy to improve performance by re-using queried data rather than re-reading and processing the data every time it is requested. The static result cache and the dynamic result cache are applications of this.

The static result cache is created for a specific view and remains valid for the duration of a user-defined retention period. The dynamic result cache is similar but does not have a retention period; it guarantees transnational consistency by maintaining delta records of all changes applied to the underlying table.

Tuesday 7 April 2020

Small Hands-on SAP HANA Application Lifecycle Management

In this article you will see how to transport native HANA objects between systems.

HANA Application Lifecycle Management (HALM) is easy to use part of XS services (SAP HANA Extended Application Services). It can be configured based on your preferences. The user should have a particular roles assignment.

First of all, we should have objects which we are going to transport from our source HANA system to the target. For this particular reason I will create a sub package Test_HALM in our main Test package.

Monday 6 April 2020

Periodic accrual process and configuration in accrual engine- S4 HANA 1909


With S/4HANA 1909, accrual engine has introduced “Review and Approve accruals” transactions.

There are additional transactions introduced are as follows:

1. ACEPROPOSALRUN – Propose Periodic Amounts
2. FACRATIVL – Edit Time Intervals for Accruals Reviews and Approvals
3. FACRARVWCO – Review Periodic Accruals – Controllers
4. FACRAAPPRVGL – Approve Periodic Accruals – G/L Accountants

The process is driven by Standard accrual periodic flow wherein accrual object is created by preparer, reviewed by reviewer, approved by approver and then it is can be posted manually or by scheduling batch jobs.

Friday 3 April 2020

Cost Center Budget Availability Control – S/4 HANA 1909

Cost Center Budget & Commitment

This blog post details the configuration steps of Cost Center Budget and Commitment, which is the new functionalities introduced from On Premise solution – S/4 HANA 1909.

Budget availability control allows you to control budget consumption in cost centers, which you’re responsible for. It supports business processes, from budgeting to cost postings, and it offers specific budget reporting for the budget and cost-carrying objects

Wednesday 1 April 2020

SAP HANA Upgrade from 1.0 to 2.0, project options.

In the recent few months, there were several questions about HANA 2.0 upgrade in the forums. Some developers thought that, it is a big change and lot of things get changed with that. It is not true though in all cases. In this blog, I am writing about the options generally available while doing the upgrade project to 2.0.

If it is just a database upgrade, then It is fairly a simple process which is taken care by basis/Admin team, leaving modelers/developers with no specific task to be done during this process.