Ideas

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...

Running an Http request from an action would allow integrating APIs into spreadsheets without using macros or Integrator. Post requests should allow specifying a body and e.g. using variables or referencing cell values.

When you connect to ADL, the data is "schema-less" (ie there are no field names on the file columns.). Data Lake has a way of presenting multiple files (i.e the data files - there could be multiple.., the json file containing the field definitions...

Currently it's painful to edit a picklist in the stored subset editor, requiring careful use of the ctrl key etc to not lose the initial selection. If the picklist editor could function like the element selector in the Edit View/Paste View selecto...

One of the great things about Excel is that you can have as many windows open on as many screens as you need. With Jedox, we have found it very limiting only having one web sessions on one screen. While having Jedox data in Excel on other screens ...

When a dimension is created or edited in the Time Editor an Integrator job is created, executed and destroyed. I would like to save or create the integrator project.

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...

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...

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 ...

Add new function to palo.data function list that will calculate the median . similar to the functions PALO.DATA.AVG / MAX / MIN , add a MEDIAN option.