Hi Harold,
I have been working a little bit with BIRT. One thing you need to remember 
about the Warehouse database is that it is 24 hours behind the real world.
You need to open the TSM DB2 database to be accessible direct from TCR and then 
write reports direct to the TSM Server to be able to get 20 hours backup status.

Best Regards
Christian Svensson

Cell: +46-70-325 1577
E-mail: Christian.Svensson AT cristie DOT se
Supported Platform for CPU2TSM:: 
http://www.cristie.se/cpu2tsm-supported-platforms

________________________________________
Från: Vandeventer, Harold [BS] [Harold.Vandeventer AT DA.KS DOT GOV]
Skickat: den 15 juli 2011 18:47
Till: ADSM-L AT VM.MARIST DOT EDU
Ämne: Re: Reporting and BIRT in TSM 6.2

I will first admit that I'm a TSM admin, not a "report writer".... but we have 
to come up with a replacement for the reporting component on the TSM 5.x 
servers.

Finally got BIRT Report Designer configured to query the TCR WAREHOUS schema.

When previewing a report in BIRT Report Design the schedule start displays as 
'1110714180036000'.  That is somehow to be July 14th, 2011 at 6:00 PM.

Running the similar report in Administration Center (Reporting > Common 
Reporting) properly displays the "Jul 14, 2011 6:00 PM" format.

The data is defined as CHAR in Birt, not a date/time as I would expect.  I 
don't know enough DB2 yet to look at the properties in WAREHOUS.

Anyone out there working, successfully, with BIRT?

At least a few of you are holding out for Cognos in a future release.


Thanks...