Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Not Planned
Workspace Jedox Platform
Categories Integrator
Created by Guest
Created on Oct 8, 2024

Additional column for drillthorugh

It would be very helpful to be able to add columns to an existing drillthrough database. Currently this is not possible. There is no control over the drillthrough database at all (only via ETL Load process). This is a pain once there are more columns for drillthrough coming along later in the project and ETL is not adding them to the database. Instead new columns will get ignored. Also the ability to remove columns as well as remove data from the drillthrough database would be very helpful. With on-prem installation this was all possible by connecting via H2 client and user sa. There was full control over the drillthrough data. Now it has become a "black box". Would be great to get the access back and gain control over the tables / columns and data.

  • ADMIN RESPONSE
    Nov 8, 2024

    Thank you for sharing your idea with us. After evaluating this suggestion, we will not be implementing the feature to enable direct column modifications in the internal drillthrough database. However, as an alternative, we recommend using a self-managed PostgreSQL or SQLite database to retain full control over columns, data, and tables, similar to what you previously had with an on-prem setup. This approach provides greater flexibility than our internal database, which, by design, limits certain management functions.

  • Admin
    Stefan Veličković
    Reply
    |
    Oct 18, 2024

    Hi there,

    The status was for internal feedback gathering.

    After discussions with devs since we cannot commit to the new feature we come up with some alternatives:


    One possible solution is transitioning to a customer-managed database and connecting it to the persisted drillthrough.

    While we do offer a database as a service, it's not necessary for this approach.

    If you opt for an external PostgreSQL database, you may have slightly less control than with your own managed database, but you’ll still have access to all the essential features.

    The concern about "native functionalities being limited" doesn't apply here, as a self-managed database gives you full control.

    You could also consider SQLite as an option for managing drillthrough data.

    Lastly, the limited control we mentioned earlier refers specifically to our internal drillthrough database—while we can enhance it with certain features, it likely won’t offer the same level of control you had with the on-prem setup.

  • Guest
    Reply
    |
    Oct 11, 2024

    you changed to status "needs feedback", what feedback do you need?