Oracle Discoverer: Join configuration cannot be resolved
When running a Discoverer Report that I created in Discoverer Plus, another user (also using Discoverer Plus) gets this error message when attempting to pen the report:
"Join configuration cannot be resolved. Reason: more than 1 of the detail folders uses non-aggregated items. Attempt to open workbook failed."
This is strange because the report is working just fine for me, but not for this other user.
In the report, I am only comparing a SUM to a SUM or a DETAIL to a DETAIL on any given worksheet. The tables are joined by employee ID, but there is also a date field for which a join has not worked. There is no valid or reliable way to create a join on the date field. If both tables are filtered by date, there is no reason to join on the date, as the date then becomes irrelevant.
This is strange because the report runs just fine for me. I have made certain that the user has access to all tables and folders, both at the database level and at the Discoverer Administrator level.
Can anyone think of what might be causing this behavior?
"Join configuration cannot be resolved. Reason: more than 1 of the detail folders uses non-aggregated items. Attempt to open workbook failed."
This is strange because the report is working just fine for me, but not for this other user.
In the report, I am only comparing a SUM to a SUM or a DETAIL to a DETAIL on any given worksheet. The tables are joined by employee ID, but there is also a date field for which a join has not worked. There is no valid or reliable way to create a join on the date field. If both tables are filtered by date, there is no reason to join on the date, as the date then becomes irrelevant.
This is strange because the report runs just fine for me. I have made certain that the user has access to all tables and folders, both at the database level and at the Discoverer Administrator level.
Can anyone think of what might be causing this behavior?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.