I created some complex subsets in Jedox Web that I sometimes use in Excel I also create subsets for other users as well. I especially like them because it gives you the ability to quickly combine multiple filters and achieve complex selections.
Create a function that shows the last update of the sheet, by making it a function I can decide where in the report to place it so it's well located for others to see it and I could also change its format.
Enable usage of variables for paste views in the JOA 365 add-in
In the old/legacy add-in you had the functionality that you can use a variable manager for adding or using existing variables by editing the paste view and select elements. Please implement the variable function for the JOA add-in as well. Due to ...
Ability to copy & paste (CTRL+C & V) values into PALO formulas (view/detached/...) without overwriting these. For multiple cells, string and numeric (user-definable preferred numeric format or at least a warning/selection, if the input has...
In the classic Add-in, it's possible to use right-click to access the "Trace Value" option which allows you to have overall information on the value calculation, path, etc. This is a needed feature in the new Excel Add-in
Lists are also not possible to use in the Add-in, usually, I create a list where I have a delta to show the difference between the other two columns. A common use case would be to have a pre-made report where you have Plan vs Forecast and then hav...
Currently, there's an object in the Role Groups called "Cell Data Excel" that allows to define independent writeback rights in Jedox Web & Excel. E.g., a user could writeback from a Web Report but not from Excel, however, this function is not ...
Option to Deactivate to Automatic Update of Palo Formulas in Excel after Opening an Excel File
With the Excel add-in we have the issue that if somebody without Jedox access opens the file he gets value errors as Jedox automatically connects as soon as the file is opened. We have other tools for which we can deactivate the update functionali...