End-to-End e-business Transaction Management Made Easy

406 End-to-End e-business Transaction Management Made Easy

Figure 10-22 Pet Store STI transaction response time report for eight days

Please refer to 8.7, “Transaction performance reporting” on page 295 for more

details on using the IBM Tivoli Monitoring for Transaction Performance General

Reports.

10.3 Reports by TEDW Report Interface

The following discusses how to use the new TEDW ETL2 reporting feature of

IBM Tivoli Monitoring for Transaction Performance Version 5.2.

10.3.1 The TEDW Report Interface

Using the Tivoli Enterprise Data Warehouse Report Interface (RI), you can

create and run basic reports against your data marts and publish them on your

intranet or the Internet. The Report Interface is not meant to replace OLAP or

Business Intelligence tools. If you have multidimensional reporting requirements

or need to create a more sophisticated analysis of your data, Tivoli Enterprise

Data Warehouse’s open structure provides an easy interface to plug into OLAP

or Business Intelligence tools.

Chapter 10. Historical reporting 407

Nevertheless, for two-dimensional reporting requirements, Tivoli Enterprise Data

Warehouse Report Interface provides a powerful tool. The RI is a role-based

Web interface that allows you to create reports from your aggregated

enterprise-wide data that is stored in various data marts.

The GUI can be customized for each user. Different roles can be assigned to the

users according to the tasks they have to fulfill and the reports they may look at.

The users see only those menus in their GUI, which they can use according to

their roles. The Report Interface can be accessed with a normal Web browser

from everywhere in the network. We recommend using Internet Explorer. Other

Web browsers, like Netscape, will also work, but might be slower.

To connect to your Report Interface, start your Web browser and point it to the

following URL:

http://<your_ri_server>/IBMConsole

Where you <your_ri_server> should be replaced by the fully qualified host name

of your Report server. The server port is 80 by default. If you chose another port

during installation of Tivoli Presentation Services, use the following syntax to

start the Report Interface through a different port:

http://<your_ri_server>:<your_port>/IBMConsole

When you log in for the first time, use the login superadmin and password

password (you should change this password immediately). After the login, you

should see the Welcome page. On the left-hand side, you will find the pane My

Work, with all tasks that you may perform.

To manually run a report, complete the following steps:

1. From the portfolio of the IBM Console, select Work with Reports

→ Manage

Reports and Report Output.

2. In the Manage Reports and Report Output dialog, in the Reports view,

right-click on a report icon, and select Run from the context menu.

To schedule a report to run automatically when the associated data mart is

updated, complete the following steps:

1. From the portfolio of the IBM Console, select Work with Reports

→ Manage

Reports and Report Output.

2. In the Manage Reports and Report Output dialog, in the Reports view,

right-click on a report icon, and select Properties from the context menu.

3. Click the Schedule option and enable the Run of the report when the data

mart is built.

408 End-to-End e-business Transaction Management Made Easy

10.3.2 Sample TMTP Version 5.2 reports with data mart

IBM Tivoli Monitoring for Transaction Performance Version 5.2 provides the

BWM Transaction Performance data mart. This data mart uses the following star

schemas:

򐂰 BWM_Hourly_Tranaction_Node_Star_Schema

򐂰 BWM_Daily_Tranaction_Node_Star_Schema

򐂰 BWM_Weekly_Tranaction_Node_Star_Schema

򐂰 BWM_Monthly_Tranaction_Node_Star_Schema

The data mart provides the following pre-packaged health check reports:

򐂰 Response time by application

򐂰 Response time by host name

򐂰 Execution load by application

򐂰 Execution load by user

򐂰 Transaction availability

all of which are explained in greater detail in the following sections.

Response time by application

This report shows response times during the day for individual applications.

Application response time is the average of the response times for all

transactions defined within that application. The response time measurement

unit is in seconds.

This report uses the BWM_Daily_Transaction_Node_Star_Schema.

The categories shown in the Response Time by Application report in

Figure 10-23 on page 409 are labeled J2EE Vendor/ J2EE Version; J2EE Server

Name; Probe name. The actual values for this report are:

1. N/A; N/A; STI

2. N/A; N/A; GenWin

3. N/AN/A; .*; N/A

4. WebSphere5.0; server1; N/A

5. N/A; N/A; QOS