Importing event summary reports into Tivoli Common Reporting

To run the event summary reports, connect Tivoli® Common Reporting to a relational database via a gateway. Then, import the report package that is supplied with Tivoli Netcool/OMNIbus into Tivoli Common Reporting.

Before you begin

Several products and components must be installed and configured so that the event data can be stored and displayed. These products are listed in the following table:
Product or component Instructions
Tivoli Netcool/OMNIbus Gateway Configuration Scripts (Reporter Mode) You can obtain these scripts from IBM® Passport Advantage® Online at http://www-306.ibm.com/software/howtobuy/passportadvantage/pao_customers.htm.

To find the scripts on Passport Advantage Online, search for nco-g-jdbc-reporting-scripts 1_0.

Configure the ObjectServer, the gateway, and the relational database according to the instructions that are provided with these scripts.
Tivoli Netcool/OMNIbus An ObjectServer must be created and running.
Tivoli Common Reporting V3.1 is required. For more information about installing and configuring Tivoli Common Reporting, see http://www-01.ibm.com/support/knowledgecenter/SSEKCU_1.1.0/com.ibm.psc.doc_1.1.0/install/tcr_t_install.html. Tivoli Common Reporting is hosted in an instance of Dashboard Application Services Hub.
Relational database You can use an IBM DB2® database, or Microsoft SQL, Sybase, or Oracle.
A Tivoli Netcool/OMNIbus gateway Use the Gateway for JDBC. As an alternative, if your relational database is Oracle, you can use the Gateway for Oracle.

Run the gateway in reporter mode. For more information about the gateway, see the IBM Tivoli Netcool/OMNIbus Gateway for JDBC Reference Guide, which contains information about the JDBC drivers that are required. Alternatively, see the IBM Tivoli Netcool/OMNIbus Gateway for Oracle Reference Guide. These publications are available from this information center.

About this task

To show the reports in Tivoli Common Reporting, you need to create a connection between Tivoli Common Reporting and the relational database. Then, you import the reports package, which is supplied with Tivoli Netcool/OMNIbus into Tivoli Common Reporting and verify that the import was successful.
Tip: Use Internet Explorer to work with Tivoli Common Reporting.

Procedure

To import the reports, proceed as follows. These steps assume that your relational database is DB2. If you are using a different database, make a different selection in step 2.b. The fields in the New Data Source Wizard change to reflect your choice.

  1. Log in to Dashboard Application Services Hub as the tipadmin user, or another suitable user, and access the Administration page as follows:
    1. From the left navigation, click Reporting > Common Reporting.
    2. From the task bar at the top-right side, click Launch > Administration
    3. On the Administration page, click the Configuration tab.
  2. Add the data source connection.
    Perform these substeps with the information from https://www.ibm.com/docs/en/tivoli-monitoring/6.3.0.2?topic=model-tivoli-common-reporting.
    1. Select Data Source Connections and click Add.
    2. In the New Data Source Wizard, complete the fields as follows as you progress through the panels.
      Name
      Type Reporter. The name must be Reporter because it must be identical to the name that is used in the report package.
      Type
      Select the type of relational database, for example DB2.
      Use the default object gateway
      Select this check box.
      DB2 database field
      Type REPORTER. The DB2 database name must match the name in the Gateway for JDBC database schema.
      Signon
      Select this radio button.
      Password
      Select this check box.
      Create a signon that the Everyone group can use
      Select this check box.
    3. Type your DB2 user name and then type and confirm your password.
      The DB2 user name must match the DB2 schema that contains the tables from the Gateway for JDBC database schema. Typically, this user name is the DB2 user that ran the gateway database script.
    4. Click Test the connection and then click the Test button. Then, click Close > Close.
    5. Click Next > Finish.
  3. On the Tivoli Netcool/OMNIbus host, copy the Netcool_OMNIbus.zip report package from $NCHOME/omnibus/extensions/tcr_event_reports to the Tivoli Common Reporting host.
    • For Linux operating systemFor UNIX operating system/opt/IBM/JazzSM/reporting/cognos/deployment
    • For Windows operating systemC:\IBM\JazzSM\reporting\cognos\deployment
  4. As the smadmin user, or another suitable user, go to the location described in step 1 and click New Import New Import button.
  5. Ensure that the Netcool_OMNIbus.zip file is selected and click Next. Then, type a name for the deployment specification and click Next.
    If the package is not available for selection, ensure that is copied to the location that is specified in step 3.
  6. Select the check box that is next to the package that is contained in the Netcool_OMNIbus.zip file and click Next.
  7. Click Next > Next. Then click Save only > Finish.
  8. Click Play Play button next to the imported package. Select Now and then click Run
    To return to the Content Administration page, click Back Back button.

Results

The reports are added to Tivoli Common Reporting. You can view the reports in the Public folders area in Tivoli Common Reporting.

What to do next

You can take the following actions:
  • Read the report descriptions to familiarize yourself with the reports and their parameters.
  • Edit reports. To edit reports, click Report Studio from the report list, or from the right side of the HTML report.
  • Change the Tivoli Common Reporting model. For more information, see IBM DeveloperWorks article Tivoli Common Reporting Event Reports for Netcool OMNIbus at https://www.ibm.com/developerworks/mydeveloperworks/wikis/. To locate the article on DeveloperWorks, use the search function on the right of the page to search for items that are tagged with omnibus-tcr.