The fix is officially documented at
https://www.ibm.com/support/pages/apar/PH30162 but in case you don't have access it is a simple one line addition to your SDK code. For the parameter objects that have this issue add the following line (assuming your object is named item1):
item1.setInclusive(true);
------------------------------
Robert Hofstetter
------------------------------
Original Message:
Sent: Mon January 04, 2021 01:11 AM
From: IBM Cognos
Subject: Cognos sdk 11.1.7 - taking inverse parameters from Cognos report
Hi
Could you please help us to resolve this issue, where I can find fix information regarding PH30162: REPORTS RUN VIA SDK RESULT IN INVERTED PARAMETERS AND FAIL WITH XQE-PLN-0537
------------------------------
IBM Cognos
Original Message:
Sent: Thu December 31, 2020 09:50 AM
From: Robert Hofstetter
Subject: Cognos sdk 11.1.7 - taking inverse parameters from Cognos report
Vithal,
We ran into this issue while testing several months back and yes, that APAR did resolve the issue. It was very strange to see this default value change and an SDK developer from IBM even mentioned that they normally included it in the past when they wrote code. I never had myself so was surprised to hear about it.
------------------------------
Robert Hofstetter
Original Message:
Sent: Wed December 30, 2020 02:18 PM
From: Vithal Madhira
Subject: Cognos sdk 11.1.7 - taking inverse parameters from Cognos report
We recently upgraded to 11.1.7 and facing the same issue. There is an APAR in open status and a local fix was suggested. Did anyone tried that local fix and is it working?
Here is the APAR:
PH30162: REPORTS RUN VIA SDK RESULT IN INVERTED PARAMETERS AND FAIL WITH XQE-PLN-0537
------------------------------
Vithal Madhira
Original Message:
Sent: Thu October 01, 2020 03:40 PM
From: Dariusz Danielewski
Subject: Cognos sdk 11.1.7 - taking inverse parameters from Cognos report
If ?Param_Facility? is multi-valued, you must use the `IN` predicate. `NOT IN` behaves like you've described, that's by design, a value is either IN or NOT IN a set of other values.
------------------------------
Dariusz Danielewski
Original Message:
Sent: Wed September 30, 2020 06:23 PM
From: Raj Ranga
Subject: Cognos sdk 11.1.7 - taking inverse parameters from Cognos report
Hello SDK team -
Customer developed a SDK using angular to generate the reports from their front end in 11.0.3 and currently they are upgrading to 11.1.7 also updated the SDK libraries as well but running into below error... Any suggestions/thoughts if this is a defect in SDK library in 11.1.7. Please guide if anyone ran into this type of issue.
[Presentation Layer].[Facility].[Facility Number] = ?Param_Facility?
Does not work but when '=' is replaced with IN or #prompt then it works
Also noticed that if the filter has 'NOT IN' then SDK displays the report with inverse values that are in report parameter selection
Same SDK works fine in 11.1.3 version but not in 11.1.7 - any pointers is appreciated to take this further to a resolution
Thanks
Raj
------------------------------
Raj Ranga
------------------------------
#CognosAnalyticswithWatson