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

Get End-to-End e-business Transaction Management Made Easy now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.