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

    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 →
  2. 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!

    4 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 →
  3. New extract type for SAP Connector: ABAP Report

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

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

    9 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 →
  5. 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.

    8 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 →
  6. 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.

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

    17 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 →
  8. 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

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

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

    15 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. 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, ..)

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

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

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

    We’ll send you updates on this idea

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

    15 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 →
  15. 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 :)

    3 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 →
  16. 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

    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 →
  17. 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%.

    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. Renaming File Connection should also update 'FROM' in SQL Statement of dependent File Extracts

    Example:
    Given are
    - a File Connection test01_10 and
    - a dependent File Extract test01_20 with a SQL-Statement:
    SELECT * FROM "test01_10";

    If I rename the File Connection test01_10 then I get asked whether I want to also update dependent components. Choosing YES updates the File Extract's connection but not the SQL statement which now is wrong.

    I suggest to either look for and update the connection name string in all SQL statements. Or introduce a generic variable which can be used in the SQL statement.

    2 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 →
  19. create folders in ETL integration manager (by user)

    instead of forcing the creation of folders by component type (e.g. "Cube", "Dimension", .. for extracts), it would be very much appreciated, if it was possible to create a folder-structure by user.
    Potentially, these folders could also span across "E", "T" and "L", to allow even easier structuring by topics.
    Not sure though, if the latter brings more advantages or disandvantages. Please post your comment.

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  20. Sending the mail with Cc and Bcc in the Jedox ETL

    I tried the following code in the Groovy in the Jedox ETL.

    -----------------------------------------------
    import javax.mail.Message;
    LOG.info("BCC:" + Message.RecipientType.BCC);

    mailer = API.getMailer();
    mailer.setServer();
    mailer.addRecipient(Message.RecipientType.BCC,"e-mail address");
    //mailer.addRecipient("e-mail address");
    mailer.setSubject("test");
    mailer.setMessage("test!");
    mailer.send();
    -----------------------------------------------

    And then, I get the following error.

    Unable to execute groovy job: groovy.lang.MissingMethodException: No signature of method: com.jedox.etl.core.util.MailUtil.addRecipient() is applicable for argument types: (javax.mail.Message$RecipientType, java.lang.String) values: [Bcc, e-mail address]

    And I can use the following code,
    but it send email only with To.

    mailer.addRecipient("e-mail address");

    At this time , it is not supported to send the mail with Cc and Bcc in the Jedox ETL .

    So, Could you please…

    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 →
  • Don't see your idea?

Feedback and Knowledge Base