PH30162: REPORTS RUN VIA SDK RESULT IN INVERTED PARAMETERS AND FAIL WITH XQE-PLN-0537

APAR status

• Closed as fixed if next.

Error description

• The ExecReports SDK sample is inverting parameters when run in
  11.1.7, whereas the same code works fine in earlier versions. If
  the filter that evaluates the parameter uses the = operator, the
  following error is returned:
  
  XQE-PLN-0537 The inverted parameter 'parameter_name' can only be
  used in the context of an IN or IN_RANGE operator.
  
  If the filter is modified to use an IN operator, the report will
  run however the results are inverted. For example, using a
  simple report based on Great Outdoors Warehouse that contains
  the filter [Sales (query)].[Order method].[Order method type] in
  (?P_Type?), running the report with ExecReports and entering
  'Fax' as the order method, the report will return all results
  EXCEPT 'Fax'.
  
  Similarly, if you change the operator to NOT IN, entering 'Fax'
  will return 'Fax' only.
  
  Essentially there are 2 issues:
  
  1. The XQE-PLN-0537 error is returned when using the = operator,
  even if only a single value is submitted.
  
  2. When using IN or NOT IN, the results are inverted.
  

Local fix

• This sample can be fixed by adding 1 line of code to
  sdk/java/ReportParams/ReportParameters.java around line 142:
  
  
  
  SimpleParmValueItem item1 = new SimpleParmValueItem();
  
  	item1.setInclusive(true);  // ---> add this line
  
   item1.setUse(inputValue);
  
  
  
  NOTE: Only add the line that says // ----> add this line beside
  it
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.2                         *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels