Jedox integrator - Same features for "Insert columns" as in Extract
Currently, only in the "Extract" elements within Jedox Integrator the "Insert column" feature has very good functionality. You can select all elements, deselect all or just select certain columns into your Extract. But within the "Transform" eleme...
XML editor - option to show all code of the ETL process
Currently the XML editor is limited in functionality: Find and replace is missing (there is a separate idea for this: JS-I-1557) The XML editor can only show the currently selected ETL element, e.g. job, transform Solution: Have a drop-down in the...
As part of the field transform, it would be helpful if the net working days selection option could be provided as an additional unit in the DateDuration function and this would output the number of weekdays between two dates.
When opening a report fails or is too slow, for example, due to a macro running on startup, it would be helpful to have a safe mode to open the report ignoring actings, macros, etc. This could help fix the report.
Show the last log rows instead of limiting ("tail" instead of "head")
when too many log lines are returned the message "Log limit for INFO messages exceeded" appears. Then you need to go on the server and look at the lines. An option to show the last lines instead of limiting would be really helpful
Improve handling for creating arrays on merged cells
MS Excel doesn't allow to set an array formula (e.g. PALO.SUBSET, but also non-Jedox arrays) on a cell range with merged cells. Jedox Web Spreadsheet does accept input of array formula on a range with merged cells, but the output will then - depen...
What it is: Consolidate both Legal and Segment Consolidation ledger together/ with the same Consolidation logic and Store information in same ledger/ cube rather than multiple. Customer Challenge: Data reconciliation is complex while having multip...
Loads with insertParallel on sub-trees (boundaries)
If one uses a load with insertParallel mode, the ETL will unconsolidate duplicates of elements in every Top-Element. This behavior is documented but not always wanted - sometimes you only want to load a certain Top Element (Tree) to be loaded with...