The Drill Across component caches data in an Interactive Reporting Studio document, dynamically retrieves un-cached data just-in-time, and drills into the data. The technique is also available in Interactive Reporting Studio as Drill to Detail, and in the Conditional Sub-Queries component.
Using the Drill Across component, you can double-click a cell (using the OnCellDoubleClick event) in an embedded active pivot (source embedded pivot or SEP) in a dashboard section. The intersection of the side label and top label values, plus active local filters and query filters becomes the context for the drill across operation, and you are taken to a target embedded pivot (TEP). For example, you are examining a general ledger pivot and you use the drill across operation to navigate to view the contents of a cell value, the underlying invoice, freight costs, and salaries. At any point, you can drill back to the launch point.
Each SEP is configured to have one or more associated TEPs. TEPs can reside in the same document as SEPs or in different documents. The relationship between SEPs and TEPs is through a tabular structure, such as an Excel spreadsheet or a database table. (Replicate the table in all documents that contain SEP and TEP configuration.)
The Drill Across component includes the following sections:
Hysl_idc (Inter-document Communication)—Manages the initiation of drilled-to documents and the passing of information between documents; initiaties drill across and documents responding to drill across requests
Hysl_drillAcross (Drill Across)—Manages the gathering of the drill-point intersection, local filters, and query limits, and makes the drill request to the correct document by using Hysl_idc; administers the configuration of the sources and targets through a table; uses Hysl_queryDatamodel to discover the query limits set in the source; and uses internal structures to execute a subordinate query if responding to a drill request.
Note:
The Drill Across component functions with Interactive Reporting Studio documents in Release 9.0 and later.
Note:
The Drill Across component does not work in EPM Workspace since the OnCellDoubleClick event is not available, and it is not possible to communicate between documents. Drilling across to a separate document is not available in Interactive Reporting Web Client since only one document can be active at a time. However, if the SEP and the TEP are in the same document, the feature is available to users of Interactive Reporting Web Client.