Cognos Analytics

Expand all | Collapse all

Join Filet Type: TABLE limitation in 11.1.6

  • 1.  Join Filet Type: TABLE limitation in 11.1.6

    Posted Wed May 13, 2020 08:57 AM
    Hi in 11.1.6 we have 2 queries which are joined with filter type TABLE (package is DQM).
    Untill now it was working fine but in 11.1.6 i get error bellow:

    "XQE-PLN-0355 Filter join optimization between 'Query1' and 'Query2' is not applied because more than 10,000 values are needed."

    Any idea where this limit is set up?

    thanks a lot
    Toni



    ------------------------------
    Stoyka Bojkova
    ------------------------------


  • 2.  RE: Join Filet Type: TABLE limitation in 11.1.6

    Posted Wed May 20, 2020 02:48 PM

    Hi Stoyka,
    This value is controlled by a governor. The idea was to avoid run-away queries, because the in-list were too long, the reported one was many times larger.
    There is a between option as well, that might work.
    The other option is to define another value, there are a couple of places.
    Is this model using Framework Manager or Data Modules ?
    Are you on-prem and have access to <install>/configuratioin or on cloud?
    // Henk



    ------------------------------
    HENK CAZEMIER
    ------------------------------



  • 3.  RE: Join Filet Type: TABLE limitation in 11.1.6

    Posted Fri May 22, 2020 03:07 AM
    Hi Henk, i am on prem and its DQM framework. In the governer i couldnt find where to change it as it works in 11.1.3 and not in 11.1.6
    i am admin

    ------------------------------
    Stoyka Bojkova
    ------------------------------



  • 4.  RE: Join Filet Type: TABLE limitation in 11.1.6

    Posted Mon May 25, 2020 08:16 PM

    I'd encourage you to look at why a filter-join is trying to create a list of 10K terms. Unto itself that suggests a potential issue separate from the governor tripping.

    Assuming you have a support ticket with customer support.



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------



  • 5.  RE: Join Filet Type: TABLE limitation in 11.1.6

    Posted Tue May 26, 2020 01:54 AM
    Hi Nigel,

    thanks for your replay. Yes i have a ticket and IMB solve the issue

    Regards
    Toni

    ------------------------------
    Stoyka Bojkova
    ------------------------------



  • 6.  RE: Join Filet Type: TABLE limitation in 11.1.6

    Posted Tue May 26, 2020 02:18 PM
    Hi Stoyka,

    You were able to resolve the problem?  Can you tell me the solution as I just experienced the issue.  For me we are on 11.1.5 and this is a data module, but hope the solution could be similar.

    Thanks

    ------------------------------
    Jeremy Aude
    Channell Commercial Corporation
    Rockwall TX
    ------------------------------



  • 7.  RE: Join Filet Type: TABLE limitation in 11.1.6

    Posted Tue May 26, 2020 02:25 PM
    I found the solution for me.  I changed the relationship optimization to "No Filtering" between the two objects.  This is a valid scenario for us.

    ------------------------------
    Jeremy Aude
    Channell Commercial Corporation
    Rockwall TX
    ------------------------------