OraFAQ Forum: Reports & Discoverer » Oracle Discoverer

Home » Developer & Programmer » Reports & Discoverer » Oracle Discoverer - Workbooks

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Discoverer - Workbooks [message #516566]

Tue, 19 July 2011 06:06

ziggy25
Messages: 206
Registered: July 2005

Senior Member

I am not very familiar with Oracle Discoverer but have had to be involved in it recently. What i am trying to do is create a new business area. I logged on to the Oracle Discoverer administrator and followed these steps

- Create a new business area from online dictionary
- Selected the schema user
- Selected the tables/views i wanted to include in the business area
- Click finish

Now i have included the tables in the business area. When the user logs on to Oracle Discoverer he can see the 3 tables/views i selected. If they try to create a new workbook they can only include one of the tables in the workbook but not all 3 at the same time. If i include one table, the other two tables become 'disabled' and cannot be included in the workbook.

Any ideas why this is happening?

Report message to a moderator

Re: Oracle Discoverer - Workbooks [message #516569 is a reply to message #516566]

Tue, 19 July 2011 06:44

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Unfortunately, nobody of the forum regulars answers Discoverer questions so ... you might wait quite a long time before somebody helps. Perhaps you'd rather see what people elswhere say (for example, on OTN Forums).

Report message to a moderator

Re: Oracle Discoverer - Workbooks [message #516579 is a reply to message #516569]

Tue, 19 July 2011 07:11

ziggy25
Messages: 206
Registered: July 2005

Senior Member

Thanks i have posted on OTN as well.

Report message to a moderator

Re: Oracle Discoverer - Workbooks [message #521184 is a reply to message #516579]

Fri, 26 August 2011 13:45

Prajakta001
Messages: 52
Registered: June 2008
Location: Mumbai

Member

Hi ,

I really don't know whether u still need this answer .
Though i am also quite new to discoverer i think other tables are getting disabled because the relation ship on those tables needs to be defined.

Regards
Prajakta001

[Updated on: Fri, 26 August 2011 14:03]

Report message to a moderator

Re: Oracle Discoverer - Workbooks [message #525678 is a reply to message #521184]

Tue, 04 October 2011 10:57

niku4tinku
Messages: 8
Registered: October 2011
Location: Nigeria

Junior Member

The other 2 table has a relationship with the enable one so, through discoverer admin you need to create join then it will work..

Report message to a moderator

Previous Topic:	Need solution for matrix report formating
Next Topic:	REP-1223: Invalid page size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 14 08:13:49 CST 2025