Create a Report Design

This section takes you through the steps required to create a minimal report design.

Before you begin make sure the TrueSight Middleware and Transaction Monitor (TMTM) services are running. See Starting-and-stopping-services for more information. Also, make sure at least one instance of an object is associated to a History Template in the TMTM Monitor Console.

The example below uses a WebSphere MQ Local Queue object, but you can substitute any other object if that is more convenient (just remember to select types and attributes that apply to the type of object chosen when following these instructions).

Related topics

Getting-started-with-the-TMTM-Report-Designer

Using-reports-and-charts

To create a report design

  1. Start the TMTM Report Designer.
  2. Create a Report Project. Select File > New > Project ... from the menu to open the New Project Wizard.
  3. Select Report Project from the Business Intelligence and Report Tools category, then click Next.
  4. Give the project a name, and click Finish.
  5. Create a new Report. Select File > New > Report from the menu.
  6. Give the report a name, and click Finish.
  7. If the TMTM Report Designer does not do so automatically, open the Report Design perspective. Select Window > Open Perspective > Report Design from the menu.
  8. Select File > New > Report, give it a name and select a Blank report.

    You now have a new, empty report design.

The next steps describe how to add a simple TMTM data source and data set to the report. For more complex reporting, see later sections.

  1. Select Data > New Data Source from the menu.
  2. Select TMTM Data Source from the list and click Next.
  3. Supply the "User", "Password", and "Host" properties that connect you to your TMTM Services.
  4. Click Finish.

    This defines the TMTM Services to the TMTM Report Designer.

Next, define a data set for the report.

  1. Select Data > New Data Set > New Data Set from the menu.
  2. Ensure that TMTM Data Source is selected as the data source.
  3. Select a data set type of Low Resolution History for Static Attributes, then click Next.
  4. Select a type of WebSphere MQ Local Queues. You can quickly filter the list by typing "local" in the filter box. Click Next.
  5. Select the Select a Monitored Object check box.
  6. In the Monitored Objects tree, navigate to a WebSphere MQ Local Queue object, then click Next. If the tree is empty, then no objects are yet associated to a History Template for that object type. Open the TMTM Monitor Console, and make an association before continuing.
  7. Click Next to review the Report Period and Resolution settings. The default options suffice.
  8. Click Finish to complete defining the data source.

    This defines a TMTM Data Source to the TMTM Report Designer.

At this point, it is recommended to preview the history data available for the TMTM Data Source.

  1. Open the Data Explorer view and navigate to the newly defined TMTM Data Set. Double-click on it in the tree.
  2. Click on the Preview Results element.
  3. Review the table of results. You should see a set of timestamps and history values for a number of attributes related to the monitored object. If there is no history data yet available for the monitored object, there are null (empty) values for all of the attributes.

Finally, layout the data into a simple table on the report.

  1. Open the Palette view.
  2. From Report Items available, drag and drop a Table item onto the empty Report Design.
  3. In the Insert Table dialog box that opens, select the TMTM Data Set from the Data Set drop-down list and click OK.
  4. From the Data Explorer view, open the tree for the TMTM Data Set. Find the "Timestamp" item in the tree, and drag it into the first Detail row of the table. Be sure to drop into the detail row (the middle of the three rows, under the head row, and above the footer row).
  5. Drag and drop the "CurrentGetRage(Avg)" and "CurrentQDepth(Avg)" into the remaining empty detail columns.
  6. Click on the Preview tab of the report design to see the history data rendered in a table.

Before publishing the report design to TMTM, set some of the report properties to make it easier to identify later on.

  1. Switch to the Layout tab of the Report Design.
  2. Open the Outline view.
  3. Navigate to the root of the Report Design in the outline tree view.
  4. Select Window > Show View > Property Editor from the menu.
  5. On the General tab, give the report a Title (for example purposes, "Sample Report").
  6. On the Description tab, give the report a description (for example purposes, "My Sample Report").
  7. Select File > Save to save the report design.

The simple report design is now complete. If you have chosen all the default values above, this report creates a table showing low resolution history for two attributes from a specific monitored object, for a period covering the current day (from midnight last night to 23:00 hours tonight).

To understand how Report Designs can be made more generic, more flexible, and more complex, see Designing-TMTM-Reports. For now, you have a simple report design that can be published to TMTM, and then placed onto views in the Monitor Console.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*