OBIEE: A subquery filter may not reference the current report (or contain a circular reference to an

Question

Hi,

Im getting this below error when using filter based on another request on Summary report and trying to drill down to a detail report.

A subquery filter may not reference the current report (or contain a circular reference to any report).

Does anyone have same issue and whats the resolution for this.

Thanks

Sai

bskumar.obiee · Answer

Solution:

Create a Copy  of Summary Report and save it.

Use filter based on another request even on the Detail Report and point to Copy of Summary Report. This will eliminate circular reference.

bskumar.obiee · Answer

Summary Report:

Has Quantity aggregated to Quarter.. where I'm using a filter which picks set of item numbers from another report request (Conditional Report).

When drill-down on Quarter it will navigate to Detail Report.

Conditional Report:

Item numbers relevant to different fact (not from the Summary report measure)

Joel Acha · Answer

You'll need to provide more information about how your report setup is structured. The error seems to imply that your filtered report is referencing another report.