Cognos Analytics

Hi All,

Currently i am using prompt in report page and gave default selection for that .So in initial run the report will get filtered based on default selection. After that User can choose the value from prompt and run the report.

Report has 6 charts with 6 prompt .Each chart associated with one prompt (List box) .Used Javascript to reset values and reprompt button used for submission.

In initial run based on default selection it was fetching data then if i change the values in prompt based on that it was working fine.

when i reset the prompt values and give Submit(Reprompt) then it should go to default selection but that is not happening.

Can you please suggest any method to achieve this.

Thanks in advance.

Hi Pavitra, You're looking for a way to reset to default selection? One way could be to work with saving prompt values to browser cookies by JavaScript. There is an example in the IBM samples. Depending on the case it could be easier to leave the default selection empty and work with the "empty selection". If you're using the parameters in data elements or mandatory filters you need to put a prompt-macro around the parameters and give them a default selection there. 

Hi All,

Currently i am using prompt in report page and gave default selection for that .So in initial run the report will get filtered based on default selection. After that User can choose the value from prompt and run the report.

Report has 6 charts with 6 prompt .Each chart associated with one prompt (List box) .Used Javascript to reset values and reprompt button used for submission.

In initial run based on default selection it was fetching data then if i change the values in prompt based on that it was working fine.

when i reset the prompt values and give Submit(Reprompt) then it should go to default selection but that is not happening.

Can you please suggest any method to achieve this.

Thanks in advance.

Hi Philipp,

Thanks for your response and valuable suggestion . Prompt macro was working fine in loading default selection after reset in charts. But after reset the default was not taking in Prompt. Is there any way to achieve in Prompts? Please suggest

Thanks.

Hi Pavitra, You're looking for a way to reset to default selection? One way could be to work with saving prompt values to browser cookies by JavaScript. There is an example in the IBM samples. Depending on the case it could be easier to leave the default selection empty and work with the "empty selection". If you're using the parameters in data elements or mandatory filters you need to put a prompt-macro around the parameters and give them a default selection there. 

Hi All,

Currently i am using prompt in report page and gave default selection for that .So in initial run the report will get filtered based on default selection. After that User can choose the value from prompt and run the report.

Report has 6 charts with 6 prompt .Each chart associated with one prompt (List box) .Used Javascript to reset values and reprompt button used for submission.

In initial run based on default selection it was fetching data then if i change the values in prompt based on that it was working fine.

when i reset the prompt values and give Submit(Reprompt) then it should go to default selection but that is not happening.

Can you please suggest any method to achieve this.

Thanks in advance.

Hi Pavithra, You want to reset all prompts to default values at once? Maybe I'm missing something but re-running the whole report seems to be the easiest way. 

Hi Philipp,

Thanks for your response and valuable suggestion . Prompt macro was working fine in loading default selection after reset in charts. But after reset the default was not taking in Prompt. Is there any way to achieve in Prompts? Please suggest

Thanks.

Hi Pavitra, You're looking for a way to reset to default selection? One way could be to work with saving prompt values to browser cookies by JavaScript. There is an example in the IBM samples. Depending on the case it could be easier to leave the default selection empty and work with the "empty selection". If you're using the parameters in data elements or mandatory filters you need to put a prompt-macro around the parameters and give them a default selection there. 

Hi All,

Currently i am using prompt in report page and gave default selection for that .So in initial run the report will get filtered based on default selection. After that User can choose the value from prompt and run the report.

Report has 6 charts with 6 prompt .Each chart associated with one prompt (List box) .Used Javascript to reset values and reprompt button used for submission.

In initial run based on default selection it was fetching data then if i change the values in prompt based on that it was working fine.

when i reset the prompt values and give Submit(Reprompt) then it should go to default selection but that is not happening.

Can you please suggest any method to achieve this.

Thanks in advance.