Working with reports

All TEDW reports are accessed through the IBM Web Console. This console can be accessed by typing one of the URL’s listed below into your Web browser. In the following, Computer_Name denotes the fully qualified name of a computer, where Web Services for the IBM Console is running.

Tip: The text “IBMConsole” in the URL is case-sensitive; type it exactly as shown.

򐂰 If SSL is not enabled and the number for the HTTP server port on the computer where Web Services for the IBM Console is running is 80 (the default port number), type this address:

http://<Computer_Name>/IBMConsole

򐂰 If an alternate port is used, type this address, where <port_number> is the number for the HTTP server port on the computer where Web Services for the IBM Console is running:

http://<Computer_Name>:<port_number>/IBMConsole

򐂰 If SSL has been enabled on the computer where Web Services for the IBM Console is running and the SSL port number on that computer is 443 (default), type this address:

https://<Computer_Name>/IBMConsoleSecure

If an alternate port is used, type this address, where <SSL_port_number> is the number for the SSL port on the computer where Web Services for the IBM Console is running and SSL is enabled:

https://<Computer_Name>:<SSL_port_number>/IBMConsoleSecure

This would launch the IBM Web Console and you have to login using a valid TEDW userid and password. Use the Work with Reports task group in the portfolio to manage users, groups, and data marts for TEDW, or to run, create, and view TEDW reports. To configure users to work with reports you need to add at least one of the TEDW roles given below.

򐂰 Warehouse Security Administrator

With this role, a user can create and manage groups and data marts. A user with this role controls access to data marts by assigning users to groups and by giving groups access to specific data marts. In effect, this role controls access to the TEDW data using user groups and data marts.

򐂰 Report roles control a user’s ability to create and modify reports for the data marts his user groups can access. Assign only one of the following roles to each user:

– Advanced Report Author

With this role, a user can create, modify, run, and delete public and their own personal reports, and save the output of reports, both public and personal.

– Report Author

With this role, a user can run and save the output of public reports and create and modify their own personal reports. They can run public and personal reports, and create, modify, and delete personal reports.

– Report Reader

With this role, a user can run public reports and view the saved output of public reports.

Figure 6-27 shows how to generate a report manually using the Report Interface.

You can schedule a report to run automatically when the associated data mart is updated. This ensures that when you examine the output of the report, it displays the most recent data in the warehouse.

򐂰 To manually run a report, complete the following steps:

a. From the portfolio of the IBM Console, select Work with Reports->Manage Reports and Report Output.

b. In the Manage Reports and Report Output window, 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:

a. From the portfolio of the IBM Console, select Work with Reports->Manage Reports and Report Output.

b. In the Manage Reports and Report Output window, in the Reports view, right-click on a report icon, and select Properties from the context menu.

c. Click the Schedule option and enable the Run of the report when the data mart is built.

Figure 6-27 Running reports from IBM Console

Table 6-6 describes the various predefined reports that are available when the IBM Tivoli Monitoring for Web Infrastructure Data Warehouse components have just been installed. The names for the reports are described at the time of writing this book. Please note the term IZY identifies reports that are related to

WebSphere Application Server. The columns Report Type and Shared are discussed in detail in “Create reports” on page 160.

Table 6-6 Report names and descriptions

Name Description Type Shared

Apache Health Check Error Report

This report provides basic

information on Apache Error metrics

Health

Check Public Apache Health

Check Performance Report

This report provides basic

information on Apache Performance metrics

This is a basic report for Internet Information Server

Health

Check Public

iPlanet Web server Performance Report

This is a basic report for iPlanet Web server

Health

Check Public

IZY EJB

Performance Health

EJB performance, load and throughput aggregated at the application server

Health

Check Personal

IZY EJB Resource Model Summary

The minimum, maximum, average and total values, respectively, for all EJB measurements, grouped by operating system platform, host name, and application server.

Summary Personal

IZY EJBs with the Most Hits

The top 25 EJBs with the highest weekly average total requests.

The minimum, maximum, average, and total values, respectively, for all JVM Runtime measurements, grouped by operating system platform, host name and application server.

Summary Personal

IZY Servlet Performance Health

Servlet performance, load and throughput aggregated at the application server level.

Health

Check Personal