Windchill Business Reporting

[SimonLucas]

Folks,

we have a few large query builder reports for housekeeping duties. When we run these as normal query builder reports the load on the server is such that it can bring Windchill down. One such report lists how many EPMdocs per CAD system exist in each product.

We are currently looking into implementing Windchill Business Reporting to produce 'nicer' looking reports, but this raises the following question:

Does running a report through WBR place the same load on the method server and Tomcat as running as a normal query builder report, or does cognos handle the actual database query and post processing itself?

Any comments / suggestions?

Cheers

Simon Lucas

[MikeLockwood]

Might want to get the SQL from the report and then run directly against the database. Should run infinitely faster.

Also, creating the web page if run as HTML takes a huge part of the resources; if you run as CSV and then open and manipulate in Excel it might run much faster and with much less load. If you need to run periodically, can set up to run via a macro in Excel, with parameters input by the user.