Discoverer - Join configuration cannot be resolved. Reason: more than 1 of the detail folders uses non-aggregated items.

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 Received on Thu Mar 11 2004 - 13:31:43 CET