Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Report with multiple prompts - how to remove previous prompt values for testing

    Posted Thu December 07, 2023 07:32 AM
    Edited by brenda grossnickle Thu December 07, 2023 09:57 AM

    Re: Report with multiple prompts - how to clear previous  prompt values

    I am working with a report that has multiple prompt values. It seems like when i run or rerun even several days later that some of the previous prompt values are retained. this is making it hard to test. how can i erase all previous prompt values and make the report behave as if it is the first time that it was ever launched?

    ok, a bit more detail that might matter. developed a report that has 8 prompt textboxes on the report page. each textbox has a default value of -99. only one prompt textbox is required. once a prompt value for textbox1 is set to say 0, textbox1 stays a 0 until i close the report and then reopen. 

    Just found this url - How to see "Reset prompts and run" option while authoring a report. (ibm.com) - that has you "Modify the parameter "Run with full interactivity" to No" for the report and it seems to have fixed my issue. kind of odd that the textboxes no longer show their default value of -99 (they appear blank or empty) yet they pass -99, but that is not important for my report. 



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------



  • 2.  RE: Report with multiple prompts - how to remove previous prompt values for testing
    Best Answer

    Posted Mon December 11, 2023 03:38 AM

    I think you are looking for the 'Clear parameter values' option.

    This can be found on the Report properties page within the report editor, as shown in the screenshot below:

    (screenshot shows a blank report so the parameters box is empty)



    ------------------------------
    Marc Reed
    ------------------------------



  • 3.  RE: Report with multiple prompts - how to remove previous prompt values for testing

    Posted Mon November 03, 2025 05:42 PM

    Hi Marc, So when i click 'reset prompts and rerun' option, the date range prompt on prompt page doesnt reset.

    Report style: 11.x or latest

    Run with interactivity is off to get the option 'Reset and rerun'

    Would appreciate if you can find solution for this.

    Thanks,

    Paul



    ------------------------------
    Paul Gaddala
    ------------------------------



  • 4.  RE: Report with multiple prompts - how to remove previous prompt values for testing

    Posted Tue November 04, 2025 04:49 AM

    Just for the sake of completeness: in Cognos 12 the clear parameters option moved to the new parameter panel.



    ------------------------------
    Thomas Wolf
    BI Professional
    Techniker Krankenkasse
    Hamburg
    ------------------------------



  • 5.  RE: Report with multiple prompts - how to remove previous prompt values for testing

    Posted Wed November 05, 2025 11:34 AM

    Marc, thank you for this.  I am very happy to see that this option is finally available.  I have been looking for this for a long time.  Previously, my only option was to close and reopen the report or use the Run/RePrompt button to run the in another tab due to the caching of the parameter values in Preview mode.



    ------------------------------
    Dion Paul
    Cognos Administrator
    Ascend SC
    Daytona Beach FL
    dpaul@scgts.com
    ------------------------------