A drill-through definition specifies a target for drill-through access, the conditions under which the target is available (such as the scope), and how to run or open, and filter the target. In Reporting Center, a drill-through definition is associated with a source package. The drill-through path defined in the drill-through definition is available to any report based on the source package it is associated with. The target can be based on any target package in Reporting Center and can be stored anywhere. For example, all reports authored in a folder linked to this package can access any drill-through definition created in this package.
Note: For reports created in Report Studio (Professional authoring mode), you can define drillthrough access in specific reports by setting up the drill-through definition in the report instead of in the package, or restrict drill-through access by changing report settings so that the report is unavailable as a drill-through target. For more information, see the Report Studio Professional Authoring User Guide. Reports created in Report Studio Express are not supported as drill-through targets.
You can define drill-through definitions between reports created in the different ACI studios, and reports based on different packages and data sources.
The target report must exist before you start creating the drill-through definition in Reporting Center. Drill-through targets can be reports, analyses, report views, PowerCube packages and queries.
Drill-through definitions support both dimensional and relational packages, and are available to Query Studio, PowerPlay Studio, and Report Viewer.
