Databases Reference
In-Depth Information
Calculation views can be either
Graphical
, or can use
SQL Script
, an SQL-based programming
language proposed by SAP for the HANA database.
SQL Script
calculation views are more
powerful, since they provide more features than graphical views, but they are also more
complex.
SQL Script
-based views are not covered in this topic.
The
Calculation View
dialog will appear as follows:
Our view will be called
SIMULATOR
, is of type
Graphical
, and is in the
book
package.
Click on
Next
, to see the now-familiar view-selection dialog. In our calculation view, we'll
be combining the output of the first analytic view we created, plus our
PROJECTED
view,
so please add both of those to the calculation view.
In order to define our calculation view, we are presented with a graphical designer, which
initially will show only the two input nodes (our analytic views) and an
Output
node, as shown
in the following screenshot: