Topic
8 replies Latest Post - ‏2013-02-04T21:25:01Z by DanielWagemann
Cognosjon
Cognosjon
12 Posts
ACCEPTED ANSWER

Pinned topic Prevent report refresh whilst using cascading prompts

‏2009-07-28T09:55:27Z |
I have a requirement for a single page report that has three prompts on the same page as the report.
These three prompts cascade from one another. For example Prompt 1 -> Prompt 2 -> Prompt 3.
Due to nature of these prompts Prompt 1 and 2 are set to autosubmit and therefore when I select a value from Prompt 1 the report returns results.
Does anyone know if it is possible to prevent the report from refreshing and only cascade the prompt values until I have selected all the required prompt values? Prompts 2 and 3 must be optional prompts.

Any help appreciated I'm using 8.4

Thanks
Updated on 2013-02-04T21:25:01Z at 2013-02-04T21:25:01Z by DanielWagemann
  • SystemAdmin
    SystemAdmin
    15496 Posts
    ACCEPTED ANSWER

    Re: Prevent report refresh whilst using cascading prompts

    ‏2009-07-28T20:27:45Z  in response to Cognosjon
    I think you need to consider having a prompt page when using Cascading prompts. I can't think of any way (or, frankly, any reason) for Cognos to NOT refresh the data upon an auto-submitted prompt for in-page prompts.
    • SystemAdmin
      SystemAdmin
      15496 Posts
      ACCEPTED ANSWER

      Re: Prevent report refresh whilst using cascading prompts

      ‏2009-07-29T03:58:51Z  in response to SystemAdmin
      I agree with Angela. I have a cube report with cascading prompts set to auto-submit because the users desire the report to auto refresh with new results as soon as they choose a prompt from any level in hierarchy. If you don't want this to happen then you could perhaps try using a Tree Prompt on the report page instead of cascading Value Prompts. You would also need to add a 'Prompt Button' from the Tool box and set the Type to 'Finish'.
  • saik1324
    saik1324
    1 Post
    ACCEPTED ANSWER

    Re: Prevent report refresh whilst using cascading prompts

    ‏2009-10-15T21:45:34Z  in response to Cognosjon
    Hi,

    set the autosubmit property to 'NO'. If you want to select multiple values from a single prompt auto submit wont work for cascading. U have to add another button called reprompt. select the values from the first prompt then click reprompt it will load the prompt2 values from there u can select the values.. and repeat the same step of reprompt. when u select the values from the third promt then u need to submit the report. i think it this info may help you.

    thanks,
    sai
    • SmitModi
      SmitModi
      4 Posts
      ACCEPTED ANSWER

      Re: Prevent report refresh whilst using cascading prompts

      ‏2009-10-21T14:56:21Z  in response to saik1324
      Hi,
      There is javascript technique to achieve this functionality.

      Thanks,
      • Kris_M
        Kris_M
        4 Posts
        ACCEPTED ANSWER

        Re: Prevent report refresh whilst using cascading prompts

        ‏2009-11-03T18:01:33Z  in response to SmitModi
        Can you please post the javascript for that.

        Thanks.
  • SystemAdmin
    SystemAdmin
    15496 Posts
    ACCEPTED ANSWER

    Re: Prevent report refresh whilst using cascading prompts

    ‏2009-10-22T20:41:36Z  in response to Cognosjon
    Hi ,

    this is fairly simple if you use conditinal formatting

    First create a boolean variable which has your last prompt value to null ( paramdisplayvalue(parameter3) is null))

    set the entire report to box type 'none' when yes and 'default' when 'No'.

    this will ensure that the report is not displayed unless the last prompt is picked.

    -Sriram
    • SystemAdmin
      SystemAdmin
      15496 Posts
      ACCEPTED ANSWER

      Re: Prevent report refresh whilst using cascading prompts

      ‏2013-02-04T19:20:05Z  in response to SystemAdmin
      Hi did you find an answer for this. I have value prompts set autosubmit to yes but page should not refresh . Please help posting the code if you any?
      • DanielWagemann
        DanielWagemann
        411 Posts
        ACCEPTED ANSWER

        Re: Prevent report refresh whilst using cascading prompts

        ‏2013-02-04T21:25:01Z  in response to SystemAdmin
        http://www.ibm.com/developerworks/data/library/cognos/reporting/advanced_report_design/page583.html?ca=drs-