discover问题：join configuration can't be resolved

jessie

在用discover做报表的时候，选择一个folder中的项的时候，出现了错误是：join configuration can't be resolved. reason:more than 1 of the detail folders uses non-aggregated items.
不知道是怎么回事。

gaoyiming

1. Set Options in Discoverer Plus: .     Tools >> Options >> General >> "Don't Run Query (leave sheet empty) . 2. Open a scheduled workbook result set . 3. Pres the refresh icon or Tools >> Refresh Sheet . 4. DIALOG BOX: Do you want to query the database for the most recent data?   If you choose No, then you will continue to see the results run for this  scheduled workbook. . 5. Click 'No'  (which according to the dialog should give result set . 6. Worksheet shows 'No Data is shown because the query was cancelled.' . 7. Click 'Yes' and it runs the query from the datbase.

gaoyiming

这个问题 我觉得你应该检查一下 你的连接字符串 比如
EFMSDBO/EFMSDBO@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=orldss . CONNECT_DATA=(SID=ORCL)(SERVER=DEDICATED)))

jessie

问题解决了，是种子中创建join的时候有问题。