wavefasad.blogg.se - Sap hana studio use of time attribute view

SAP HANA is based on the views requested by the model. SAP HANA basically has three types of engines that it uses. In HANA, data modeling is possible only for the tables stored at column level (stored procedures). We will describe both the modeling and the implementation of calculation views, by using SQLScript.

By using calculation views, you can combine, in a flexible manner, the views and the base operations.

We will explain how you can define simple or calculated key figures, and how you can add dimensions. We will introduce the different options which are available for creating table joins and we will explain how the calculated attributes can be added to a view.Īnalytic views – These can be used for calculations and analyses based on transactional data with the help of a star schema.

We will tackle the following types of views:Īttribute views - These define the master data views. To create these analyses, we will use the different modeling options supplied by SAP HANA, and we will explain their properties and their usage. One example that can illustrate this topic can be a relatively simple analysis of flight bookings, and of the ratio of occupied seats throughout a flight, based on the data in the SFLIGHT model. Nevertheless, if the access to the data becomes more dynamic and complex, or if certain analyses or checks are necessary, the data needs to be transformed. With the help of this data model, unique registrations can easily be made, selected or modified. The business data of a given field are memorized (usually in a normalized format) in tables from the database, which are connected via a foreign key (the so-called entity-relationship model). These options lie at the core of the development process which produces HANA applications. This paper focuses on the options that SAP HANA makes available for data modeling. Many of these calculations can be graphically modeled as special data views in SAP HANA Studio, without the need of any supplementary code. When using SAP HANA, you can calculate the outcome of your business directly, on the original data, in the main memory, without any need to transfer the data.