Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future Consideration
Workspace Jedox Platform
Categories In-Memory DB
Created by Guest
Created on Aug 16, 2024

In a cube with persisted relational ETL drillthrough data, allow cube-drilldown in areas where no relational data is available.

As of version 2023.4, the Jedox drillthrough capabilities have become a native functionality outside of the SVS scripts.

In the KB it says for the mode automatic: drills through if ETL is available, or else drills down.

This suggest that right-click "Drillthrough" on a cube cell returns relational ETL data if available, or else drills down to base cells.


In reality cube drill down only works if there is no relational connection at all for this cube. If only one cell refers to ETL data, for all other cells right-click "Drillthrough" returns "No data returned for this area."


It's a common scenario to have actual data with ETL drillthrough (e.g. Orderlines) and Budget as simple data entry. In this case it's very inconvenient to only have one option: either you get ETL drillthrough for the actuals and nothing for the budget, or you get drilldown for every cell (but no drillthrough for actuals).


So please consider to combine these to native functions: In a cube with persisted relational ETL drillthrough data, allow cube-drilldown in areas where no relational data is available.

  • ADMIN RESPONSE
    Aug 23, 2024

    Thank you for your great idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog.