Basically expose in the macro engine all what is possible to do in a spreadsheet: - create / rename / delete / hide / show sheet - insert / delete columns/rows - you name it
While you can upload the template and add new elements. If you decided you no longer want that element the template does not give an options for a rebuild of the dimensions. I suggest adding that as an option, but give a warning that data could be...
It would be helpful, if one can duplicate user roles in Jedox. Thus, it is easy to create new roles with just a few adjustments by using existing roles as templates.
As a Data Integrator, I want to see the previous runtime executions in the monitor after the job/load's name was modified and executed.
Currently, if I run the job/load, change the name, run it and check the previous execution (with the initial n...
when using the methode FILE.zip(connName,sourceConnName) in the FILE api, it is not possible to zip mutliple files on the root of the zip file (directory works) this would be helpful since specific systems ingest a zip file without subdirectories ...
Concatenate values from variables, functions and named ranges (spreadsheet function)
Currently CONCATENATE.RANGE seems the only (native) way of concatenating a (more or less dynamic) number of values with a delimiter. Unfortunately it only works with a cell / cell range. If a list form element uses a variable as target and the sel...
There seems to be only one global setting for the pre-shared key for all VPNs of an instance (or company VPN group of instances). This setting should be within the VPN setting and not a global setting outside. The PSK is shown in the settings of e...
By adding Jedox Logs to the OData Hub, users could access the logs from tools like PowerBI instead of the only the console. This would also allow to integrate logs in automation.
Autofilter on spreadsheet (on dynarange) - like Excel Autofilter
It would be great to add an Autofilter simular to Excel onto a spreadsheet (onto a dynarange). Current situation:
All filters in a Jedox Web spreadsheet have to be implemented manually one by one via dropdowns, subsets etc.
This is great to...
Allow Sub-consolidation journals using manual consolidation to be automatically reflected in Total Group level.
Sub-consolidation journals using manual consolidation are not reflected in Total Group level. The user expectation is to automatically apply all manual journal entries (Adjustment 1, Transition, Correction or manual consolidation entry) to all sup...