XS Advanced, Use SQLScript in Calculation Views
January 5, 2021
Advanced
25 min.
Create a Table Function and wrap it in a Graphical Calculation View
You will learn
- How to implement more complex logics using SQLScript in Table Functions
- How to incorporate Table Functions in Graphical Calculation views
- Create a replacement to the former Scripted Views in previous versions of SAP HANA
- Apply the
DENSE_RANK
function, to establish the ranking of a row relative to a partition of a dataset
Prerequisites
- This tutorial is designed for SAP HANA on premise and SAP HANA, express edition. It is not designed for SAP HANA Cloud.
- Getting started with SAP HANA, XS Advanced Development
- Import sample data from the SHINE model
This tutorial assumes general knowledge of the modeling tool has been acquired through completion of the beginner and intermediate tutorials about calculation views.
Step 1: Create a function
Step 2: Test the function
Step 3: Create a Calculation View
Step 4: Map parameters
Step 5: Test the Calculation View