Skip to Content

Table Functions vs Calculation View

Sep 20, 2017 at 07:12 AM


avatar image

Hi Friends,

As I understand Table Functions are now the recommended script-based artefact whenever a modeling requirement cannot be fulfilled with graphical information views.

I want to know what are the scenarios where Graphical approach would not be able to fulfill the modeling requirement.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Oct 04, 2017 at 10:51 PM

The developer documentation does explain this, so I recommend to give it a read.

As a quick answer: table functions are useful when you want to use query constructs that are not available in a graphical calc view or just cumbersome to model there. Window functions, SQL set operations (MINUS, INTERSECT) or multi-level aggregation (GROUP BY GROUPS) are just some examples here.

10 |10000 characters needed characters left characters exceeded