Skip to Content
-1

Table Functions vs Calculation View

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.

Thanks,

Gaurav

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed characters exceeded