Prompt and slow loading

[gjamila]

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

[blom0344]

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..

[gjamila]

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

[cognostechie]

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.