Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Missing check box object in 11.1 R1

    Posted 10/22/19 10:05 AM
    I'd like to create a check box prompt, but it doesn't appear in the Select UI value prompt property.  Am I missing a config setting?


    Also, if a check box prompt can be used, can it be set to Auto Submit?

    Thank you




    ------------------------------
    Steve
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Missing check box object in 11.1 R1
    Best Answer

    Posted 10/22/19 10:19 AM

    @Steve Prevost To see "Check Box" Prompt, you will need to change the option for Multi-select to "yes"

    It's not possible to change the Auto-submit value to Yes for multi select prompts from the UI. The unsupported method would be to update the report spec and add the Auto Submit tag into the spec. Again, this is unsupported any may not work in all cases and may not work with future releases.

    I will test it out quickly in 11.1.3 and let you know it it works or not.



    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 3.  RE: Missing check box object in 11.1 R1

    Posted 10/22/19 10:24 AM

    Manually updating the spec and adding in the tag  autoSubmit="true" will work, but again this is not supported

    Here is a snippet of what the spec will look like

    <selectValue parameter="Parameter1" autoSubmit="true" refQuery="Query2" multiSelect="true" required="true" selectValueUI="checkboxGroup"><useItem refDataItem="Product line"/></selectValue>


    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 4.  RE: Missing check box object in 11.1 R1

    Posted 10/22/19 02:39 PM
    Denny,

    Thank you very much, I see how that works now.

    The odd thing is when I associate it with a parameter that is used in a query filter, the group is rendered as a radio button group.  When I remove the parameter from the object, it renders as a check box group!  Have you seen this behavior?

    ------------------------------
    Steve
    ------------------------------



  • 5.  RE: Missing check box object in 11.1 R1

    Posted 10/22/19 03:21 PM

    @Steve Prevost Make sure the syntax for the filter is using in and not equals.

    For example if your filter is

    [DataItem] = ?P1?

    Change it to​
    [DataItem] in ?P1?



    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 6.  RE: Missing check box object in 11.1 R1

    Posted 10/23/19 09:28 AM
    Exactly right, Denny.  I should have thought of that.  Thank you very much, you've been most helpful.

    ------------------------------
    Steve
    ------------------------------