Jedox Feature Voting Tool

Dear Jedox User,

in our continuous strive to improve our services, features and to help you gain your share of this ever growing market we are introducing the Jedox Feature Voting System.
This new service is currently exclusively available for you, our Users and Partners.

What is this Jedox Feature Voting System?
It is a tool that provides you with the options to create and vote on Feature request, Ideas and any other general Feedback.
This in return provides us with the necessary Information to react and provide you with the things you need.

We invite you to browse this Page, create and vote on new Features, Ideas and requests!

How can we improve Jedox Software?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add Function for character encoding in Field Transform

    It would be great if you could add a Function so that a text may be rendered using a different character encoding (like UTF-8, ISO code pages).

    As of this writing, I didn't find any other method to transcript coding than to use a Switch or Groovy-Function and implement the change manually.

    2 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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 insertParallel (e.g. Balance Sheet or P&L) but do not want other trees to be touched by the ETL. Therefore I propose to have an option/additional loading mode which works like insertParallel but only within a certain sub-tree so that all other trees remain as-is.

    9 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  3. Scheduler: possibility to create multiple folders in the scheduler

    So that administration of the scheduler jobs is possible.
    For example to manage active and inactive jobs.
    (Enable or disable jobs all at once)

    15 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  4. Set the default right for ETL Projects

    there is no possibility to set the default right for ETL Projects like a modeler.
    We would like to hide ETL projects as default settings.
    And then, we would like to be able to display projects only for explicitly authorized user groups.

    3 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  5. Export and import multiple Integrator projects in one step

    We have split our ETL processes into several different Integrator projects to keep everything modular and maintainable.

    However the deployment of a new complete release from a development to a production system is quite annoying:
    We have to export every single project separately.
    And on the production sides it is the same:
    We have to import every single project separately.

    It would be great to be able to do this in one step.
    Thanks :)

    10 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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 key) across several different processes it is very much effort and very error prone.

    Also for more complex groovy scripts it is not good if you have them redundant.
    Therefore it would be good to create such transformations in a kind of central repository with generic inputs. And then you can select/use/map them in a concrete field transform step within…

    6 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  7. MD5 Hash in ETL => compare records, detect changes/deviations, history logic

    It would be great if Jedox Integrator could generate an MD5 Hash based on an entire row. This would be very useful in generic routines where you need to compare records and detect changes (esp. for historization logics)
    For me this would be a new field transform function.

    5 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  8. Undo in ETL

    There is no way of undoing a change in ETL rather than reloading the whole ETL Project. Once a change has been made one is forced to save!

    Would be helpful if you can leave a changed ETL component without saving it.

    37 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  9. Load multiple Excel files from a directory with one connection and extract (like CSV Files).

    oad multiple Excel files from a directory with one connection and extract (like CSV Files).

    Basicly the same structure like creating a file extract using a folder-connection. But also working with Excel files :)

    22 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  10. Global Components in the Integration-Manager

    It would be very useful to have the possibility defining global Variables, Connections etc... (Perhaps even extracts!)
    In Case e.g. an IP-Adress of a source-server changed it is not longer necessary to change all the concerned connections in the projects, but only the one global defined connection...

    12 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  11. Number of rows from an ETL component

    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();

    18 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  12. Copy function from a Field Transporm component to another one

    In the integrator > field transform, i would like to use the same function for several different transforms. More specifically, i'm using a map and I'd like to use the same map in other transforms without retyping it (or updating it individually).

    17 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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 define such formulas directly in the variables section of the ETL project.

    Right now you would need a separate groovy job for this which is too much overhead for this simple task
    and creates unnecessary complexity within the flowchart / ETL process.

    14 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  14. Find & filter in ETL data preview windows

    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 solution:
    Add search and filter functionality to DataPreview window. Any column would be searchable and filtrable. Something like Data Filter in Excel.

    It would exclude any exporting for debugging purposes.

    17 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  15. debug mode for macros and script code in ETL

    when writing macros or script code in ETL it is often difficult to find out what went wrong and when it went wrong.
    The only way at the moment is to scan the log files for error messages.
    For development it would be helpfull to have a debug mode for those scripts and macros to see step by step if they are working correctly.
    This could be combined with the object manager I proposed within another feature request.

    89 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  16. Tags for ETL-components

    Choose several ETL components of one project which belong somehow logically together and group them under a given name.
    Should be displayed in ETL Manager under a new item
    -Tags
    --- SalesRelated
    ------Extract
    --------- E_XY_1
    --------- E_XY_2
    ------Transforms
    --------- T_QWERT
    --- ImportantComponents
    ...

    A component may be assigned in different tags
    Option to create a tag out of the dependency of a component (to decide if dynamic or not)
    #13405

    30 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  17. Activate / Deactivate Filters in Extracts

    This would be great to be able to deactivate filters in Extracts. For instance, Extract cube, I have 3 rows, and I want to remove the 2nd temporarily. At the present time I have to delete it, I would like to be able to deactivate it only.

    8 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  18. NULL check for FieldTransform functions (ISNULL/default value)

    In FieldTransform functions we need the option to define a default value for inputs and outputs which contain NULL values / invalid values.

    Why?:
    FieldTransform functions work well, if you have valid inputs.

    But sometimes you have invalid inputs or null inputs.
    Then the field transform can obviously not provide a valid output and you will get <<null>> as result.
    Furthermore you get a warning in the log.

    You can solve this with additional Switch functions to check the values, but this gets very clumsy and confusing.

    Example:
    You have a DateDuration function to calculate the duration between
    2 dates.…

    1 vote
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  19. ETL: Initialize variables via PALO.Data / OLAPData function

    Thanks for extending the definition of variable default values
    by groovy script and Jedox settings.

    But it would be much more helpful to initialize variables directly via a cube lookup (PALO.Data / OlapData function).

    We have several configuration cubes where settings are maintained.

    It is currently very clumsy and annoying to initialize the variables based on the confiuration cubes.
    You need a LoopJob or TableLoop, a ConstantTable Extract, and a Field Transform with OLAPData to simply set one value. (see attached example)

    The structures you need to build for variable initialization are sometimes more complex than the process itself.
    This…

    4 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  20. ETL: update/replace rules by ID

    It would be great to update/replace specifics rules by ID in rule load.

    Currently rules are matched based on the definition of the rule. (so the identifier is the rule script itself)
    That means if you need to replace a certain rule - you have to relaod all rules in total.

    3 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4
  • Don't see your idea?

Jedox Feature Voting Tool

Feedback and Knowledge Base