COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: richiearora on 20 Nov 2015 10:49:22 AM

Title: Restrict Loading Prompt Values.
Post by: richiearora on 20 Nov 2015 10:49:22 AM
Hi All,

I am doing Perfomance optimization of the Prompt Page, I have found root cause for the same.

I have 2 Prompts , 1 - Brand 2 - Campaings. So Campaign's are filtered Based on brand.

When my Rpeort Initially Loads, All the camapign's are loaded, I want to restrrict this to be loaded when i run my Rpeort for first time.

After Page is Loaded , Post selecting brand then only Campaign should be displayed in this Radio Button.

How can i do this?

I think it will resolve the perfomance issue.

Thanks  a lot.
Title: Re: Restrict Loading Prompt Values.
Post by: bdbits on 23 Nov 2015 10:28:23 AM
Are these set up as cascading prompts?
Title: Re: Restrict Loading Prompt Values.
Post by: richiearora on 09 Dec 2015 03:56:09 PM
No.These are not Cascading Prompts.

Basically they are individual Prompts