Drilling through to another report

You can drill through from one report to another using the Mashup Service REST interface. You can get drill-through information from LDX and HTML outputs.

This example is based on a drill-through link from the source sample report Recruitment Report to the target sample report Positions to Fill, which are included in the GO Data Warehouse (analysis) package. See Sample drill-through definitions in LDX format for a description of the LDX elements that support drilling up and drilling down.

By default, reports returned in HTML format do not include drill-through information. Use the drillurls option to include drill-through information in the HTML output.

The equivalent HTML snippet for the drill-through definition for this report is as follows.

<td class="S50">
  <div style="display:none" class="ctx">102</div>
  <span class="S45" 
        drills="{"drillthroughs":"/rds/reportData/searchPath/content/
              folder[@name='Samples']/folder[@name='Models']/
              package[@name='GO Data Warehouse (analysis)']/
              folder[@name='Reporting Report Samples']/
              report[@name='Positions to Fill']?p_Year selection=
              <![CDATA[[Employee recruitment].[Time].[Time].[Year]->[Time].[2011]]]>"}"
              >Days to fill
  </span>
</td>

The drillDefinitions element contains a drill element that contains the search path (targetPath) of the report to drill through to and parameter name (name) to use in the prompt request.

To drill through to the Positions to Fill report, run a report using the targetPath value as the search path and including a prompt with a prompt name of pYear and a value of 2011.

The drillThrough JavaScript sample program illustrates the use of drill through.