Cognos Analytics

 View Only
  • 1.  Cognos sdk 11.1.7 - taking inverse parameters from Cognos report

    Posted Thu October 01, 2020 09:48 AM

    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


  • 2.  RE: Cognos sdk 11.1.7 - taking inverse parameters from Cognos report

    Posted Fri October 02, 2020 12:33 PM
    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
    ------------------------------



  • 3.  RE: Cognos sdk 11.1.7 - taking inverse parameters from Cognos report

    Posted Wed December 30, 2020 02:19 PM

    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
    ------------------------------



  • 4.  RE: Cognos sdk 11.1.7 - taking inverse parameters from Cognos report

    Posted Thu December 31, 2020 09:50 AM
    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
    ------------------------------



  • 5.  RE: Cognos sdk 11.1.7 - taking inverse parameters from Cognos report

    Posted Mon January 04, 2021 12:52 PM
    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
    ------------------------------



  • 6.  RE: Cognos sdk 11.1.7 - taking inverse parameters from Cognos report

    Posted Tue January 05, 2021 09:30 AM
    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
    ------------------------------