IBM Business Analytics

 View Only

  • 1.  Cognos Multi select Option

    Posted 19 days ago

    Hi All,

    I can't use equal condition because when I use the functionality : 'Create custom filter' I have only this choices:
    -Specific values
    -Comparison (not with equal but just : <, >, <=, >=)
    -Range

    So I need to use Specific values because I need to select more that only one Invoice ID number in the value prompt. I am using DQM package. It's working for CQM Package. It's very urgent.

    Thanks,



    ------------------------------
    atluri k
    ------------------------------


  • 2.  RE: Cognos Multi select Option

    IBM Champion
    Posted 18 days ago

    Hi Atluri,

    Would you be able to share a screenshot? It should be working with CQM or DQM.

    In report, you can click on the Settings icon:

     

    then click to enable "Prompt for values":

    It should work as expected.

    If you know how to use the filter in your query, add a filter that could look like [Invoice ID] in (?pInvoice?

    Best regards,



    ------------------------------
    Patrick Neveu
    Collaboration Betters The World (CBTW)
    IBM Champion
    ------------------------------

    Original Message


  • 3.  RE: Cognos Multi select Option

    Posted 18 days ago
    Edited by atluri k 18 days ago

    Hi Patrik,

    I'm using the condition Invoice ID <= ?Parameter? in the filter. I want to enable multiple selections in the value prompt, but the options for "Select ALL" and "Deselect ALL" are not appearing. It's not working for DQM package.



    ------------------------------
    atluri k
    ------------------------------

    Original Message