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: [email protected] Supported Platform for CPU2TSM:: http://www.cristie.se/cpu2tsm-supported-platforms ________________________________________ Från: Vandeventer, Harold [BS] [[email protected]] Skickat: den 15 juli 2011 18:47 Till: [email protected] Ä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...
