Open icCube dashboard (with parameters) by clicking on an element

Question

How can I set an event on an icCube dashboard that opens another dashboard? (and that passes the selection parameters)

Answer 1

icCube helped me on a similar request from my side to allow a "drill-to-a-URL when clicking on a row/column in a chart" question. You can modify this to set the URL to open another dashboard.

The following set-up opens a new browser tab with google searching for the row clicked in the chart and the setting of the year filter:

Steps:

1. Define one or more On Click events in your chart, for example: On Row Click --> event:"country";
2. Define a MDX Filter on e.g. Year, call it: "year";
3. In the Widget JS Hooks, set the "On Send Event";
4. Add and modify the following code (this code opens Google with your parameter):

/**
 * Tips:
 * type  - fired event type,
 * event - fired event object (same as first element of args array),
 * args  - list of arguments passed to fireEvent function
 * 
 * Function may return:
 *  - event - will replace first element of args
 *  - args  - will replace whole args array
 *  - false - will cancel event
 */
function(context, $box, type, event, args) {    
  let yearEvent =  context.reportingContext.eventMgr_._eventValues["year"];
  if (!event.isEmptyEvent() && yearEvent && !yearEvent.isEmptyEvent() ) {      
    let win = window.open("https://www.google.com/search?q="+ event.caption() + "+" + yearEvent.caption() , '_blank');
    win.focus();
  }
  return args;
}

Result (test)

When you click on e.g. country "Netherlands", with filter setting "2011" --> google opens with a search result for "Netherlands 2011".