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...
Keep source structure / types when reading a file, so that decimals etc are not changed (same for reading via SQL)
When you extract a file via integrator (i.e. Excel workbook) it doesn't keep the source formatting and requires you to use an extract and transform to get the numbers back to their original format. The suggestion would be to add a checkbox to an e...
Charts: Colour codes, fill/border, line formats and positioning should be dynamic
All colour codes, fill/border, line formats and positioning on charts should be able to be passed in from a range, named range or variable. This would essentially bring a basic "conditional" formatting to charts and cover the main things the users...
Keep the button properties (background, font) when clicking on it (web and Canvas)
I'd like it if, when the user clicks on a button, that same button could keep its properties (background, font, etc.) and not be displayed again by default. A bit like checkboxes that keep the tick displayed when you click on them.
The proposed Unified Scenario Manager aims to streamline data management by enabling seamless copying between versions and facilitating scenario creation, enhancing efficiency and flexibility. Current challenges include fragmented data copy proces...