Friday 29 March 2019

Chatbot with Alexa + SAP Conversational AI + SAP Hana


In this bog you will learn how to create a Bot in SAP Conversational AI integrated with Alexa (using an Echo Dot 3rd gen) to get data in SAP Hana database.

Fiori application that was used here, is just to show all information that we are asking to Bot and give a visual feedback to user. Our focus here is not in Fiori development, but if you would like to see how this app works or use it for test, it’s available here. Special thanks to Danilo Jacinto that developed this app.

Wednesday 27 March 2019

Back to Basics – SAP HANA and the Virtual Data Model

The SAP HANA intelligent data platform has been available for eight years, and with each passing year, we continue to see more and more innovation. You can expect the same in the next few weeks with the release of HANA 2.0 SPS04. However, I wanted to take an opportunity to step back and have a look at some “basics” of SAP HANA – what made it different back in 2011 and how this difference continues to add value in 2019 and beyond. This is part one of a two-part series, with another blog planned for next week. For now, I’ll focus on the in-memory and columnar structure of SAP HANA as well as the value it enables via a virtual data model.

Monday 25 March 2019

SAP HANA Based Transformations (Processing transformations in HANA) aka ABAP Based Database Procedure (AMDP)

SAP HANA Based Transformations (New way of writing Routines)

As majority of us has worked on SAP BW and have written ABAP routines in transformations in BW to derive the business logic, we often noticed the performance issue while loading the data into DSO, Info cube or master data info object.

Friday 22 March 2019

ArcGIS + HANA: GIS acceleration and increased agility for ArcGIS content creators and users

The number one question I have heard from folks over the past few weeks is why Esri + HANA together?  The short answer is increased performance, lower total cost of ownership and seamless integration. But how did we get here? And what have our customers experienced along this journey?

Wednesday 20 March 2019

Advanced Available-To-Promise (aATP) with Back Order Processing in HANA 1809

In this blog will be seeing how to Activate aATP Process and How to Create BOP Job Run using Fiori Applications to Re prioritise Sales Orders based on Strategy in the BOP.

Now let’s Focus on what is aATP and BOP before going into Activation & Configuration parts.

SAP has introduced aATP with its 1610 release Advanced Available-To-Promise (aATP) with new functionality to execute order fulfilment and improve supply chain processes in a better way compared to classic ATP.

Monday 18 March 2019

Calculation Engine Plan Operators (CE Functions) Vs SQL Code

In this blog, I’m going explain few CE Functions and also the alternative solution for CE Functions using three tables with sample data.

The reason why I’m talking about this topic is, still some people are thinking about CE Functions, so I just want to clear the myths about CE Functions. CE Functions are alternative to SQL Script. We have total 13 CE Functions, but out of 13 , we may need CE_VERTICAL_UNION CE Function (this is used to combine the columns of different tables though they don’t have any relation), because we don’t have simple alternative solution in SQL.

Friday 15 March 2019

SAP BW4/HANA Migration Analysis

What is BW/4HANA

  • SAP’s New Data warehouse
    • SAP BW/4HANA is SAP’s next generation data warehouse solution
    • It is a new product and not a successor of any SAP BW

Wednesday 13 March 2019

Working with Staging Tables in S/4HANA Migration Cockpit

S/4HANA migration cockpit is the migration tool which was initially designed for S/4HANA cloud edition but now it is also available for 1709 S/4HANA FPS1 on premises and later versions.

S/4 HANA Migration Cockpit is browser based (WordPro) interface. No additional setup or activation is required once we setup SAP S/4HANA system.

Monday 11 March 2019

[HANA] Unleash the performance of your VM

Most performance issues which I was working on turned out to be basic issues regarding HANA / Linux parameter and configuration of the Hypervisor. Virtualization is regardless if big or small systems also in HANA environment an often-chosen architecture. If you want ensure good performance and how to check it in your environment keep on reading.

Saturday 9 March 2019

How to: Integrate and Consume your S/4HANA Cloud Data on-premise using HANA Smart Data Integration ODataAdapter and Custom CDS View based OData Services

1. Disclaimer

This blog entry purely focuses on functional and technical aspects of the scenario. It does not address any license related aspects regarding the usage of the software components mentioned in this blog entry. In any case you must clarify the license and software usage side before implementing such a scenario with your SAP Account & License Expert to be on the safe side. Please also don’t raise any questions in relation to this context in the comments section.

Thursday 7 March 2019

Use of Segmentation in S/4 HANA for Product Revisions

With S/4 HANA, SAP introduced a concept called Segmentation that was available in an Industry Solution prior to S/4 HANA. This blog provides an overview of how Segmentation can be used to track product revision levels with segregation of inventory for each of those revision levels.

In a B2B world, usually a product is assigned a new identification (new part#/material#) if there is a change to the form/fit/function. But if the change is minor (no change in form/fit/function), the customer assigns a revision level and may specify that product revisions are not interchangeable. One solution to solve this business requirement is Segmentation within S4/HANA that works throughout the supply chain. Segmentation can be used to assign revision levels and track these revisions (Inventory, Demand, Supply at these revision levels) throughout the logistics processes from Sales/ Procurement/ Manufacturing and Inventory.

Monday 4 March 2019

Taming your SAP HANA Express (SE01E02). Hardening an SAP HANA Express 2.0 SP03 installation part 2. Securing the SAP HANA extended application services

This is the second blog of the season one of Taming your SAP HANA Express series, episode two.

In the SE01E01 we have seen how to implement a fully qualified XS Classic domain CA-signed SSL certificate.

This episode will tell the story of how to rename and secure the XSA domain.

Saturday 2 March 2019

Taming your SAP HANA Express. Hardening an SAP HANA Express 2.0 SP03 installation part 1. Getting it ready for SAP Analytics front end tools.

Due to the fact that starting with the wave 2019.01 SAP Analytics Cloud (SAC) has stopped accepting the self-signed SSL certificates for HTTPS INA live connections I have ended up by replacing the self-signed HANA Express SSL certificate(s) with the equivalent CA-signed SSL certificate(s).