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