Linking exception events to reports

You can link exception sets in Data Quality Exception Console to related reports in IBM® InfoSphere® Information Governance Dashboard.

Before you begin

InfoSphere Information Governance Dashboard must be installed.

You must have access to the server on the services tier that contains the directory InformationServer\ASBServer\bin and the permission to run commands from this directory.

About this task

When you set up a link between Data Quality Exception Console and InfoSphere Information Governance Dashboard, you enable the View Report button in Data Quality Exception Console. The selected exception sets are displayed in the exception management reports of InfoSphere Information Governance Dashboard.

Procedure

  1. In your web browser, type the URL http://<Server>/<Cognos_URL>/, where <Server> is the Cognos® server and <Cognos_URL> is the rest of the URL. For example, the URL might look like http://mycognosserver.mycompany.com/cognos10/.
  2. Click Information Governance Dashboard > Exception Managment Workspace.
  3. From the Actions menu, select Share Workspace. Copy the URL that is displayed in the Share Workspace window and paste it into a text editor. In the text editor, replace the localhost portion of the URL with the IP address of your Cognos server to ensure that you can access the URL remotely.

    See this example URL: 

    http://localhost:80/cognos10/cgibin/cognos.cgi?b_action=xts.run&m=portal/main.xts&m_redirect_windowmode=2&m_redirect=%2f
cognos10%2fcgi-bin%2fcognos.cgi%3fb_action%3dxts.run%26m%3dportal%2flaunch.xts%26ui.gateway%3d%252fcognos10%252fcgi-bin%252f
cognos.cgi%26ui.tool%3dDashboardConsole%26ui.action%3dedit%26ui.atompath%3dPublic%252520Folders%252f
Information%252520Governance%252520Dashboard%252fWorkspaces%252fInformation%252520Governance%252520Dashboard&m_redirect_uitool=DashboardConsole
  4. Set the value for the link. Run the iisAdmin command from the InformationServer\ASBServer\bin directory on the services tier computer. Replace the variable DASHBOARD_URL with the URL that you constructed in Step 3.
    • For a Microsoft Windows operating system, use the following command:
      iisAdmin.bat -set -key com.ibm.iis.dqec.ui.igd.url -value "DASHBOARD_URL"
    • For a UNIX or Linux operating system, use the following command:
      ./iisAdmin.sh -set -key com.ibm.iis.dqec.ui.igd.url -value "DASHBOARD_URL"
  5. If Data Quality Exception Console is open, close it and then reopen it to enable the changes.

    You can now open the Exception Sets page of Data Quality Exception Console, select an exception set, and click View Report. The report is displayed in InfoSphere Information Governance Dashboard.

Parent topic: Configuring and managing exceptions in Data Quality Exception Console