Getting started with reports

You must set up your reporting environment before users can work with reports, for example, import packages, create data source connections, or create report packages.

Before you begin

  1. Install Tivoli® Common Reporting.Installing Reporting Services
  2. If required, install Framework Manager to create your own data models. See Installing Framework Manager.
  3. Configure the Framework Manager connection to Tivoli Common Reporting. See Configuring Framework Manager connection.

About this task

After you install Tivoli Common Reporting, prepare your report packages to generate, publish, and edit your reports.

Procedure

  1. If you have the report packages ready, complete the following tasks:
    1. Create or update your data sources:
      • For Cognos report packages, configure the database connection. See Configuring database connections.
      • For BIRT report packages, ensure that the report package data sources point to the existing data sources. Use the trcmd -list command to see your data source settings, and the trcmd -modify command to modify them, if necessary.
        Tip: BIRT reports are separate from Cognos. To create or modify BIRT reports, use open source BIRT report designer. The designer is not shipped with Tivoli Common Reporting. It is available to download from the Eclipse site.
  2. To create a report package:
    1. Configure a database connection to a data source. See Configuring database connections.
    2. Create a data model in Framework Manager.
      Tip: For more instructions, see the Framework Manager User Guide in Cognos information center.
    3. Import the metadata from your data sources. When you import the metadata, you can start modeling in Framework Manager. You can define the relations between objects such as tables, views, and queries; you can select the layers to define which objects you want to make visible; you can define what you want to publish; and you can create and publish a package that contains the model and reports. For more information, see the Framework Manager User Guide. When you configure the connection between Framework Manager and Tivoli Common Reporting, the published package is automatically pushed to Tivoli Common Reporting and you can see it in its respective folder in the reporting interface.
    4. Log in to the relevant reporting interface in your environment. Logging in to the reporting interface.
    5. Select Launch > Query Studio to test your model and create simple ad hoc reports, or select Launch > Report Studio to create more complex reports.
    6. Import Cognos report packages into your workspace. See Importing Cognos report packages.
Parent topic: Configuring Tivoli Common Reporting