Ideas

this would be greatly useful to have a method to get the number of rows returned by an ETL component, such as: mySource=API.initSource("myExtract"); mySource.getRowCount();

Reports sometimes have a lot of columns and it's hard to recognize the whole row, especially if the cells are locked. It would be very helpful to highlight the row on mouse hover as it is now in Modeler dimension view.

Allow spanning of frameset to enhance its possibiliies, e.g. 1 column and 2 rows besides:

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

It could be interesting to add those methods to the column and row PHP Class. It's already possible by javascript code but there is many constraint when we use js code.

It would be very helpful to be able to add columns to an existing drillthrough database. Currently this is not possible. There is no control over the drillthrough database at all (only via ETL Load process). This is a pain once there are more colu...

In order to create web models, it is sometimes necessary to import excel files which have more than 256 columns (current Jedox limit). In many instances these "wide" data blocks are parts of arrays (which can not be broken up) and are needed for m...

We would like to use "openxlsx2" or "xlsx" or any other similar "R" package to generate well formatted Excel files, expected by customers, from Integrator "RScript" transform . We expect, we will be able, among other things, too : - create workboo...

There is a lot of spreadsheet function we can't use in PHP with application like : application() - > isformula("A1") Instead of "A1" we could put an paramater that select the cell A1 like the class range, like this :application() - > isformu...

The ability to paste data to a range of cells in Jedox web like you can with Paste Values in Cube View in Excel. Specifically it should handle pasting across consolidated and base nodes. If you do this then consolidations are ignored and base valu...