Wednesday, 31 October 2018

HANA Housekeeping using HANACleaner

Purpose


The blog provide guidelines on the necessary steps that needs to be followed to automate housekeeping task using SAP HANACleaner script.

Monday, 29 October 2018

Solving the Knight’s Tour Problem with HANA Graph

The problem is best summarised as the following: “find a succession of moves of a knight piece on a chess board such that the knight visits each square exactly once”.

Wednesday, 24 October 2018

HANA Scale-Up HA with System Replication & Automated Failover using SUSE HAE on SLES 12 SP 3 – Part 1

This blog, will give you insight on System Replication and SuSE High Availability Extension overview. It will also provide you details on the various method, services and agents involved to setup automatic failover of HANA.

Scope


Below are the system version on which this document has been prepared. For more updated information, always use the latest SAP Notes and Guide to best implement High Availability for HANA.

Monday, 22 October 2018

Creating Virtual Table in WEB IDE for Flat file present in Remote Source Part 2

In Previous Part – we have understood how to configure DP Agent and enable a connection from HANA to Flat File Reomote source.

Let’s create a virtual table for the object “FILECONTENTTEXT” present in the Remote Source ,FlatFile.

Friday, 19 October 2018

SAP S/4 HANA 1809 complete Installation on SUSE Linux with screenshot step by step

This blog will help to install S/4 HANA 1809 installation, installation of SAP 1809 initial pack on SUSE 12 SP03 with HANA Database 2.0 REV33 Platform Edition.

Wednesday, 17 October 2018

SAP S4HANA 1809 Installation complete steps with snaps

Installation of SAP “S4HANA 1809” initial stack on SUSE 12 SP03 with DB SAP HANA Platform Edition 2.0 SPS03 rev33 S4HANA 1809 is the latest release of SAP on-premise edition. The current initial stack is released.

Installation of 1809 is similar to old installation just a few things are changed.

Monday, 15 October 2018

Configuring DP Agent and Remote Source in HANA to read Flat Files Part-1

Setting up DP Agent and Remote Source in HANA


1. Download DPAGENT from SAP Service Marketplace as a SAR file

Extract the SAR file using the following command

SAPCAR -xvf  IMDB_DPAGENT200_03P_20-70002517.SAR

Sunday, 14 October 2018

Multi line Input Paramters with Scripted View

Creating multi-value or multi entry input parameter in HANA Graphical calculation view is soothing and works perfectly, however doing same in Hana Scripted view doesn’t work correctly (Checked on HANA 01 SPS 12, not sure if SAP has fixed this in later versions).

Friday, 12 October 2018

Installing XSA & WebIDE for HANA 2

To use XSA, first you must download the additional XSA components from SAP Support – Software Downloads – these packages are in addition to the base HANA Platform.

Knowing exactly which files are required can be tricky, so I have captured those below.
I used HANA 2.00.23 (HANA 2 SP2 Rev 23).

Wednesday, 10 October 2018

How to configure HANA network communication channels – Part2 Internal network

Introduction


Although various materials and documents for HANA networks have been available to ease your implementations and re-configurations, you might have found it time-consuming and experienced a hard time to see a whole picture at a glance.

Monday, 8 October 2018

How to configure HANA network communication channels – Part1 Public network

Introduction


Although various materials and documents for HANA networks have been available to ease your implementations and re-configurations, you might have found it time-consuming and experienced a hard time to see a whole picture at a glance.

Friday, 5 October 2018

Managing HANA system replication takeover with Spring and Hibernate

SAP HANA system replication provides the possibility to copy and continuously synchronize a SAP HANA database to a secondary location in the same or another data center. Usually system replication is used to support high availabilty and disaster recovery. SAP HANA 2.0 introduced the Active/Active (read enabled) system replication operation mode, which allows read-only access to the secondary site.

Wednesday, 3 October 2018

Combining spatial and sentiment analysis using SAP HANA

Taking unstructured data, extracting sentiments from it and then putting spatial data in the mix can yield valuable insights for any company.

Intro


Many companies have a large pool of unstructured feedback from customers (e.g. complaints). Most of the time, this data also has geographical information attached (e.g. the address).

Monday, 1 October 2018

Monitoring HANA 2.0 with replication

I want to show a way how you can integrate your HANA 2.0 system in the Solution Manager System Monitoring.

Disclaimer: I made this document as neutral as possible, but I was out of demo landscapes.  All blacken out parts are hostnames, SID, system numbers, ports, etc….