Filesize in Metadata Extract for Directory Connection
After access on the cloud to Java.IO and other classes in the integrator has been blocked, it is no longer possible to query the size of files. This is very important for various use cases. My suggestion would be to output the size in Metadata Ext...
When creating ETL project, a lot of debugging is needed. At this moment to check if data is correct, I'm exporting data to CSV right from DataPreview vindow. The problem - it exports only data visible on screen.
Sure - with BIG data, it is ok.
My...
Create Load/Transform from Extract and Load from transform
in the flow of creating new models we commonly create Extract, Transform and Load for each dimension. It would be nice to create a transform right from the editing window of an extract and jump right into it's settings, to edit it directly.
For very large tables in SAP it tooks a long time to select all fields to export. It would be nice if there is a select option to export all existing fields of a SAP-Table by one click.
Remember the last used cube in the database dialogs
For example, the Paste View dialog will remember the last database that was selected. This is remembered across new reports and sessions in the browser. Extend this support so that the cube is remembered also. When selecting cube in "Paste Data fu...
Set ETL variable value based on other variables (via formula)
Sometimes a variable in ETL is just a simple math calculation based on another variable.
Example: year_end = year_start + 10
Another case would be a simple "if then else" condition based on another variable.
==>
It would be great to just defi...
Add JedoxFiles option to the location parameter in the Directory Connection
Dear Jedox, What: Please expand the location parameter with the option "JedoxFiles" in the directory connection. This option already exists in the CSV and Excel connection. Why: The directory connection is very useful for file management. Please l...
Little Icon (i) which can lead to the exact article in the KB. For example, in table join, i would take to https://knowledgebase.jedox.com/integration/transforms/tablejoin-transform.htm?Highlight=table%20join
Enable separate control for rows and columns for "Parents below Children"
"Parents below Children" is a very useful feature. However, it applies to both rows and columns which isn't always suitable. It would be great if Jedox could simply enable separate control for rows and columns for "Parents below Children" function...