COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gjamila on 09 May 2011 03:07:30 AM

Title: Prompt and slow loading
Post by: gjamila on 09 May 2011 03:07:30 AM
Hello,
  I have a problem of slowness with a report. A customer has thousands of products, and wants a prompt to select each time the product that interests him.
In this way, however, using a prompt value, the report takes over 80 seconds to load (to load the page prompts).
Using a select and search prompt times are reduced to 50 seconds, but they are still too many. You have some idea what I can use or how to set the prompt that to reduce the loading time?
It 's very slow to load the page prompts...

Thank you very much!

Giorgia
Title: Re: Prompt and slow loading
Post by: blom0344 on 09 May 2011 03:31:25 AM
Instead of loading the entire list I would use a cascading prompt that uses a preselect (for instance by productgroup or by defining a custom group on the first position of the productstring:  A --> Z)
This will greatly reduce the time to load the prompt list as only part of the entire product collection will need to be fetched..
Title: Re: Prompt and slow loading
Post by: gjamila on 09 May 2011 03:52:08 AM
Thank you for your kind reply.
I am a beginner with Report Studio, could you explain step by step how to do cascading prompts and how to define a custom group on the first position of the productstring:  A --> Z?
Thank you so much!

Giorgia
Title: Re: Prompt and slow loading
Post by: cognostechie on 09 May 2011 11:49:19 AM
Are you using the fact table to load the Products in the prompt? If so, that will definately make it slow.

You can use the Product dimension table to load the values in the prompt and make the filter to filter the
Fact table by the Product ID. In the 'Display Value' of the prompt, use the Product Description and in the
'Use Value', use the Product ID.