Check the drill-through target:
Confirm that the drill-through users have access to the target.
Hide the target from direct access if you want(p38).
If necessary, check what parameters exist in the target.
When a drill-through definition links objects in different packages, you must consider the data types used in both the source and the target object. Review the structure and values of data that you intend to pass in the drill-through, and ensure that the created parameters are appropriate for your scenario, if you have defined parameters, or that dynamic drill through will work successfully. For more information, see Conformed Dimensions and Business Keys.
In Reporting Center, in the upper-right corner, click Launch, Drill-through Definitions.
Navigate to the top level of the package for which you want to create the drill-through definition.
Click the new drill-through definition button on the toolbar.
Note: If you do not see the drill-through definition button, then confirm that you are at the top level of the package, and not in a folder in the package. Drill-through definitions must be stored at the package level.
Type a name for the drill-through definition.
If you want, type a description and screen tip, and then click Next.
Follow the instructions on the screen:
If you wish, restrict the scope to a query item or a measure in the source.
If the target contains parameters, you should set the scope to the parameters that are mapped to the target report. For more information, see Scope.
Select the target from any package available in Reporting Center.
If BI PowerPlay targets are available, then you must choose whether to set the target as a report or a PowerCube.
Click Next.
In the Action section, specify how to open the target object when the drill-through link is run and if you chose to run the report, in the Format section, specify the format to run the report in.
Users may be able to change the Action settings when they use the drill-through link. If you are using bookmarks in the target, then you must select the action View most recent report.
In the Parameter values table, specify how to map the source metadata to any parameters that exist in the target report or object.
For example, if you drill through between OLAP data sources, then members are mapped to each other. If you drill through from an OLAP to a relational data source, then the source value (member) is mapped to the query item name (value).
Usually, every parameter that exists in the target should be mapped to the source metadata. If not, then the report user may be prompted for any missing values when the drill-through link is used.
Click Map to metadata, or click the edit button.
In the screen that appears, select the metadata from the source to map to the target parameter.
If the source package is dimensional, you can select what property of the source metadata item to use in the mapping. By default, the business key is used for a relational target, and the member unique name is used for a dimensional target.
Repeat for each parameter in the list.
In the Display prompt pages section, specify when the prompt pages will appear.
You can only set this action when there are parameters in the target report and the target report will be run. If you change the action to View most recent report, for example, for bookmark references, the Display prompt pages property is disabled because you will use a previously-run report.
You specify prompt settings in Reporting Center (Report Properties, Prompt for Values).
Click Finish.
Run a report from the source package, and test the drill-through link.
Note: The drill-through definition is associated and stored with the source. Errors related to the target are only generated when you run the drill-through links, not when you save the drillthrough definition.
Steps to Edit an Existing Drill-through Definition
In Reporting Center, in the upper-right corner, click Launch,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.
Note: If you do not see the drill-through definitions, check that you are not in a folder in the package. Drill-through definitions are all stored at the root level of the package. If you do not see a specific drill-through definition, confirm that you have the correct permissions.
Click the Target tab.
Make the necessary modifications, and click OK.
Run a report from the source package, and test the drill-through link.
Note: The drill-through definition is associated and stored with the source. Errors related to the target are only generated when you run the drill-through links, not when you save the drillthrough definition.
