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...
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.
Excel Paste View: show multiple attributes of row elements
Additional functionality when you perform Paste View:
Add attributes to the row elements in one or more columns without loosing paste-view functionality.
This would be in line with the functionality of pasting subsets in multiple columns.
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...
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...
Currently you need to use the Advanced properties dialog to add totals to a stacked bar chart. As this is a commonly required feature it would be preferable to set this option in the main chart properties section
A clustered and stacked chart has clusters of columns or bars, with a stack in each column or bar. Similar to the example shown below: This type of chart can be used to compare actual vs. budget by category, for example.
Only calculate dependent functions / inputs in a field transform / treeElement transform data preview on function level
When re-using Field Transforms you often need to update functions however the preview of a single function will not work until every transform function is correctly updated otherwise it throws an error for a function you intended to fix later. The...