Drill-throughs provide the ability to view a target report using a set of parameter values defined by a drill path and determined by the context of a source report. A drill path is an object in the content store that is contained in a package.
The drill-through definitions tool will allow drill-through targets to be set for packages. Drill-through targets can be either analyses, or parameterized reports such as reports, queries, or report views. Drill-through definitions support both dimensional and relational packages.
The drill-through targets defined in a package are available to Analysis Studio, Query Studio, and Report Viewer.
Note: Cubes can be used as drill-through targets only if they are set up for drill-through in the Transformer model. For more information, see the Step-by-Step Transformer Guide.
You can create a new drill-through definition, or edit an existing one.
Steps to Create a Drill-through Definition
In ATG Reporting Center, in the upper-right corner, click Tools, Drill-through Definitions.
Click a package name to create a new drill-through definition for that package.
Click the new drill-through definition button on the toolbar.
Type a name for the drill-through and, if you want, a description and screen tip. Click Next.
Set the scope and target, and click Next. The scope specifies the drill-through links that are available in the source reports.
When working with dimensional data sources such as Microsoft SQL Server Analysis Services Cubes, setting the scope for a level does not cover the descendants of that level. A query item will match a query subject scope, but a member will not match a parent level.
For example, a context member from a day level will not match a scope of month. As a result, if your report context has only the day level, this drill-path will not appear in the list of possible drill-targets. If you need to permit matching at more than one level, leave the scope unassigned.
Specify the action for a drill-through link, and the prompt values. Click Bookmark References to specify a bookmark reference to pass to the target report.
Click Finish. The default action is to run the target report, analysis, or query. If you change the action to run the most recent report, you do not need to specify prompt values.
Steps to Edit an Existing Drill-through Definition
In ATG Reporting Center, in the upper-right corner, click Tools, Drill-through Definitions.
Click a package name to view its drill-through definitions.
Click the set properties button on the actions toolbar to the right of the drill-through definition that you want to modify.
Click the Target tab.
Make the necessary modifications, and then click OK.