IT Forums >
Software >
Oracle > Discoverer - Join configuration cannot be resolved. Reason: more than 1 of the detail
View Full Version : Discoverer - Join configuration cannot be resolved. Reason: more than 1 of the detail
jmccallen
03-11-2004, 04:31 AM
Hi there
I'm new to Discoverer, and using Version 4, I have created a small,
simple business area based on about 8 tables from our Oracle database.
I selected insert folder from database, and selected the automatic
create joins from primary/foreign key constraints.
Most of the reports run okay from the User edition, but when certain
folders are selected together I get the following error:
"Join configuration cannot be resolved. Reason: more than 1 of the
detail folders uses non-aggregated items."
I tried recreating all the folders deselecting the checkbox for
"Default aggregate on datapoints", but am still getting the same
error.
I've also tried checking "Disable multiple join path detection" from
Options >Advanced in the User Edition, but still no luck.
Anyone any ideas?
Much appreciated.
Jenny
MyLounge.com Site Map
Forum:
Cars,
Cell Phone,
Database,
Games,
Home Improvement,
IT,
Music,
School,
Sports,
Web Design,
Web Server,
Weight Loss
The MyLounge.com forum is intended for informational use only and should not
be relied upon and is not a substitute for any advice. The information contained
on MyLounge.com are opinions and suggestions of members and is not a representation
of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for
the accuracy, completeness or usefulness of any postings or the qualifications
of any person responding. Please consult a expert or seek the services of an
attorney in your area for more accuracy on your specific situation. Please note
that our forums also serve as mirrors to Usenet newsgroups. Many posts you see
on our forums are made by newsgroup users who may not be members of MyLounge.com
Term of Service
vBulletin v3.0.7, Copyright ©2000-2009, Jelsoft Enterprises Ltd.