Topic
  • 10 replies
  • Latest Post - ‏2015-05-27T07:33:39Z by CognosAdmin
Cognosjon
Cognosjon
12 Posts

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

    Re: Prevent report refresh whilst using cascading prompts

    ‏2009-07-28T20:27:45Z  
    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

    Re: Prevent report refresh whilst using cascading prompts

    ‏2009-07-29T03:58:51Z  
    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.
    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

    Re: Prevent report refresh whilst using cascading prompts

    ‏2009-10-15T21:45:34Z  
    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

    Re: Prevent report refresh whilst using cascading prompts

    ‏2009-10-21T14:56:21Z  
    • saik1324
    • ‏2009-10-15T21:45:34Z
    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
    Hi,
    There is javascript technique to achieve this functionality.

    Thanks,
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Prevent report refresh whilst using cascading prompts

    ‏2009-10-22T20:41:36Z  
    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
  • Kris_M
    Kris_M
    4 Posts

    Re: Prevent report refresh whilst using cascading prompts

    ‏2009-11-03T18:01:33Z  
    • SmitModi
    • ‏2009-10-21T14:56:21Z
    Hi,
    There is javascript technique to achieve this functionality.

    Thanks,
    Can you please post the javascript for that.

    Thanks.
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Prevent report refresh whilst using cascading prompts

    ‏2013-02-04T19:20:05Z  
    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
    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

    Re: Prevent report refresh whilst using cascading prompts

    ‏2013-02-04T21:25:01Z  
    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?
    http://www.ibm.com/developerworks/data/library/cognos/reporting/advanced_report_design/page583.html?ca=drs-
  • CognosAdmin
    CognosAdmin
    35 Posts

    Re: Prevent report refresh whilst using cascading prompts

    ‏2015-05-27T07:33:30Z  

    http://www.cognosasksumeet.blogspot.in/search/label/Auto%20Refresh%20Cognos%20Dashboard

  • CognosAdmin
    CognosAdmin
    35 Posts

    Re: Prevent report refresh whilst using cascading prompts

    ‏2015-05-27T07:33:39Z  

    http://www.cognosasksumeet.blogspot.in/search/label/Auto%20Refresh%20Cognos%20Dashboard