Re: Discoverer EUL Tables
Date: Thu, 02 Jan 2003 21:37:11 -0800
Message-ID: <3E152187.F2F5E775_at_exesolutions.com>
Maja wrote:
> Hi,
>
> I mean - upgrade an EUL.
> Precisely saying - I have a Custom Folder including my SQL expression
> (Discoverer Admin Edition level). In DB this 'select expression' is
> written in eul4_segments table (columns: SEG_CHUNKx) - isn't it?. And
> now I need to change this 'select expression' (for example: add 'where
> clause') - but from DB level (updating this table <other tables>).
> Likewise changing: 'Summary expression', folders' names, folders'
> descriptions, items' names and so on. Is it possible? Or is there any
> other solution (other then replacing names and expressions using
> Discoverer Admin Edition.)? It should be automatic (script?)
>
> - Maja -
>
> damorgan <damorgan_at_exesolutions.com> wrote in message news:<3E10CA4D.F5AD977D_at_exesolutions.com>...
> > Maja wrote:
> >
> > > DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E0CAF92.C46AF5DD_at_exesolutions.com>...
> > > > Maja wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I'm using Discoverer ver. 4.1.37 and I'm looking for any information
> > > > > (documentation / experience ) about Discoverer database tables of EUL
> > > > > (like: eul4_objs, eul4_segments etc.). I'd like to control Discoverer
> > > > > objects (business areas, folders, summaries) from DB level.
> > > > >
> > > > > i'm looking forward any help,
> > > > > - Maja -
> > > >
> > > > Sounds like a great way to break Discoverer.
> > > >
> > > > Could you please explain what you mean by "control"?
> > > >
> > > > Without knowing your intention I can/will not provide information.
> > > >
> > > > Daniel Morgan
> > >
> > > Hi,
> > >
> > > I need to prepare an SQL script for automatic upgrade of Custom
> > > Folders, Summaries and others - is it possible?
> > >
> > > Or maybe there is another good way for automatic upgrade. I'm trying
> > > to find the best (easiest) solution for my client to post changes in
> > > discov. application (admin ediotion).
> > >
> > > - Maja -
> >
> > Insufficient information from which to render an answer. Upgrade what? Upgrade Oracle's software?
> > Upgrade the EUL?
> >
> > Daniel Morgan
I've no doubt you can do it directly. But do to interdependencies between the various tables I would expect it would be more dangerous than fruitful.
Consider the value of any advantage against the cost of fixing any mistakes.
Daniel Morgan Received on Fri Jan 03 2003 - 06:37:11 CET