How can we improve Jedox Software?

Window functions in ETL

This would be great to add window functions capabilities in the ETL, maybe as a new function. Window function allow to do aggregations within a query, on the query itself. For instance:
id | Value | Sum
X | 1000 | 6000
Y | 3000 | 6000
Z | 2000 | 6000

the third column is the result of a window function (this can also be avg, max...)

this is present in some relational systems, see here :

at the present time to do that in the ETL you have to get an aggregation component, and lookup on it in the field transform

3 votes
Sign in
Signed in as (Sign out)
You have left! (?) (thinking…)
Pierre Lorentz shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Signed in as (Sign out)

Feedback and Knowledge Base