Drilling up and down in reports

You can drill up or down in an existing report session if the underlying report supports drill operations. You can get drill information from LDX output (for both SOAP and REST applications) and from HTML output (for REST applications only).

The sample report Public Folders > Samples > Models > GO Data Warehouse (analysis) > Reporting Report Samples > Customer Returns and Satisfaction supports drilling up and drilling down. See Sample drill-up and drill-down report in LDX format for a description of the LDX elements that support drilling up and drilling down.

REST example for LDX output

In a REST application use the drill secondary resource type to perform a drill up or down operation. An example is shown here based on the above report:

drill?contextId=50&direction=DOWN

SOAP example for LDX output

In a generic SOAP application, use the drill secondary method to perform a drill up or drill down, populating the direction and contextID of the DrillRequest as above.

REST example for HTML output

By default, reports returned in HTML format do not include drill-up or drill-down information. Use the drillurls option to include drill-up or drill-down information in the HTML output. For the report above, drill-up or drill-down information will be included for 1 for 1 Sports shop as shown here.

<td class="S66">
 	<span class="S65" drills='{"down":"./drill?contextId=50&direction=DOWN",
	"up":" ./drill?contextId=50&direction=UP"}'>1 for 1 Sports shop</span>
</td>

In a REST application use the drill secondary resource type to perform a drill up or down operation. An example is shown here based on the report snippet:

drill?contextId=50&direction=DOWN