Re: Oracle Discoverer

John A. Pearson wrote:
>
> Hello,
>
> Department level data-owner is what I'm planing for.
>
> ?: Are you creating summary tables and aggregating information
> for the end-users, or are you doing all the joins and relationships within
> Disco? I have found that a PL/SQL package built to aggregate the
> information prior to applying Disco to the data has increased performance
> greatly.
>
> Thoughts, ideas, prognostication?
>
> Thanks
>
> john
>
> Robin Quasebarth wrote:
>
> > Great tool. However, if it is just for one or two people and you have a
> > large database the admin portion might be a little much but for departmental
> > data-owner types it is incredible and my users just took off with it. rq
> >
> > "John A. Pearson" wrote:
> >
> > > Hello,
> > >
> > > I am currently testing Oracle Discoverer as a reporting tool,
> > > against
> > > a small 3rd normal database and aggregated views and tables.
> > >
> > > I am curious of other people's experiences with this tool. (Pro/Con)
> > >
> > > Thank you,
> > >
> > > j

We opted not for Discoverer level summary management - since this is offered within the database itself from 8i onwards.

HTH

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."