Soon ramp-up 5.1 there is not anymore possible, all variables and default values to see at once. Best case would be, to see like in pervious versions the variable, default values and description at once with a double click on variables in ETL Mana...
In Lookup function new option
"Use Interval" (False/true)
If set find the row where the value is between the from of the row and the next row.
10 a
20 b
30 c
For value 5 -> default value if set
For value 25 -> b
For value 35 -> c
Option...
Tool to extract OLAP objects to deliver to another environment
When we develop project, we may need to change the structure : add an attribute, add a cube, change some elements in a dimension, etc.
It is not possible to select the object in the olap database !!!
So there should be a tool to be able to selec...
In several areas, elements are sorted by creation data as opposed to name and this makes selection difficult. For instance:
- in modeler and subset editor, dropdown to select a database
- in modeler, list of cubes
- in subset editor, select Al...
This feature would certainly increase effectiveness in troubleshooting transformations of specific fields or variables throughout the ETL process. It will also provide immediate insight in all the steps that a field or variable goes through while ...
It would be very useful to have the possibility defining global Variables, Connections etc... (Perhaps even extracts!)
In Case e.g. an IP-Adress of a source-server changed it is not longer necessary to change all the concerned connections in the ...
Search in dimensions in entire dimension as opposed to just in the currently shown page in Jedox Web
In Jedox Web if you are searching in a dimension e.g. defining subset in dyanrange it only searches in the current page as opposed to the entire dimension.
Currently, Jedox ETL doesn't have the functionality to update target table with source data using simple UPDATE statement.
It is possible to call stored procedure, but ETL tools should be able to handle the update without using stored procedure.
...