IBM Support

Reporting with Tivoli Data Warehouse

Technical Blog Post


Abstract

Reporting with Tivoli Data Warehouse

Body

IBM Tivoli products which store data in Tivoli Data Warehouse (TDW) may be providing a report package or the Cognos data model which can be used to create reports in Tivoli Common Reporting. But in cases where you are required to create a new model and report on the data in Tivoli Data Warehouse, here is an article which covers the following topics:

Exercise 1 – Creating the data source and data model
Exercise 2 – Use direct SQL in a report
Exercise 3 – Use Tivoli Common Reporting Template
Exercise 4 – Use filter to view data of single or multiple server
Exercise 5 – Use summarized tables of Tivoli Data Warehouse
Exercise 6 – Use custom tables in report
Exercise 7 – Add a chart to the report
Exercise 8 – Add drill down capability
Exercise 9 – Export report package
Exercise 10 – Import report package

Download the article on 'Reporting with Tivoli Data Warehouse'.

Even though this document is based on data in Tivoli Data Warehouse, it can be applied to any other data as well. It helps in understanding some of the basic features of reporting in Tivoli Common Reporting.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEKCU","label":"Jazz for Service Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

UID

ibm11276492