Cognos Analytics

 View Only
Expand all | Collapse all

SQL Exists within a Report

  • 1.  SQL Exists within a Report

    IBM Champion
    Posted 9 hours ago

    Hi all,

    I know I can do a filter such as 

    [Order Method Code] in ( [Query2].[Order Method Code] )

    within a report.

    Traditionally in SQL such a filter would be written as an EXISTS statement as it usually faster than an IN statement when the query referenced within the IN is a large result set.

    Is there anyway of writing a SQL EXISTS within a CA report query?

    Thanks



    ------------------------------
    Marc Reed
    ------------------------------