Expand number of columns possible in Jedox Web Spreadsheet from 256 to 1,000 (min)
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...
Make spreadsheet function involving cell reference in paramater usable in PHP
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...
Add Sample data used in SoA demos to the Accelerator Sales. This will increase performance for the SoA team to better showcase the Accelerators. (Because it is the same data from the OnePlatform and data driven modelers and known by all SoA Consul...
Ability to directly translate (using Alias) rgrp/fgrp ids using the database dimension from the system database to their real name
If you want to see the Alias of a rgrp/fgrp id, you need to create Integrator extracts of the System database. We would like to directly access these aliases, instead of always running an Integrator job that writes them to one of our cubes.
It would be useful to be able to create, modify, delete and launch tasks directly from the API, allowing specification of :
schedule (date/time of execution and frequence of execution),
active or not,
file location when generating xlsx or pdf.
By default show summary of cells in the bottom right corner
Like in Excel it would be nice to get an automatic summary of cells shown in the bottom right Corner (see attached file).
For example:
Value in cell A1: 20
Value in cell A2: 30
Value in cell A3: 40
When range A1:A3 is selected, the sum of those ...
The different layout of comboboxes and lists makes it impossible to use them side by side without breaking report design:
- Comboboxes and lists should have the same height.
- Comboboxes and lists should use the same style.
At least there should...
It would be great to automatically replace the SHOWPICT()-function in cells by empty string during excel snapshot.
At the moment there are either -tags or "showpict" in cells that originally contained the SHOWPICT()-function in Jedox web.
Reuse of Field Transforms (esp. groovy) - central library / repository of components
Hi,
sometimes you have field transform methods which are used in the same way in different ETL processes.
This might be complex groovy scripts or simple concatenations.
If you need to change even a simple concatenation scheme (like generating a ...