Re: Oracle Discoverer Viewer crosstab drill down hierarchy

I figured out my problem. I was incorrectly using calculated fields in Desktop. I fixed this by making those calculated fields in Administrator, and basing the item hierarchies off those calculated fields.

--Benjamin

onlysendspamtothisaddress_at_yahoo.com wrote:
> I have created the item classes and the hierachies with Discoverer
> Administrator that look right. Using Discoverer Desktop I have
created
> crosstabs. But with Discoverer Viewer, I do not see the + graphic to
> choose my drill down field like I expected. My specific question is:
> do I have to do anything (besides create the crosstab) in Desktop to
> get the drill down option for that crosstab in Viewer?
Alternatively,
> if I set up the drill down hierarchy in Administrator properly would
> the drill option automatically appear in Viewer?
>
> Does any tutorial exist for setting up the ability to drill from
> Viewer? I've looked at the Oracle 9i Discoverer Administrator
Tutorial
> Chapter 9: Working with Hierarchies and the Oracle 9i Administrator
> Administration Guide (Online Help) so far, but still not quite there
> yet.
>
> Sorry for not being an expert on this... our regular Discoverer guy
is
> deployed in Iraq. I'm doing the best I can to recreate his magic.
My
> background is more with open source database tools.
>
> Thanks for your help.
> --Benjamin
>
>
> > Benjamin,
> > Hierarchies are created with Discoverer Administrator. If you want
a
> > summary-to-detail drill between items in different folders, you
will
> > need an item class.
> >
> > Regards
Received on Fri Feb 11 2005 - 21:12:59 CET