Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MORE THAN 1 OF THE DETAIL FOLDERS USES NON-AGGREGATED ITEMS

606992Nov 5 2007 — edited Nov 7 2007
What does this join configuration message mean? I am a user not an administrator but I notice that sometimes I get this message when I am trying to create reports in Discoverer.

Currently I have a report that is using a control table and a detail table. I need to link to another table (not a detail table). The join did not exist but I was able to take a transaction and join to the table with sql. I asked that this join be created in Discoverer so I can link to the other table in the report and it was created, but when I go to pull in the field I need I get this message:

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

Can this be resolved and if so how? We seem to get this message fairly often.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2007
Added on Nov 5 2007
5 comments
1,158 views