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