Calculation Views in SAP HANA

Data modeling with Calculation Views in the SAP HANA database offers extensive possibilities for virtualizing reporting. In contrast to the classic data warehouse approach, data processing takes place at the time of the report. The virtual data models allow for a much more flexible area in which requirements can be implemented agilely.

Course Description

Data modeling with Calculation Views in the SAP HANA database offers extensive possibilities for virtualizing reporting. In contrast to the classic data warehouse approach, data processing takes place at the time of the report. The virtual data models allow for a much more flexible area in which requirements can be implemented agilely.

Developer and BW consultant
Prerequisite: Basic database knowledge

  • Experience in ABAP programming with OpenSQL
  • Knowledge of SAP BW transformation routines in ABAP
  • SQLScript experience is not required. The course covers the contents of the course SQLScript Basics
  • Types of Calculation Views
    • Cube
    • Dimension
    • Scripted
  • Aggregation node
  • Restricted columns
  • Join node
  • Calculated column
  • Parameters and variables
  • Currency and quantity conversion
  • Generation and use of external views of BW objects
  • Analytical Privileges
  • Scripted Views & Table Functions
My book “SQLScript for SAP HANA” is used as training material. That’s why every participant receives a personal copy at his first training.

Individual company training courses are the first choice for teams of 4 or more participants. Tailored to your tasks, your system stands and hopefully soon again in your rooms. At the moment, of course, the company training courses take place online. In addition to the described standard scope, the training can of course be customized for you. Additional topics can be added and specific problems from your system can be discussed.

Tailored content

You can set the priorities. Depending on the qualifications and experience already available in your team. And also depending on what is important for your current projects. With in-house training, you can set the direction. Or you can rely on our experiences from other customers.

However, the content planing should not be done ad hoc during the event. It is best to discuss the topics 2-3 weeks in advance by phone or via WebEx. Then I can prepare well and offer you an optimal event.

Your Locations

(At the moment unfortunately only very limited possible)

In-house training can take place in the familiar environment of your employees. This has several advantages. On the one hand, you save your employees the trip. This, of course, eliminates the travel costs and the associated organisational effort. On the other hand, this also offers a high degree of flexibility for the participants. For example, if a heterogeneous group is to be trained, participants can join depending on the level of knowledge and topic.

Your systems

HANA System

Every system is different. When in-house training takes place on your systems, you can count on learning the right version of the development environment, application server, and HANA database. It also allows to take a look at problems from your practice on your systems during the event.

This post is also available in: Deutsch

Open training courses are ideal for self-employed people or individual participants from companies. They are held every two months. The programme is fixed, but additional modules will be offered during the training week, which can be booked additionally. The weekly programme and further details can be found on the Open Training page.

Dates

Planned events in the near future:

Keine Veranstaltungen

Schedule of the open training

TagLektion
Uhrzeit
Montag

SQLScript Grundlagen (1/4)
9:00 - 12:00 Uhr


SQLScript Grundlagen (2/4)
13:00 - 16:00 Uhr
DienstagSQLScript Grundlagen (3/4)
9:00 - 12:00 Uhr


SQLScript Grundlagen (4/4)
13:00 - 16:00 Uhr
In addition to a paper certificate of attendance, each course participant also receives an electronic badge that confirms their attendance with a digital certificate.

This post is also available in: Deutsch