Development of a Web Application for Displaying SAP HANA Data

OData support
Supervisor:
Dr. Szikora Béla
Department of Electronics Technology

Since the beginning of ERPs (1970), ERP systems based on database systems. All the industries which introduced ERP had to redesign there business processes. Now database systems radically improved as a consequence it makes possible to redesign business processes again.

I wrote my thesis at SAP HUNGARY Ltd. on the field of Supply Chain Management / Advanced Planner Optimizer / Demand Planning. I state that my thesis doesn’t contain any SAP internal, confidential information. That’s the reason why you can find random generated numbers on the charts, tables and why source code is not enclosed. I used only publicly available materials when I was writing my thesis.

My thesis can be logically divided into two parts. In the first one I will write about SAP HANA in-memory database system. I will list the SAP’s in-memory products in time order to see where HANA comes from (chapter 3). I will inspect database evolution (chapter 4), and hardware development in generally (chapter 5). Then I will go into details to see what’s under the hood, how can HANA reaches that incredible perfomance and to be a real-time platform for analytics and applications (chapter 6). I will outline HANA’s architecture, discuss how HANA is capable of fulfilling ACID requirements and why neither of them are violated, and how data is organized in the memory.

In the second part of my thesis I will design an SAP HANA application, which implements Customer Forecast Management’s waterfall analysis process (chapter 7 and chapter 8). I had to create test data in a back end system, so I will explain the steps from the beginning to the end how to do it and what is the importance of the following experssions: planning book, characteristics, keyfigure and so forth (chapter 10). Next I will outline my application’s user interface, and the meaning of the pages (chapter 11). I will speak briefly about JavaScript and its callback method, as the application was written in it, and callback methods are commonly used in it. Then come jQuery and XMLHttpRequest API, which provided the ability to make asynchronous calls to services. The SAPUI5 rendering library plays an important role in creating an SAP standard corporate web based user interface (chapter 9). Finally I will share technical details inconnection with my application’s architecture, eventhandling, and the two HANA services which were written by me (chapter 12).

Downloads

Please sign in to download the files of this thesis.