Jedox Ideas

Let us know how we can make Jedox even better!

ADD A NEW IDEA

Integrator

Showing 164

Only calculate dependent functions / inputs in a field transform / treeElement transform data preview on function level

When re-using Field Transforms you often need to update functions however the preview of a single function will not work until every transform function is correctly updated otherwise it throws an error for a function you intended to fix later. The...
over 2 years ago in Jedox Platform / Integrator 0 Future consideration

Keep source structure / types when reading a file, so that decimals etc are not changed (same for reading via SQL)

When you extract a file via integrator (i.e. Excel workbook) it doesn't keep the source formatting and requires you to use an extract and transform to get the numbers back to their original format. The suggestion would be to add a checkbox to an e...
over 2 years ago in Jedox Platform / Integrator 0 Future consideration

Set target fields in a cube extract

This would be helpful to enable setting the target fields in a cube extract. When copying a slice to another one, I use a cube extract, then a fieldtransform where I put a constant. We could cut the FieldTransform if the target structure could be ...
over 2 years ago in Jedox Platform / Integrator 1 Not Planned

Table Join (left outer) - Checkbox to show only nulls on right side of join

To do this currently requires a Table View step to filter out records that are not null on the right side of the join. It would be simpler to have a check box next to the join type that only shows up when 'left outer' is selected. When checked, th...
about 1 year ago in Jedox Platform / Integrator 0 Future consideration

Implementation of Token-Based Authentication for JDBC connection

The customer would like to use Token-Based Authentication for JDBC connection (NetSuite in this case) in addition to the User name and Password currently supported. As per Knowledge Base article https://knowledgebase.jedox.com/integration/connecti...
over 2 years ago in Jedox Platform / Integrator 0 Future consideration

Show the last log rows instead of limiting ("tail" instead of "head")

when too many log lines are returned the message "Log limit for INFO messages exceeded" appears. Then you need to go on the server and look at the lines. An option to show the last lines instead of limiting would be really helpful
over 3 years ago in Jedox Platform / Integrator 1 Planned

Incremental Jedox Data Driven Modeling in Excel

Scenario: User has created dimensions and cubes using Jedox DDM though add-in in month 1. In the next month there are few more new dimension elements and additional cube data which needs to be added to the database.Challenge: the user is comfortab...
over 2 years ago in Jedox Platform / Integrator 0 Planned

Refactor the delete method of the FILE Api

deleting a directory that is not empty is impossible with the method delete: FILE.delete("dir_not_empty"); // fails FILE.delete("dir_empty"); // succeeds this is of huge annoyance since you might want to refresh the content of the whole directory
over 1 year ago in Jedox Platform / Integrator 1 Future consideration

Loads with insertParallel on sub-trees (boundaries)

If one uses a load with insertParallel mode, the ETL will unconsolidate duplicates of elements in every Top-Element. This behavior is documented but not always wanted - sometimes you only want to load a certain Top Element (Tree) to be loaded with...
over 5 years ago in Jedox Platform / Integrator 2 Future consideration

Table Union: Additional check box "use columns from first source only"

When you are joining 2 datasets from 2 different sources, identical column names are merged and the data appears in one column. However, if one of the data sources has additional columns not in the first data source, the output includes ALL column...
over 2 years ago in Jedox Platform / Integrator 0 Planned