RE: Business Objects Vs Oracle Reports for batch reports
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: <oracledba.williams@xxxxxxxxx>, <deen.dayal@xxxxxxxxxxxxxxx>
- Date: Mon, 7 Nov 2005 12:26:06 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Williams
Sent: Monday, November 07, 2005 12:00 PM
To: deen.dayal@xxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
