Configuring Drill-Down Links
To create reports based on specific number value data, you can implement drill-down links in Business Intelligence Analysis. This will turn all non-calculated number fields into links which, when clicked, bring up a configurable data grid that enables you to quickly view more details for that data point without having to reconfigure your report. Follow the directions below to turn on drill-linking.
Note: Calculated members are unavailable for drill-down at this time.
Note: Drill-down links will not work in reports that have filters that are not being used. If you have any filters in an Analysis report, they must be used in the report in order to view drill-down links.
1. Open the Analysis report that you want to add drill links to.
2. Go to the More actions and options,
, menu in the top bar of the report, and select Report Options from it. 3. Select the Show drill-through links on Measure cells checkbox. Then click OK. The measure fields in your report will turn into links.
4. Click on a drill-down link to see a data grid that shows all of the available details for that value.
5. To add or remove columns from the grid, click on the down arrow on the right side of any column and select the Columns sub-menu. From there you can select which columns you want to appear. You can also sort by ascending or descending values for any column through this menu.
You now have drill-down links for numeric, non-calculated members.