Open the drill down report or dashboard in new window based on click of the report values

Dashboard Designer
, , , ,
#1

Hello Helical Insight,

Hello, I am using helical insight EE version 5.0. I am creating the report as card and want to drill down on the values. However, I want the child report should open in a new window, not in the same panel or on dashboard. Is there some way to configure that.

Thank You,
Netta.

#2

Hello Netta,

This can be achieved by implementing JavaScript.

Inject this in POST EXECUTION of your parent script

var elements = document.querySelectorAll("#hi-report-4c8d7414");

var clickHere = function() {

var titleName = properties.card.title;

window.open("http://216.48.177.235:8085/bi-ee/#/report-viewer?dir=000_Card_DrillDown&file=childReport.hr&mode=open&travel_medium="+titleName, "_blank");

};

for (var i = 0; i < elements.length; i++) {

elements[i].addEventListener('click', clickHere, false);

Let us understand the above code.

  • This is your parent report unique ID : #hi-report-4c8d7414 change this as per your current report ID, you can take help of developer tools to inspect the current page and take the ID from it. This you can do at the report level itself.

  • This is your child report path : http://216.48.177.235:8085/bi-ee/#/report-viewer?dir=000_Card_DrillDown&file=childReport.hr&mode=open you can open the child report in the new window from the file browser to see the path of your child report or can create on your own based on your base URL, directory name and file name.

  • This is the list of variables that you want to pass to the child report.In this example the child drill down report is having a filter called travel_medium and based on where we are clicking that is being passed as value to the child report filter and child report is getting opened travel_medium="+titleName

  • This is the value properties.card.title in the parent report that we are passing.

Thank You,
Helical Insight.