Good Things Come Together: DBeaver, SAP HANA Spatial & Beer

German areas with high Biergarten density? Spoiler: The result won’t surprise…

SAP HANA Spatial offers in-database capabilities for handling and processing geospatial data. Furthermore, by leveraging the SAP HANA embedded machine learning capabilities developers are equipped with the ability to infuse spatial analytical models into their applications without the explicit need to actually visualize the geo-referenced input data.

A practical example of ABAP on HANA optimization

A practical example of HANA optimization

In this blog, I’ll try to recap my journey through the land of SELECT’s and internal tables towards the realm of HANA. I wanted to take a slow-performing ABAP, not something from a tutorial or playground module from SAP, but something “real”, tangible, a proper “pain point”, and describe how it can be converted to using HANA view(s).

A short overview of the SAP HANA Performance Management Tools in SAP HANA 2.0 SPS00

SAP HANA capture and replay

Testing application workload can be a huge effort for users, developers and consultants alike. Also, things do not get easier on a large scale, especially for moving from one revision or SPS of SAP HANA to another.

Initially released with SAP HANA1 SPS12, SAP HANA capture and replay offers semi-automated support for integrated testing in the context of SAP HANA., the goal being to simplify the manual effort needed for creating tests and performing a more accurate replays than what is possible with other approaches.

Choosing the right HANA Database Architecture

I have realized that especially after the recent release of “more advanced” S/4 HANA products, the SAP community is now more focused on cloud, on premise or hybrid deployment options and it seems to me that the actual underlying SAP HANA database architecture is usually overlooked even though it is the core of the entire implementation. In case you end up with wrong HANA database architecture, it would be really hard to have a proper high-availability and disaster recovery setup in your landscape no matter where you deployed it – cloud or on premise. And remember, when it comes to architecting SAP HANA, there are 3 key elements must be considered carefully; scalability, effectiveness and fault tolerance. In this article, I aim to provide detailed information regarding the current available SAP HANA database architecture and deployment options.

How to found Dependent Objects in SAP HANA

This is a Blog to help you out in finding SAP Dependent object / Catalog object form HANA System. Once we used to do some change in Information model, before doing so, we should have analyzed the dependent object list.

This will help you to understand the foot print of your model and other affecting areas. Moreover it is required before modifying Modeling object or information model. To know, which all are affected object of this change.

If you required the list of tables for a particular SCHEMA or the list of Field of a particular table, this this is one and only easiest way. Even if you would like to know, which Tables are using same field, this can be a simple way.

Create Cumulative figure in HANA Graphical Calculation View

This is a document how you can create a cumulative calculation using HANA Graphical Calculation View. It is one of the easy example, but you can extend it to any complex scenario.

I am creating a Simple file like this and our aim is to create the cumulative column as show bellow.

Product	Annual Sales(USD)	Cumulative Sum Sales
1070	3600	3600
1050	336	3969
1020	220	4156
1060	192	4348

SAP HANA Scripted Calculation View

When I was trying to learn HANA scripted calculation view, I had to spend lot of time in creating tables, views and data records in order to get my hands dirty and learn how the scripted calculation views works. What I am trying to do here is gather all of these information in this blog so that one can create their own tables, data and finally scripted calculation Views in the following ways.

We will Discuss Calculation View using.

1. SQL Script - Using CE Functions
2. Table Functions
3. Procedure

XS application for table distribution in scale out HANA system

HANA demands optimal distribution of data across all the HANA blades for best performance. A proper table distribution helps for more optimal load balancing and better parallelization. In this blog we will cover only the table distribution part. Table partitioning optimization will be described in another SCN article.
Here are several basic rules for general DB table distribution which this app follows:

1. Large tables should not be replicated.
2. Small tables can exist on different nodes to leverage more optimal joins and prevent network transfer between the DB nodes.
3. Tables are distributed as evenly as possible.

Expose Attribute Views as XS OData Service in HANA

1. You need to change the Eclipse IDE perspective to SAP HANA Development. Navigate to Window → Open Perspective → Other to change the perspective of your HANA Studio to SAP HANA Development   (OR)   Select the SAP HANA Development perspective in the perspective shortcut which is at the top right corner of your SAP HANA Studio.

How to return value XS OData using XSJSLIB and Stored Procedure

Information:

This document contains code of a small test. This logic allow us to return the Id with XS OData. A stored procedure is used to insert records into a table.
A structure is used specifically as input. This highlights, that I only insert directly from the stored procedure into the table. In this way, data can be validated before inserting into the table.
A XSJSLIB file is used to generate the new Id. In this post you will see an example, how to combine a XSJSLIB with a Stored Procedure and some validation inside the stored procedure.