Tuesday 29 August 2017

Video Roundup: Troubleshooting, Installing, Provisioning, the List Goes On…

The videos below all fall into one of these categories:

1. Troubleshooting
2. Installation and setup
3. Informational (backup and restore, adapters, streaming lite)
4. What’s new?

Saturday 26 August 2017

SAP HANA High Availability with Minimal Setup (a step by step procedure)

This blog gives you information about the minimal setup required for HANA high Availability. How to add standby host and perform a failover (simulation). How services, hosts and Volumes looks like before and after failover.

For high availability, a distributed HANA (scale out) setup is required.

The minimal setup for a scale out is 2 servers (one worker, one standby).

Friday 25 August 2017

Flags to enforce the push-down of filters (available SAP Web IDE since SAP HANA 2.0 SPS02)

With HANA Data Modeling Tools SPS02 in SAP Web IDE two new flags were introduced that enforce the push-down of filters to lower nodes in specific situations in which filter push-down would not happen per default. One flag is available in Rank nodes. The other flag is available in all nodes but only has an effect if the respective node is consumed by more than one succeeding node.

Wednesday 23 August 2017

HANA Window Functions: Delivery Block Duration Example


I have been working with databases for ages, and always thought they had little limitations, except for the possibilities to calculate across rows. In basic SQL it’s not possible to refer to values in other rows. This make some calculations very hard or even impossible.

Working now a lot with the SAP HANA database, I learned about window functions which really opened a lot of new possibilities.

Tuesday 22 August 2017

Public Synonyms in SAP HANA


This blog is about my experience working on synonyms in a HANA migration project.

This blog will give you an idea of how synonyms behave in different situations and how to overcome them.

Leveraging Predictive Analytics in IT Departments

Leveraging Predictive Analytics in IT

Being in analytics I feel sort of bad for IT. They do a ton of work to deploy BI for their business users, but don’t typically benefit since they’re not the end-user.

But we’ve seen a shift where IT is starting to better leverage the analytical capabilities used by the business.

Saturday 19 August 2017

Working with SAP HANA Parent Child Hierarchies

A parent child relationships can be used to model many types of hierarchy, including ragged hierarchies, balanced hierarchies, and unbalanced hierarchies.

SAP Analytics Cloud (SAC) originally required us to use parent child hierarchies. Often when connecting live to HANA, you could be modeling your hierarchies in this way.

Below, we can see an example organisational structure. This is an unbalanced hierarchy as the depth of the hierarchy varies depending which part of the organisation you look at.

Using Predictive Analytics and Python on SAP Cloud Platform HANA database – Part 1

I was recently working with a customer who was interested in doing Predictive Analytics on top of the HANA database which they recently subscribed to on SAP Cloud Platform. They already have an on-premise server for Predictive Suite and have been using their tools against an on-premise HANA database. I this blog, I wanted to share my experience to highlight how easy it is to do the same on a HANA database on the Cloud Platform.

Friday 18 August 2017

IoT in SAP HANA Cloud Platform & Microsoft Azure

Business Vision:

With a little opinion based on both architectures proposals and with the real experience in integration paradigm:
  • Avoiding the confusion about: How do you determine that you are implementing a “IoT concept” and not just another “integration point of view”.

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).

Sunday 13 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.

Saturday 12 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”.

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.

Wednesday 9 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'

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.

Wednesday 2 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.

Tuesday 1 August 2017

SAP HANA 2.0 SPS02 new feature: Go language driver


Go is expressive, concise, clean, and efficient. Its concurrency mechanisms make it easy to write programs that get the most out of multicore and networked machines, while its novel type system enables flexible and modular program construction. Go compiles quickly to machine code yet has the convenience of garbage collection and the power of run-time reflection. It’s a fast, statically typed, compiled language that feels like a dynamically typed, interpreted language.