Sunday, 16 June 2019

How to Connect SAP HANA with GeoServer

Meanwhile SAP HANA and its spatial features can be used with a lot of third party GIS (Geographical Information Systems) tools. One crucial question is on how to connect SAP HANA with these tools. This might be quite different from tool to tool and sometimes also be kind of hidden information, especially when the possibility and support for a certain tool is new and recent. In this blog I go into the details how to connect SAP HANA with GeoServer.

Friday, 14 June 2019

BW/4 HANA – Virtual Master Data Through SDA

With increasing demand of multi sourced data reporting, flexibility & agility, SAP offers an one stop solution with BW/4 HANA.

SAP S/4HANA provides operational reporting for current data from a single SAP application. SAP BW/4HANA delivers a modern data-warehousing environment that allows reporting on data from SAP and Non-SAP Applications. BW/4 HANA which is available only in SAP HANA platform is optimised for SAP HANA.

Wednesday, 12 June 2019

Implementing Dynamic Join To Showcase Measure Based On Different Attribute In a Single HANA View


There are different types of joins available in the database. SAP HANA offers all of these joins.

The different types of joins in SAP HANA

Monday, 10 June 2019

SAP Native HANA best practices and guidelines for significant performance

Just putting up and writing down all the consolidated best practices and guidelines including tips for SAP HANA modeling (Majorly for version 2.0 SPS 02)

Top 10 reasons to choose SAP HANA

SAP HANA layered architecture (Great to have) and naming conventions

Friday, 7 June 2019

Lightweight eclipse for HANA studio ( + streaming, SDI SDK)

The web based tools for the SAP HANA platform are ever improving, but sometimes the HANA studio remains the easiest way to get things done.

The HANA studio is a bit heavy and unstable, so here’s a few advice to get the capabilities in a more lightweight and robust fashion. You will need internet connectivity to do the install.

Wednesday, 5 June 2019

Import/Export Catalog Objects with Dependencies for Multi-TenantDB in SAP HANA 2.0 SPS04


In this blog post you will learn how to import/export catalog objects with dependencies for Multi-TenantDB in SAP HANA 2.0 SPS 04. IMPORT/EXPORT in SAP HANA Database is a useful feature. It is often used to transfer the data between different SAP HANA Databases for different purpose. In most of the cases, you may need to use Cross DB Access based on your business requirements. Let’s assume there are two different tenants, one is DB1 and the other is DB2. And a calculation view (ZCV_REVENUE) in DB1 is referencing many table and views in DB2. In this situation, if customers export ZCV_REVENUE with dependencies, only ZCV_REVENUE is exported, the referenced objects in tenant DB2 has to be exported manually one by one.

Monday, 3 June 2019

Principal Propagation between HTML5- or Java-based applications and SAP HANA XS on SAP HANA Cloud Platform


Although there is no standardized definition of the term “Principal Propagation”, it is commonly understood as the ability of a system to securely forward or propagate the authenticated user (principal) from a sender to a receiver in a way that the forwarded user information is kept confidential and – even more important – cannot be changed during transit. Based on a pre-established trust relationship to the sender, the receiver uses this information to logon the user without asking her again for the credentials.