Jedox Ideas
Let us know how we can make Jedox even better!
Let us know how we can make Jedox even better!
If I configure persisted drill-through in a cube, and in a report select Drill-through, then Jedox shows detailed data from PostgreSQL database. This is great in case of Actual data with detailed information.
But in the same time the budget version has data only in Jedox cube, and Drill-through in this case does not show anything.
It is necessary to have an option to switch datasource of Drill-through between a cube and PostgreSQL. It could be done automatically - if no data in PostgreSQL then it looks in a cube.
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. If you can add further information about the context of this feature, please add it here so we can evaluate it more fully.
3
Future Consideration
Hello,
To do so, in svs script, I added this code after ($ret = $this->DrillThroughETLRest($database, $cubename, $arg, $sid, $area);)
// if error message starts with "No Drillthrough defined" make Cube-Drillthrough
if (strpos($ret, 'No Drillthrough defined') === 0 || strpos($ret, 'no result') === 0) {
$ret = $this->DrillThroughCube($database, $cubename, $callerConnection, $dimListNonVirtual, $area, $drillDownArea);
}
---
(this is custom script and it has not been reviewed by jedox)
---
public function OnDrillThroughExt($database, $cubename, $mode, $arg, $sid) { // string
// sep_log("<< USING SAMPLE SCRIPT PLEASE ADJUST TO MATCH YOUR CONFIGURATION >>");
sep_log("<< OnDrillThrough database: $database cube: $cubename >>");
$callerConnection = palo_init(_JEDOX["OLAP_HOST"], _JEDOX["OLAP_PORT"], $sid);
$dimListNonVirtual = palo_cube_list_dimensions($callerConnection, $database, $cubename);
$useVD = false;
$drillDownArea = array_fill(0, count($dimListNonVirtual), null);
$area = $this->DrillThroughGetArea($database, $cubename, $callerConnection, $dimListNonVirtual, $arg, $useVD, $drillDownArea);
$ret = $this->DrillThroughETLRest($database, $cubename, $arg, $sid, $area);
// if error message starts with "No Drillthrough defined" make Cube-Drillthrough
sep_log($ret);
if (strpos($ret, 'No Drillthrough defined') === 0 || strpos($ret, 'no result') === 0) {
$ret = $this->DrillThroughCube($database, $cubename, $callerConnection, $dimListNonVirtual, $area, $drillDownArea);
}
palo_disconnect($callerConnection);
return $ret;
}