In Edit Filter dialog, there should be a checkbox labeled "Subtotal" . If checked, underneath the selected elements the column values are subtotaled. The subtotal persists with the filter - but only if the rows remain unchanged. expanding/contract...
It would be extremely helpful to enhance the existing functionality to be able to control the information that can be displayed visually (showing data flow, dimensions, rules, etc.). This would then alllow the model builder to document and describ...
the width of a single column in a View cannot be permanently changed
Paste view - two or more dimensions are selected in the row selection (nested view). With the default configuration, the view of the element names of the second dimension is often not visible. Changing the column size will be reset if you reopen (...
As already stated in JS-I-1711 I am a fan of global subsets. To obtain the dynamical size of such subset, it would be great to obtain it via a formula like PALO.SUBSETSIZE.
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.
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...
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.
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...