Re: OT: Business Objects

As Charles mentioned, we are a BO shop (at least we were...the sub-prime meltdown has gotten us...I'm not trolling for a job...YET...but if/when I do, my resume says I'm doing 10g RAC, Data Guard (both logical and physical), RMAN, and LogMiner and I count myself as a pretty good SQL tuner. Yes, I'm certified FWIW). I've really only been working on the backend of BO (my group works in the bowels of the company) -- installing and patching and watching for expensive SQL. Our used-to-be BO administrator used-to-be an Oracle Apps DBA and she stayed on top of making sure that end-users weren't doing horrible things. I think that as long as you keep an eye on expensive SQL, you won't have too much heartburn. We had the extra challenge of having to use our Production database for both OLTP and Analytics, so it was even more important that I hover over the SQL coming from BO.

Regarding other resources, I've used the Business Objects Board and the Business Objects website to find solutions to problems. You should learn how to use the various Business Objects logs and management GUIs as soon as you can.

Still Employed in Seattle as of This Minute, Mark Strickland

On 4/30/07, Charles Schultz <sacrophyte_at_gmail.com> wrote:
>
> I know Mark Strickland is using Business Objects, but not sure about who
> else. As a DBA, I often get requests to tune BO-generated queries, and so
> far they have all been fairly complex and ugly. Since I do not know much
> about BO, I do not know if the blame for suboptimal queries lies more with
> the product or with the fine folks using it; I am a little biased in
> thinking that the product is simply lacking, but I reserve the right to be
> wrong. =)
>
> So first, my obvious question: have you in the user community found other
> tools that can generate "better" sql, one that exercises a little more
> intelligence about the back-end database?
> And next, assuming that perhaps the developers merely need a little
> knowledge transfer about BO, what BO Forums would you suggest?
>
> Just for a little background, the developers are writing reports against a
> copy of an ERP datastore (SCT Banner in this case). I have been able to
> introduce them to analytics which is catching on slowly (BO does not
> inherently support analytics, does it?). The datastore is not a "warehouse"
> per se, in that the data has not gone through any ETL and there are no
> enhancing fact tables or star schemas outside what is provided for the OLTP
> application. Some extra indexes and a view or two, but that is it. 10gR2 for
> those who would ask. =) Not sure about the version of BO.
>
> TIA
>
> --
> Charles Schultz

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