The subject of my thesis is an implementation of a web used analytical application’s function (SAP APO Analytics). The completed application allows the compilation and execution of an individual query on web for the business analysts. There is a possibility to save queries, to export them to Microsoft Excel and to share them with individual url’s. The result of querys can be displayed as tables in the browser.
The applied data will be read from SAP memory based database, the HANA. I have stored the parameters of the compiled queries in my own database table created for this. The speed of HANA system permits making business analysts in real time and from the latest data. We can enjoy the advantages of this by using SAP web used analytical tool.
To the implementation of the task, first, I investigated the business objects of SAP APO Demand Planning applications and the structure of HANA system. In the planning period I planned the necessary data base model and the user interface. I demonstrated the steps of implementation passing through single functions and I illustrated the usage of the application in an other chapter.