Retrieve information from parent node in JSON extract
When hierarchical data is retrieved from a REST endpoint, it's really cumbersome to get that data into a dimension. Imagine, your JSON data has the following hierarchy: Legal entity > Function Area > Cost Center Naturally you'd configure you...
Expand column aggregation to include more than 2 column inputs
It would be great to be able to add additional columns in the Column Aggregation Transformation Function so the aggregation can be calculated based on the unique dimension elements from another column. Currently, it allows max two columns but woul...
The Database name are usually used as reference with apps. In case that a Database is renamed all these references stop working. In our solution design we use the ID from Metadata to ensure that we always have the correct database as reference (it...
Integrator - Values in Data Preview with options should stay during session
The "data preview with options" is a helpful feature to look at data points without having to change the default value of variables. However it would be nice, if the values are saved during the session to look at different component data previews ...
Add a property to loads and jobs that show all dependency in report designer
Actually, it could be very tipsy if there is a way to know where a job or a load is called. For example on a report there is button with action that call an integrator job A. We could add a property to this job that show the path of the report tha...
Add a checkbox to return absolute value in function DateDuration
When we use the function DateDuration in ETL Fieldtransform it return a subtraction between 2 date, but sometime we don't care about if the date difference (in terms of days for example) is positive or negative so in this case it should be interes...
For development it would be helpful to have the possibility to define a limit for the extract. The goal would be to have quicker loading times with a smaller dataset.
Table Join (left outer) - Checkbox to show only nulls on right side of join
To do this currently requires a Table View step to filter out records that are not null on the right side of the join. It would be simpler to have a check box next to the join type that only shows up when 'left outer' is selected. When checked, th...