Creating an Excel Spreadsheet

Excel spreadsheets should contain column headers similar to those found; for example, in the Sales Dashboard_esm.bqy which is installed with the Drill Across component.

Source Document	Source Section	Target Path	Target Document	Target Section	Target Query	Target Label	Target Service Key
Sales Dashboard	Summary Sales	c:\Targets	Costs Dashboard	Costs Detail	Costs Detail Query	Costs	Hysl_drillAcross

Column header definitions include:

Source Document—Interactive Reporting Studio document from which to drill across (The document contains a source pivot that enables you to drill to a target section. The _esm suffix is not required for the file name as the Drill Across component works with ESMs and runtime releases)
Source Section—Interactive Reporting Studio document section that contains an embedded pivot object that is the launch point of the drill across operation
Target Path—Absolute path to the folder of the target document (The column can be empty if the target document is in the same folder as the source document)
Target Document—Target Interactive Reporting Studio document which is drilled into (The document can be the same as or different to the source document)
Target Section—Target Interactive Reporting Studio document section that is displayed when the drill across is complete
Target Query—Target Interactive Reporting Studio document query section (When a drill across operation is performed, query filters, local filters, and the intersection of the pivot dimensions from the source document are applied as filter values to the Interactive Reporting Studio document query section)
Target Label—Optional: User-friendly name for the target section, which is displayed in preference to the section name
Target Service Key—For the Drill Across component this is Hysl_drillAcross

To create an Excel spreadsheet:

Create an Excel spreadsheet that maps the sources and targets.
Save the spreadsheet, import it into your dashboard, and rename it to be IDC Table.

Note:

IDC Table can also be implemented as a database table. The names and positions of the columns are not important as these are selected in the Drill Across Properties frame.