To use IBM Cognos product documentation, you must enable JavaScript in your browser.

Drill Through to Another Report From a Map

You can link regions or points on a map to another report. For example, on a map of the world, you can specify that when you click on China, a map of China opens.

Steps to Set Up a Filter in the Target Report
  1. Open the target report.

  2. From the Data menu, click Filters.

  3. On the Detail Filters tab, click the add button .

  4. In the Available Components box, click the Source or Data Items tab to select the data item to use.

    For example, to open the target report when Canada is clicked in the source report, expand Countries and double-click Country.

  5. In the Expression Definition box, type an operator after the data item or select an operator from the Functions tab and then enter a value.

    For example, to open the report when Canada is clicked in the source report, the expression would be as follows:

    [Country]='Canada', where [Country] is the name of the data item in the package.

  6. Save the target report.

Steps to Set Up a Drill-through Link in the Source Report
  1. Open the source report.

  2. Select the region layer or the point layer.

  3. In the Data section of the Properties pane, double-click the Map Drills property.

  4. In the Map Drills dialog box, click the new button .

  5. In the Search string box, type the name of the feature to use for the drill-through link.

    For example, to open a report when you click on Canada in the map, search on all or part of the word Canada.

  6. Click Starts with to search for features that start with the search string or click Contains to search for feature names that include the search string.

  7. To include a parent layer’s name in the results of your search, select a layer in the Include parent layer list.

    For example, if you searched for Oslo and you included the parent layer of Countries + Territories, the search result would be Oslo (Norway).

  8. Click Search.

  9. Select a feature from Matching features box and click OK

  10. In the Drill-Through Definitions dialog box, click the new button.

  11. Click the ellipsis (...) button beside the Report box, and select the target report.

  12. Run the report.

When you click the selected feature in the source report, the target report will open.