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

    15 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  2. Spashing Function in the ETL

    The main idea is to integrate splashing function ( COPY, LIKE ... ) directly in the integrator manager using groovy job or anything else.

    7 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  3. Ability to turn off cube transaction logging during batch data load

    When loading data in high volume and in high frequency, the cube transaction logs are "exploding" in terms of size. As this data is loaded from external source, the transaction logging would not be necessary: data can be always restored from original data source by simple reloading data.

    In order to avoid gigantic log files, the transaction logging should be possible to turn off temporarily during the ETL load. Similar property is in IBM Cognos TM1 and helps a lot when dealing with log files.

    9 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  4. Layout back to list-view instead of icons

    Posibility to change the layout in the Integrator back to the list-view (like it was before jedox 6 SR3)
    Since Jedox 6 SR3 there are this symbols -> It would be nice if we can configure if there are symbols or lists like before!

    12 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  5. New extract type for SAP Connector: ABAP Report

    Theobald software already supports ABAP reports - see this click through demo (attached).

    1 vote
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  6. Navigating from scheduled task to ETL component

    Navigating from a scheduled task in task scheduler to the actual ETL component (groovy/ standard job, etc) would be handy. Right clicking and selecting an option to navigate to the respective ETL component would save a lot of time in implementations with a large number of scheduled jobs across many projects.

    16 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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 Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  8. ETL: change variables without leaving the current component

    It would be great to be able to change default values of variables
    without leaving the current component.
    ..e.g. via a sidebar or popup.
    This would make development and testing more efficient.

    Currently whenever you need to change a variable value while you are editing an extract, transform or load you need to jump into the variables tree, which implicitelly closed the current view.

    16 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  9. Tomcat multicore support

    As I have been informed by Jedox Dev team, the ETL-Server (Tomcat Service) is running one job per CPU core. This behaviour is mainly slowing down our ETL projects since a huge amount of data has to be proceeded.
    The number of cores that should be used in parallel within one job should be configurable.

    35 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  10. Tooltips in Process FlowChart => based on Component Description

    Each Extracts/Transforms/Load component in Jedox Integrator has a description field.

    The content of the description field shoud be shown as a tooltip in the process flow chart on mouse over the respective component.

    This would make the maintenance of a project esp. over longer times much easier by providing fast and good transparency about the project.

    Thanks

    4 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  11. SAP extract from Extractors

    Enable extracting data from Extractors in SAP.
    Benefits:
    - works in BW and ECC (BW not required)
    - delta-capable. SAP managed process for easier incremental loading and faster loads
    - built-in business logic like joins implemented already by SAP
    - proven. SAP uses these to load BW
    - customizable

    6 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  12. Improve usability of Groovy function editor

    Actually the groovy function editor is not reflecting the high maturity which Jedox Integrator has reached now.
    You cannot even resize it if you have to develop a more extended logic.
    More real-time validation of the code and debugging support would also bring a big value add.

    27 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  13. Description of Load modes directly in Jedox Integrator

    When you configure a Load step in Jedox Integrator it would be great to display a description of the selected Load mode (create, update, add, insert) next to the dropdown list.

    I guess everyone who is not really everyday working with the Integrator is a bit annoyed by all the time going back to the knowledgebase to verify the detailed meaning, distinction and implications of those modes for certain different targets (dim, cube, relational, rule, ..)

    5 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  14. Monitor: Auto-Refresh of Monitor Output does not scroll to bottom (=newest entry) automatically

    The monitor refreshes after some seconds but the new output is not visible because scrolling to the bottom of the output is not done automatically.
    This would be nice!
    Another way: Reverse the output's display (newest lines on top) and there is no scrolling / displaying-problem any more.

    14 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  15. Cache for Tablejoins

    Table, Tree (etc) Joins should be able to be cached in memory or at disc in the same way caching of extracts is possible

    12 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  16. Excel extract auf wss Datei ignoriert aktuell formelbasierte Zellwerte Führt man im ETL einen Excel extract auf eine wss Datei aus, so werd

    Excel extract auf wss Datei ignoriert aktuell formelbasierte Zellwerte

    Führt man im ETL einen Excel extract auf eine wss Datei aus, so werden momentan nur fix eingetragene Zellwerte ausgelesen.
    Von Zellen die eine Formal, eine Palo Formal oder ein Subset enthalten wird der entsprechende Wert nicht ausgelesen.

    Es würde die Möglichkeiten des Excel extracts stark erweitern, wenn dies möglich wäre

    6 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  17. Drill Through with more sources

    At the moment drill through works only with one database.
    Filling a cube from different sources with the need of different drill through information is not possible.
    It would be nice to use different databases as source for drill through.

    26 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  18. RANGE join, RANGE lookup and RANGE map

    Currently in the ETL TableJoin Transform we only have the possiblity to define a join on an exact match of key fields in the right and left data source.

    It would be great to be able to define a matching range (intervall) for the right data source.

    In SQL this would be:

    SELECT * FROM leftSource JOIN rightSource
    ON (leftSource.joinField >= rightSource.range_start)
    AND (leftSource.joinField <= rightSource.range_stop)

    Example:

    left source
    -------------
    column "joinField": 250

    right source
    ---------------
    column "range_start": 200
    column "range_stop": 300

    This would then give a matching record.

    Same request is applicable for
    Map-FieldTransform and Lookup-FieldTransform!

    Thanks :)

    6 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  19. support for amazon s3, s3-compatible and eventually openstack swift as storage

    It would be interesting accessing files from s3 / s3-compatible object storage directly in Jedox as a connection, or event in jedox-web.

    Object Storage is extrem convinient as file interface, and allow easyly to interact with other systems :
    - third party systems write there Data on the object store (for jedox and maybe other programs too)
    - Jedox can read that file and use it for ETL purposes as connection or extract.

    A "nice to have" would be, being able to use wildcards, and access all files with the same pattern at one time : my_import_files_*.txt

    3 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  20. ETL project description input text field: Expand from current "height: 200px" to e. g. "height: 100%"

    Currently the text input field for describing an ETL project has only 200px in height. Most of the browser window is unused empty space. If there is a long description (= over 200px in height) one has to scroll.

    So please give this input box more space. Maybe 100% or 95%.

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

Jedox Feature Voting Tool

Feedback and Knowledge Base