Drill down in cross tab

General
, , , ,
#1

Hello Team,

I am using Helical Insight 4.1 GA and i have created a CROSS TAB visualization. Now i want to drill down to some another report on click of this CROSS TAB report. How can we apply drill down to cross tab ?

Thank You,
Netta.

#2

Hello,

This below solution will work I cross tab of enterprise version of or/below 4.1 enterprise version of Helical Insight.

There is no default UI based DRILL DOWN capabilities available for CROSS TAB report with Helical Insight 4.1 GA. But one can always write custom Javascript and inject in the JS placeholders at report level. For your reference, we have created a small sample code which will allow you to DRILL DOWN in CROSS TAB with HI 4.1. Modify this sample with your respective values and inject into JS Editor at report level. Below is the sample :

var id = hi_container.get(“renderId”);
var chartId = ‘#main’;
if(id != ‘’){
chartId = chartId+’-’+id;
}
hi_container.set(“postExecution”,function(c){
$(chartId+’ tr th:nth-child(1)’).click(function() {
var txt = $(this).context.innerHTML;
reportRender(txt);
});
});
function reportRender(txt) {
window.open(“OPEN_IN_NEW_WINDOW_URL_OF_CHILD_REPORT&mode=open&FILTER_NAME=”+txt,"_blank");
}

In the above code in window.open you have to specify the path of the child report, filterlabel etc.

Thank you,
Helical Insight.