RE: Business Objects Vs Oracle Reports for batch reports

No performance issues with BO? Congratulations! I take it you have somewhat normalized schemas? We don't (as designed by our ERP vendor) and the queries generated by BO are horrendous with nested repeating subselects and such. It's no doubt from the universe layout. I wasn't involved in the selection or the setup (why should a DBA be involved with the DB?) so I can't really say if ours is a unique setup or not.

GL!

Rich

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams Sent: Monday, November 07, 2005 12:00 PM To: deen.dayal_at_dol.state.nj.us
Cc: oracle-l_at_freelists.org
Subject: Re: Business Objects Vs Oracle Reports for batch reports

Deen,

> My main issue is performance; how BO fares with Oracle Reports. I
heard BO
> does the joins on the client side; my knowledge in BO is very limited.
On

I have a slight amount of experience with BO and Crystal, and none with Oracle Reports. I think your information is outdated. So far I haven't seen any performance issues with BO, and being the DBA if there was problems you know who would get hit up with it first. My understanding is that the batch reports are basically created in Crystal, and the ad-hoc queries use a BO Universe which you can have a hand in creating. Bottom line, I consider BO to be a sophisticated enterprise-scale product and if your business users want to go with that, I'd support them if I were in your position.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l