Hi,
I have a number of cascading prompts on a prompt page and a few of them are a bit slow. I could live with that if it affected only those few prompts but I've noticed that on every refresh/reprompt, whether done explicitly with a button or implicitly with an auto-submitted prompt, the queries for every prompt that have been entered already are rerun. Of course, Cognos remembers the values that were entered so the user is not asked for those again but the queries to generate the choices are rerun, making each prompt successively slower than the previous one.
I tried setting the "Use Local Cache" property of one of the slowest queries but that didn't help -- it was still rerun for the next prompt.
Some of these queries are calls to stored procedures but others are not and it seems that they are all rerun, regardless.
Does anyone know if there is a way to make a reprompt action affect only certain prompts? I would prefer to keep everything on the same prompt page if possible.
Thanks,
Jack Goldstein
I did more searching and found two possible solutions:
- This developerworks article (http://www.ibm.com/developerworks/data/library/cognos/reporting/advanced_report_design/page583.html) provides a Javascript solution but it looks complicated.
- I've never used them before but it seems that a tree prompt might work if I create a hierarchical dimension.
Eventually, I'll probably try one or both of these but if anyone has opinions on either one or a third solution, please post.
Thanks,
Jack Goldstein
why can't you try keeping the prompts that require re-prompt in a second prompt page? Have only the 'Next' button in the first prompt page and keep only 'Finish' button in your second prompt page.
Thanks for your reply.
I did think of that, too, but almost every prompt requires input from the previous one so I would end up with only one or two prompts per page which I think would not be a very nice interface unless I can somehow tile the pages like one tiles the prompts.
Jack