Home » Developer & Programmer » Reports & Discoverer » Oracle Discoverer - Workbooks
Oracle Discoverer - Workbooks [message #516566] Tue, 19 July 2011 06:06 Go to next message
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?
Re: Oracle Discoverer - Workbooks [message #516569 is a reply to message #516566] Tue, 19 July 2011 06:44 Go to previous messageGo to next message
Littlefoot
Messages: 21547
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).
Re: Oracle Discoverer - Workbooks [message #516579 is a reply to message #516569] Tue, 19 July 2011 07:11 Go to previous messageGo to next message
ziggy25
Messages: 206
Registered: July 2005
Senior Member
Thanks i have posted on OTN as well.
Re: Oracle Discoverer - Workbooks [message #521184 is a reply to message #516579] Fri, 26 August 2011 13:45 Go to previous messageGo to next message
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 Go to previous message
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..
Previous Topic: Need solution for matrix report formating
Next Topic: REP-1223: Invalid page size
Goto Forum:
  


Current Time: Wed Apr 01 07:05:26 CDT 2020