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 : http://wwwlgis.informatik.uni-kl.de/cms/fileadmin/courses/SS2008/NEDM/RDDM.Chapter.06.Windows_and_Query_Functions_in_SQL.pdf

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

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

0 comments

Sign in Sign in with Jedox AG
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base