3

SQL Window functions availability in Graphical CV modeling – BAS

 2 years ago
source link: https://blogs.sap.com/2022/03/26/window-functions-availability-in-graphical-cv-modeling-bas/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
March 26, 2022 Less than a 1 minute read

SQL Window functions availability in Graphical CV modeling – BAS

0 0 227

Window functions are powerful and very useful in Analytical data models in SAP HANA. In the past, they were generally available only in sql scripting objects like Table functions and Stored procedures but not available to use graphically in a CV.

In HANA cloud using BAS as the development tool, now it is possible to access all window functions in a graphical CV node.  You can see in the screenshot below, LAG, LEAD, DENSE RANK and PERCENT RANK functions can be used directly in a CV.

Window-Function-node.png

Tutorial on how to do: I just created a short video on how to navigate in BAS.

General help documentation for Window Functions:     SAP help Documentation

Blog on evolution of HANA Tooling:  HANA Tolling

Thanks

Sreekanth


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK