Let us know how we can make Jedox even better!
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.
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.