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!

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Make LOG class available in groovy-based variables

    Expose the LOG class in the groovy-base variables for better debugging purposes

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  2. Flexible Tree Transform with Filter and Concatination

    Today, many different technical fields are needed for creating hierarchies in Dimensions. As Jedox needs a unique element for different consolidations in hierarchies, I find it often to be the case to have a lot of fields just for that purpose.

    Suggestion: implement a flexible tree transform to make up for that an include the possibility to
    a) filter columns
    b) concat data fields (maybe a fixed number of 3)
    in the table transform.

    => This would make the ETL cleaner and easier to read (less reverse-engineering what elements are needed / what purpose they have). Jedox-specific data fields for…

    4 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  3. Instantly (one click) use/set variables (shown in monitor) used by previously ran ETL-task

    ETL jobs often get data from user input or automatically retrieve variable values. This is used to temporary 'overwrite' variable defaults. When debugging an ETL process with many variables you need to manually change all used variables in order to reproduce a previously ran ETL job. It would be nice to have a single button to set all used variables from a specific ETL job to the actual used values (as shown in the integrator logs).

    4 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add monitor log filter option for custom script debugging

    As ETL-developer/Integrator you can write custom debug within (Groovy) scripts to show specific info in monitoring/logging. Long and complex ETL-processes return many pages of log info, most not interesting for debugging custom scripts. Please add an additional log method filter (for example: UINF (LOG.uinf) and an extra filter option (tag?) in the integration monitoring to filter user based debugging. makes

    1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  5. Allow user-defined nodes in Integrator

    User-defined nodes should be allowed in the integrator.

    Currently, there are "Global Projects" and "Models". If a new node can be created for models, this should technically be no problem for other user-defined nodes.

    These can be used to structure more complex projects – and it would allow partners/consultants to separate different customer projects (for this, additional sub-projects and/or folders would also be helpful).

    But as a start it would be a huge benefit to use the current structure and just add a user dialogue to add/delete projects nodes on the same level as "global" or "models".

    8 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  6. Always show additional optional settings in integrator

    In Jedox integrator the additional optional settings are not expanded.

    Therefore you always have to expand this block first to check if there is anything configured there.

    >> All blocks should always be expanded at any time.
    >> Alternatively all blocks should be expanded if they contain any settings other than default.

    4 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  7. 3 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  8. Delete a job and its dependencies

    It would be great to be able to delete a complete job with its dependencies. Maybe with an option to prevent the deletion of the component that are used elsewhere. For instance:

    Connection1 => Extract1 => Transform1 => Transform2 => Load1 => Job1

    Connection1 => Extract1=> Transform3 => Transform4 => Load2 => Job2

    I would like to delete all what is under Job2 but keep Connection1 and Extract1 since they are used by Job1.

    3 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  9. Automatic (De)-normalization Fields

    wenn you have several columns to denormalize or normalize you have to put them manually in the fields. This is now easier since you can grab the input columns but this is not dynamic.

    This would be awesome if instead of entering the name of the field to normalize or denormalize you could enter a regex.

    Let's take an example to illustrate that. Let's say that you have the following input:

    Country | Year | Datatype | Month1 | Month2 | Month3

    I use a TableNormalization to turn the columns Month1, Month2, Month3 into rows.

    Now let's say that my…

    4 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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.

    2 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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.

    3 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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.

    5 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  15. 1 vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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)

    6 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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.

    2 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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.

    2 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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…

    3 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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 :)

    5 votes
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4
  • Don't see your idea?

Feedback and Knowledge Base