Wednesday, 16 August 2017

Processing XML data in SAP HANA

New capabilities in SAP HANA are introduced with every SP. One such important one is the ability to process XML data which has been introduced with SAP HANA 2.0 SPS1 and SPS2.

XML is in common use for interchange of data over the Internet. Thus, applications require data in xml format for communication with other entities. With the data stored in the RDMS, as SAP HANA, in relational mode as tables, the application layer requires to process the data and render in the format which could be used for communication. Similarly, when the data reaches the application layer, it needs to again process this data, but now to be able to store in the database as tables (format understood by the RDBMS).

Saturday, 12 August 2017

ABAP on HANA Optimization – Step by Step Remediation


1.1 Introduction

Before Migrating to Suite on HANA or ABAP on HANA environment we need to analyse which of my ABAP code must be changed to avoid potential functional issues. In general existing ABAP code runs on SAP HANA as before Only if ABAP code relies on technical specifics of the old database, ABAP code changes might be necessary.

Friday, 11 August 2017

The Journey to SAP HANA or S/4HANA: Choose Your Own Adventure

For any company moving to SAP HANA or S/4HANA, choosing a data management strategy is an essential part of the journey. The first step on the path to migration, though, is choosing which path to take. And of course, like any journey, a properly planned itinerary and a map are critical to getting to your intended destination.

Thursday, 10 August 2017

SAP HANA 2.0 Express Edition, Transport between Tenants

This blog is about how to transport a User-Role between two Tenants within one instance of SAP HANA 2.0 Express.

To enlarge the pictures press STRG++ to Zoom In and STRG– to Zoom Out.

How to download & install SAP HANA Express is explained in this Youtube-Video

I am using the Package “Server only virtual machine”.

Wednesday, 9 August 2017

Streaming Analytics: Developing in SAP Web IDE, 2.0 SP 02 Edition

Since its introduction in 1.0 SP 12, the streaming plugin for SAP Web IDE has been improving release to release. With 2.0 SP 02 come more new features and enhancements for both the plugin and the streaming runtime tool, which should make your development, administration, and monitoring through these tools just a little bit easier.

Tuesday, 8 August 2017

Experience of my first SAP HANA project


This blog is related to few of  my experience working on  SAP HANA. It has the problems that I faced during a migration project (from Oracle PL/SQL to SAP HANA SQL Script) , in which I am working on and the possible solutions for those problems.

Saturday, 5 August 2017

How Analytics can enhance traditional IT Monitoring

According to EMA, the average IT organization has more than 10 monitoring tools. Often when speaking to IT departments about SAP IT Operations Analytics (SAP ITOA) they are concerned about adding yet another monitoring tool…

But IT Operations differs from traditional monitoring and can enrich what most organizations are doing.

Friday, 4 August 2017

Using Busines Data for Better IT Outcomes

SAP IT Operations Analytics (SAP ITOA) brings a lot of value to IT organizations:
  • Embedded Predictive Analytics makes it easy to anticipate and respond to issues before they happen
  • Realtime monitoring and alerting lets IT respond immediately when issues do occur
  • A holistic view helps simplify root-cause analysis and reduce meantime to resolution

Thursday, 3 August 2017

Removing invalid and non-printable characters in HANA based BW transformation

Most customers know the problem that invalid characters can be found in data records. Data load or DSO activation for char type InfoObjects can fail due to permitted or non-printable characters in BW.

There exist several solutions for this problem. Some customer uses function module calls in ABAP transformations for example RSKC_CHAVL_OF_IOBJ_CHECK or RSKC_ALLOWED_CHAR_GET. Other implement field routines with ABAP like

       WITH 'replace_char'

Wednesday, 2 August 2017

Implementing Graphical Hierarchy view for Profit Center in SAP HANA

This blog is about Standard hierarchy ,Standard hierarchy is a tree structure for grouping all profit centers which belong to a controlling area. When creating a Profit Center, you must assign it to a group (node) of the standard hierarchy.

Below is the sample ProfitCenter Hierarchy how it looks in SAP ECC.

Tuesday, 1 August 2017

Smart Data Streaming: Guaranteed Delivery Part 1

It’s common for streaming projects to use guaranteed delivery, or GD, which is a delivery mechanism that ensures all of the data going into a project, and all of the data processed by a project, reaches its destination – even if the client somehow becomes disconnected when the data is produced. Using log stores and checkpoints, GD works with streams, windows, as well as SDK publishers and subscribers, to prevent data loss.