Installing the Historical Reports

To install the TBSM Historical Reports, you need to import them through IBM Cognos Administration to Cognos Analytics V11.x.

Before you begin

Important:

Tivoli Common Reporting (TCR) is now out of support. Consequently, the TBSM reports install script will not work. On Cognos Analytics Server V11.x and above, TBSM historical reports must be imported through Cognos Analytics Server V11.x Administration.

The following TCR features do not work on Cognos Analytics Server V11.x

  • Single sign on from Dashboard Application Services Hub (DASH) to Cognos V11.x
  • Command line interface commands
  • BIRT reports

See End of support of Tivoli Common Reporting (TCR) service which is part of Jazz for Service Management (JazzSM) on the IBM Support site.

To use TBSM reports, you must install Cognos Analytics Server V11.x. For details, refer to the following links:

About this task

You must Import TBSM reports through Cognos Administration to Cognos Analytics Server V11.x. The reports use the data in the Tivoli Data Warehouse collected by the Tivoli Business Service Management agent. You can use Cognos V11.x functionality to modify and enhance reports using the Cognos-based report packages.

Note: BIRT reports are now out of support. If you have BIRT reports developed, you will need to do some customization on top of the equivalent Cognos reports that ship with TBSM 6.2.0.

All TBSM 6.2.0 Cognos reports must be exported from the built-in Cognos V10 administrator in TCR, then imported to Cognos V11.x. This consists of the following steps:

  1. Exporting the Tivoli Common Reporting 3.1.x Content Store
  2. Importing the Content Store into Cognos V11.x
  3. Creating a Datasource
Note: If you have deployed TBSM Cognos reports, you need to export them from the built-in Cognos V10 administrator in TCR, then import to Cognos V11.x. If you have never deployed any TBSM reports and try to deploy now, you can bypass the export steps and start from import steps.

Procedure

  1. Exporting the Tivoli Common Reporting 3.1.x Content Store

    1. In DASH, open Common Reporting and select Launch > Administration.

    2. Run a New Export from Configuration > Content Administration.

    3. Follow the process to create a New Export:

      1. Select IBM Tivoli Business Service Manager History Agent under Public Folders and click OK.

      2. Complete and click Next on the successive export settings panels, then click Finish.

      3. Click Run.

      4. Click OK to confirm the export settings and start the export.

      The export of the Content Store is stored on the TCR System under the following folder:

      /opt/IBM/JazzSM/reporting/cognos/deployment

  2. Importing the Content Store into Cognos V11.x

    1. Copy the exported Content Store to the new Cognos V11.x system and save it under the Cognos V11.x deployment folder:

      [root@cognosv11 deployment]# cp /mnt/export/TBSM-History-Agent-Export.zip /opt/ibm/cognos/analytics/deployment

      If you have never deployed any TBSM reports and try to deploy one now, copy the TBSM reports package from the TBSM 6.2.0 GA image and save it under the Cognos V11.x deployment folder: 

      [root@cognosv11 deployment]# cp /mnt/TBSM620image/data_linux/Reports/package/TBSM_History_Agent.zip /opt/ibm/cognos/analytics/deployment

    2. Access your Cognos BI using the Web browser URL and open the Manage > Administration console.

    3. From the Cognos Administration, run a New Import from Configuration > Content Administration and select the Content Store from your exported package.

    4. Select TBSM-History-Agent-Export.zip which you exported. Otherwise select TBSM 6.2.0 out of box reports package TBSM_History_Agent.zip.

    5. Select what you want to import by completing and clicking Next on the successive import selection panels, then click Finish.

    6. Click Run.

    7. Click OK to confirm the import settings and start the import..

      Once imported, all reports appears under the Team content section.

  3. Creating a Datasource

    1. Click Manage > Administration to start the Administration console.

    2. Click Configuration > Data Source Connection > New Data Source to add the database connection.

      Compare the existing data sources in the old TCR Cognos and create the same in Cognos Analytics.

    3. Add the following connection:

      1. Set the Data Source Name, for example to TDW, select the data source Type IBM Db2, and click Next.

      2. Set the DB2 Database Name, for example to WAREHOUSE, complete the Signon details, and click Next.

    4. Enter the details for the DB2 server and click the Test button.

      If successful, you will see a message in the results table with the Status Succeeded.

    5. Click Close and then Finish.

      Note: Copy the required images into Cognos V11.x, then icons in reports can display successfully. Refer to the Troubleshooting Guide: TBSM reports icon issue.

    6. Configure LDAP for Authentication.

      By default, authentication is anonymous. To enable authentication, use the steps in the following link:

      Configuring LTPA using an LDAP namespace