Load flat file decimal values to ADSO (SAP BI) and access in SAP HANA Cal view ( eclipse/H Studio)

We had a requirement to load GAS emission data into SAP BI, as the business does a lot of manual calculations in excel, to get the emission factor which is dependent on multiple values. They first need to sum up the values, do a standard deviations, SQRT of some NO2, Co2, IC4 values, divide it by some factor etc., which is a heavy excel based lookups and calcuations.

SAP S/4 HANA for Dummies

With the proliferation of digital transformation and all of its associated technologies such as RPA, cloud, AI etc. software vendors are swiftly adapting their current product offerings to meet the new wave of business demands. SAP, the behemoth in the ERP space is no exemption. SAP’s core ERP product has always been ECC but over the years the software giant has invested in developing an intelligent ERP system. This new system is not an upgrade to its core ECC but a complete new business suite with a simplified core, an in-memory database designed by SAP, a grade-A role based user experience called Fiori, and additional flexibility to integrate and extend intelligent solutions in the cloud with SAP S/4HANA cloud platform. It is called S/4 HANA. Each new version has a simplification list. Simply type **** (product version e.g. 1909) SAP S4HANA SIMPLIFICATION LIST online to get the information.

Adding XS Tooling to your SAP HANA, express edition Server Image

Out of the box the SAP HANA, express edition (HXE) server only option is ready to go with a lot of basic functionality. However, to use it you need to install the SAP HANA plugin for Eclipse. This of course is not a bad thing, however you may also like the idea of using the browser based tools.

This guide will help walk you through the steps necessary to install the SAP HANA XS tooling allowing you to use a browser to interact with your server going forward.

Lets discuss some good practices of coding

This blog will help folks who just on-boarded for ABAP in understanding the codes in line with it.

Note: 1st block of code indicates incorrect way of coding. Codes that follow the golden rules are written just after that.

Association Analysis Algorithms Implementation using HANA ML Python APIs.

Let’s Start –

Here is small list & introduction of the methods which I will be implementing one by one.

Introduction and algorithm description

I have used Jupyter Notebook which uses the real time itemset dataset to demonstrate the association rule mining algorithms below which are provided by in hana_ml package.

SAP Cloud Platform Extension Factory – Connecting to SAP Commerce Cloud

One of the key components of the SAP Cloud Platform Extension Factory Kyma runtime is the Application Connector.  The Application Connector provides a mechanism to simplify the connection between external systems and Kyma in a secure manner.  Once the initial connection has been established, the registration of the external Events and APIs of the external system takes place. The Events and APIs are then available within the Kyma Service Catalog.  The events can be consumed asynchronously with services and lambdas (serverless functions) deployed within Kyma.  Additionally, the Application Connector provides monitoring and tracing capabilities to facilitate operational aspects.

Currency Conversion in HANA based on Fiscal Period

Background

Whenever there is a requirement for Currency Conversion, the time reference plays a dominant role for determining exchange rates. Exchange rates vary on daily basis and which exchange rate should be applied for currency conversion is always a question.

Develop Simple on HANA Express in AWS Cloud 9 Checkpoint – How to Catch Up/Restart

Develop Simple on HANA Express in AWS Cloud 9
Develop Simple on HANA Express in AWS Cloud 9 Part 2 – The Backend App
Develop Simple on HANA Express in AWS Cloud 9 Part 3 – The Frontend App

Overview

In the past 3 parts of this series, we’ve done a lot of Cloud 9 configuration and coding. As someone whose first job is not that of a technical writer, I know that some steps may not have been clear. I also know as someone who follows along to tutorials, sometimes I just need a ‘fast forward’ or ‘catch up’ button. This will be the point of this part of the series. Or if you happen to massively mess up your progress, this will walk you through quickly getting back up and running as-of Part 3 in the series.

SAP HANA XSA Controller API Interaction

Since the introduction of SAP HANA extended application services, advanced model (XSA), SAP has supported many new approaches to accessing the platform APIs.  XSA is based upon Cloud Foundry which provides its core functionality via a command line client and a REST enabled web API.  XSA has this same functionality, but most of the focus on platform admin and interaction tends to focus on the CLI interface or the browser-based administrative UI which SAP deliveries. However behind that web UI are essentially calls to the controller APIs. These same APIs can be called from and used in your own applications.  In this blog I’d like to share some experiences trying to use these APIs.  There are some common challenges anyone using them will face and perhaps this blog can be helpful in that regard.

The Few Facts About SAP Leonardo, SAP HANA and Machine Learning

https://iytwist.blogspot.com/

BW/4 HANA – Virtual Master Data Through SDA

With increasing demand of multi sourced data reporting, flexibility & agility, SAP offers an one stop solution with BW/4 HANA.

SAP S/4HANA provides operational reporting for current data from a single SAP application. SAP BW/4HANA delivers a modern data-warehousing environment that allows reporting on data from SAP and Non-SAP Applications. BW/4 HANA which is available only in SAP HANA platform is optimised for SAP HANA.

Principal Propagation between HTML5- or Java-based applications and SAP HANA XS on SAP HANA Cloud Platform

Introduction

Although there is no standardized definition of the term “Principal Propagation”, it is commonly understood as the ability of a system to securely forward or propagate the authenticated user (principal) from a sender to a receiver in a way that the forwarded user information is kept confidential and – even more important – cannot be changed during transit. Based on a pre-established trust relationship to the sender, the receiver uses this information to logon the user without asking her again for the credentials.

SAP S/4HANA Cloud and S/4HANA On-premise Quality Management Features

In this blog S/4HANA Cloud and S/4HANA On-premise Quality Management features will be presented. Both applications improve its features and continue to meet customer requirements. Quality management process is the key driver from the product development stage until product discontinuation phase.

SAP BW/4HANA Migration – Authorisation

The simplification of object types in SAP BW/4HANA has an impact on authorisation objects. When converting a SAP BW system to a SAP BW/4HANA, authorizations for object types that are not available in SAP BW/4HANA (like InfoCubes) must be replaced by authorizations for corresponding object types (like ADSO).

SDI SDQ Geocoding & Address Cleansing

Have you tried using the HANA Smart Data Quality (SDQ), and found the transforms aren’t working?  Well this blog should help, there are country specific files required for both geocoding (latitude, longitude) and address cleansing.

The tale of SAP HANA, SAP Analytics Cloud, and Brexit

This blog I wanted to show you an end to end example of getting unstructured JSON data, loading it into SAP HANA, enriching with geo-spatial attributes and exposing to SAP Analytics Cloud for further analysis.

The problem with most tutorials usually – they are focused on some randomly generated abstract data (like SFLIGHT or EPM Model data) and for some people this doesn’t really mean much, so I thought a real life example of a real up to date data analysis would be very beneficial for everyone.

SAP HANA licensing models explained

SAP’s column-oriented, in-memory database, that combines OLAP and OLTP operations into a single system, or in other words, SAP HANA originated from a research started in 2006 by SAP’s co-founder Hasso Plattner while he was a computer science professor at the Hasso Platner Institute in Postdam, Germany.

Understand key watch outs and mitigations for your SAP S/4HANA Central Finance program

In this blog I have captured some of these key learnings and challenges along with potential mitigations based on our CFIN client implementation and Proof Of Concept (POC) experiences. I will classify these experiences and learnings based on primary four categories below:

I. Project Plan and Approach
II. Solution Architecture
III. Product Issues
IV. Skills and Resources