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 9 hours ago

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