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...
It would be helpful if you could choose whether a CSV or Excel file should be created when exporting ETL DATA PREVIEW. As is the case when exporting drill-through data.
Ability to store data in a constant table. It would be designed to store small amounts of data that you want cached for other processes in Integrator. Fields in Load: Data Source Target constant table (must be defined beforehand) Mode (add/delete/...
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 ...
Right now it is not possible to filter on text in the "Filter condition for cube value" part in Cube extracts. A TableView is needed for that, what is waste of resources (you have to pull all and filter there).
Currently the ETL flow graph can get confusing/insane large if there're many steps. We need to find a better way to filter/re org the information/flow.
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...
there is no possibility to set the default right for ETL Projects like a modeler.
We would like to hide ETL projects as default settings.
And then, we would like to be able to display projects only for explicitly authorized user groups.