Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
12
Views
3
Comments
bskumar.obiee
bskumar.obiee Rank 3 - Community Apprentice
edited Aug 13, 2024 6:08PM in Oracle Analytics Cloud and Server

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

Answers

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    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.

  • bskumar.obiee
    bskumar.obiee Rank 3 - Community Apprentice

    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)

  • bskumar.obiee
    bskumar.obiee Rank 3 - Community Apprentice

    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.