Friday 31 August 2018

Building Location-Aware XSA Web Applications using Python

Visualization is the key to effective communication. If you can paint a picture for your audience that is easy for them to visualize, it becomes so much easier to get your point across. When it comes to communicating enterprise data, what better tool to use than a map that can intuitively show complex data in a graphical way that is both useful and interesting for the audience. In this blog, I am going to introduce you to the geospatial processing capabilities of SAP HANA and how you can leverage them in a web application involving maps.

Wednesday 29 August 2018

Update SAP B1 rates using HANA XS and ServiceLayer

In this post we will do the same but using HANA XS as the development and administrating tool and B1 Service Layer as the data interface. This approach is applicable to SAP Business One version for HANA since SQL Server version doesn’t support neither XS nor ServiceLayer. After you have performed all steps you can schedule currency rates updating using standard HANA tools to update your rates regularly. This application updates rates for all currencies in your company using ECB (European Central Bank) web-service. Rates are updated according to company rate direction (Direct/Indirect rate) and using Euro cross-rate (in case the local currency is not Euro). Company details are passed in job settings.

Monday 27 August 2018

Upgrade HANA Express and optimize memory usage

As every few months an updated release of SAP HANA Express Edition is available a regular task is upgrading the own HANA Express to gain bug fixes and new features and simply stay up to date.

Thursday 23 August 2018

Service Channel:Consume HANA databases on HCP from OnPremise tools


Consider the following scenario:

CompanyX has been a SAP customer in the Business Intelligence (BI)/Analytics space for quite some time now. They have purchased licenses for many of the BI offerings from SAP like SAP Business Objects Lumira. CompanyX plans to embark on their digital transformation journey and have decided to go with the SAP HANA Cloud Platform (HCP) and SAP HANA.

Monday 20 August 2018

Setting up the new HANA service in SAP Cloud Platform Cloud Foundry

So what is actually new with the HANA service?

HANA as a service has been available for a long time in the Neo environment of SAP Cloud Platform. There are plenty of customers who have subscribed to the HANA service to create applications that leverage the core capabilities of HANA or implement data mart scenarios in the cloud.

Friday 17 August 2018

Develop, Deploy & Debug a Hana Node.js app (xsjs) using Hana DBaaS on cloud foundry.

This blog will cover 4 steps in end to end development and deployment of the app to cf.

1. Create the Hana database using the Hana Service (DBaaS) on cloud foundry (CF)
2. Configure Web IDE Full stack to work with cloud foundry.
3. Deploy the App on CF.
4. Debugging using webide fullstack.

Wednesday 15 August 2018

Developing Speech Interface for XSA Web Applications using Python

In this blog, I am going to talk about how to build conversational interfaces in XSA applications by integrating speech-to-text and text-to-speech APIs. I am also going to briefly cover how web sockets work in python for XSA applications. For those that are not familiar, web sockets are used for live bi-directional communication between clients and a server. Numerous clients can be connected to the same server through which they receive live updates as events. They do not need to make explicit HTTP calls to check for status updates. In addition, the Server can also initiate communication with the client and send updates as opposed to simple HTTP where a client must always initiate communication often leading to polling interfaces.

Tuesday 14 August 2018

Example Optimize Join Columns

In this example we will demonstrate how the usage of option Optimize Join Columns influences query processing. The example makes use of two tables.

Friday 10 August 2018

Examples Using Input Parameters with Calculation Views

Input parameters provide a means to influence query execution with values that are entered at runtime by the end user. In contrast to variables, input parameters can be mapped between different views so that an input parameter from one view is filled with values of the mapped input parameter of another view. In addition, it can be controlled at what node the input parameters are processed which provides precise control about the semantics of the input parameter. While variables are evaluated using the normal WHERE-filter Syntax, input parameters offer more options and have an own syntax. We will demonstrate this syntax of input parameters with different examples in this blog.

Thursday 9 August 2018

SAP HANA 2.0 Cockpit Installation and Configuration How to Guide

In this blog, I would like to provide a step-by-step procedure to install and configure new SAP HANA 2.0 Cockpit to monitor and maintain multiple SAP HANA databases.  SAP HANA 2.0 Cockpit is a native web based centralized HANA administrator tool used to perform all database management and monitoring of multiple SAP HANA 2.0 and SAP HANA 1.0 SPS 12 databases.

Monday 6 August 2018

India Geo Model from HANA live with SAP Analytics Cloud

Hence, I tried a quick POC to represent India data on geo map from HANA live. This was further enhanced to actually include drill up/down capabilities on the states. I thought it would be useful for many India customers who intends to achieve similar usecases.

Saturday 4 August 2018

Step by Step Installation Guide for SAP IDES S/4HANA 1610 Part 6

In this Part of blog we are going to install SAP S/4HANA Frontend server.

◈ Installation of SAP S/4HANA IDES Frontend Server

1. Follow from Step 1 to Step 7 in the Part 5 of this blog.

Wednesday 1 August 2018

Working with HANA spatial data in Javascript

Over the years, I’ve done a fair amount of technical proof-of-concept applications, most of them on HANA or the SAP cloud platform. All of these have been written up into step-by-step “how-to’s”, but precious few of them have found their way here, to the public realm.