Esri Maps for IBM Cognos (v6.1 Archive)

This is an archive related to a previous version of Esri Maps for IBM Cognos. If you need the current version go to http://doc.arcgis.com/en/maps-for-cognos/.

Configure an interactive behavior to drill through to other reports

You can set up an interactive behavior to drill through to other reports when report consumers press points or regions on the map or press the Drill through button on a feature's pop-up window. A drill-through behavior runs and displays other reports containing related data associated with the specified point or region. This behavior can be configured on layers created from IBM Cognos data, feature service layers, and clustered point layers. For dynamic map service layers, this behavior can only be configured for click actions on the map.

To configure this behavior in Esri Maps for IBM Cognos, you must first configure a source report and a target report in Report Studio. To learn more about configuring source and target reports in Report Studio and about specific drill-through settings, see the IBM Cognos Report Studio User Guide.

To learn more about the interactive behaviors you can configure in Esri Maps for IBM Cognos, see About interactive behaviors.

  1. In Report Studio, set up a target report following the same procedure you would use for any other type of drill-through definition.
  2. Save your report.
  3. In Report Studio, create a source report. Drag Esri Map from the Toolbox tab of the Insertable Objects pane to a report page.

    An empty Esri Map container is created.

  4. Create and populate a new query that will be reserved for the map and not used by any other report items.
  5. Create and populate a query that will be used for the drill-through behavior. The map query may be used for this purpose. The drill-through query must contain data that will be used to fill in the parameters in the target report. For example, if the drill-through will be based on a parameter for states in the United States, the query must contain a data item for states.
  6. Save your report in Report Studio.
  7. Open Esri Maps Designer and browse to the source report. Next to the corresponding map, press Configure to open the map.
  8. In the map configuration window that appears, add data to your map. See Add IBM Cognos data to your map.
  9. When you are finished adding data, press the Show map contents button to display the Contents pane.
  10. In the Contents pane, press the arrow to the right of the layer that will be used to trigger the drill-through behavior. This layer will be associated with the drill-through query in the source report (possibly the same query that was used to configure the map layers), so the chosen layer must contain a field with data that will match data in the drill-through query. For example, if the drill-through behavior will be based on US states, the map layer must contain a field listing states.
  11. Choose IBM Cognos interactivity.
  12. Choose Drill through and press Add new.
  13. In the Label box, optionally type a new label for the behavior.
  14. From the Trigger drop-down menu, choose the action type (On click or On pop-up) you want to use for the behavior.
  15. From the Layer attribute drop-down menu, choose the field that will be associated with the drill-through query in the source report.
  16. From the Query drop-down menu, choose the drill-through query.
  17. From the Data item drop-down menu, choose the data item that will be used to populate the parameter in the target report. The data in this data item must match the data in the Layer attribute field.
  18. Type a path to the target report in the Report box or press the Browse button to browse to and choose the target report.
  19. From the Action drop-down menu, choose the way in which you want report consumers to view the target report:
    • To view the latest data in the map, choose Run the report.
    • To have Esri Maps Designer match values from the selection context with data in the target (dynamic filtering), choose Run the report with dynamic filtering.
    • To view the most recently saved output version of the target report from Esri Maps Designer, choose View most recent report.
    • To use the default action specified for the report in IBM Cognos Connection, choose (Default).
  20. If you chose to run the target report in the previous step, choose an output format for your report from the Format drop-down menu.
  21. To open the target report in a new window, check the Open in new window check box.
  22. Press the Configure button beside a parameter to configure it.
  23. From the Method drop-down menu, choose the method you want to use to pass the parameter.
    • If you do not want to pass any value, choose (Default).
    • If you do not want the target report to be filtered by this parameter, choose Do not use parameter.
    • If you want to pass values from a data item to filter the target report, choose Pass data item value.
    • If you want to pass values from a source report parameter to filter the target report, choose Pass parameter value.
  24. If you chose Pass data item value or Pass parameter value to pass the parameter in the previous step, press the Value drop-down arrow and choose the appropriate data item or parameter value.
  25. From the Property to pass drop-down menu, choose the source metadata item to pass. Choose (Default) to pass the business key or choose another property such as the member caption, member unique name, and so on.
  26. Press OK when you are finished configuring the parameter.
  27. From the Display prompt page drop-down menu, choose one of the following options to specify how to display prompt pages:
    • Always—If you choose this option, prompt pages will always be displayed when the drill-through behavior occurs regardless of whether values were specified for the required parameter values.
    • Based on the default prompt settings of the target report—If you choose this option, the prompt settings of the target report will be used to determine whether to show the prompt pages.
    • Only when the required parameter values are missing—If you choose this option, prompt pages will not be displayed when the required parameter values are provided by the drill-through definition. This is the default setting.
  28. Press OK.