XS Advanced, Use SQLScript in Calculation Views
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.