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.
Active by default - option "Allow multiple parents with a single hierarchy" in Dimension upload wizard"
It can be less dangerous to set the option "Allow multiple parents with a single hierarchy" active by default when elements are uploaded to the dimension. We have encountered several issues when hierarchies with multuple parents were destroyed, be...
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
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...
If a user is restricted by #_GROUP_DIMENSION_DATA_* to a specific area he will usually get a #VALUE error for everything else (in Web as well as Excel). Sometimes it would be more beneficial to treat these #VALUE errors as 0s, so that the user exp...
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...
Perform complex consolidation logics with more dimensions (14-17)
What it is: Scale performance, while having more dimensions in the database/ cube. Challenge: While having more dimensions (14-17) to the cube, runtime for complex logics, especially consolidation rules are timing out. Use Case: Matrix Consolidati...