Re: HTML and PDF Reports

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Dave Odom wrote:
> What about doing a Data Warehouse/Data Mart/Operational Data Store in another LPAR, if possible, have the users create their own reports with IBM DataQuant and DB2 Query Manager, or some such tools for interactive and batch reporting, and get yourself out of the report generation business as much as possible?  That what I'm doing here.

This is the great benefit of Data Warehousing, to my mind, Dave.  The 
biggest problem has always been that often the data in the database 
isn't perfectly suited for reporting; even in well designed databases, 
data elements aren't always present in a reportable way.

Also, rather than constantly calculating values, it's sometimes better 
from a performance standpoint to pre-summarize data.  It may mean that 
the data being reported is not entirely real time, but many reports are 
completely acceptable on data hours old, or even longer.

Have you found that, and if so, how are you addressing it?  Do you do 
exact mirroring, or do you sync data on a regular basis?  Do you 
pre-calculate data for performance?

Joe