COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: agorsky on 03 Oct 2005 06:54:13 PM

Title: "Your Report Is Running" Takes Too Long
Post by: agorsky on 03 Oct 2005 06:54:13 PM
Hi Everyone--

We have a cascading prompt for Managers and their Sales Associates.Ã,  We are noticing that when we select "Reprompt" the system takes 3-6 seconds before the "Your Report Is Running" message appears.Ã,  Once it appears the data is usually displayed within 1-2 seconds.Ã,  We are noticing this lag in just about every scenario where a promptÃ,  button is pushed.

My question:Ã,  Is this lag time normal for ReportNet?Ã,  We don't want to assume that we are designing something incorrectly if this is a common thing in ReportNet.

Thanks for your advice!

Aaron
Title: Re: "Your Report Is Running" Takes Too Long
Post by: Darek on 03 Oct 2005 09:30:07 PM
If your prompts are DB driven (non-static, as most cascading prompts are) than I'd say, yes, the lag is normal and DB dependant.
Title: Re: "Your Report Is Running" Takes Too Long
Post by: agorsky on 03 Oct 2005 10:59:20 PM
Hi Darek--

I expect the time delay for a DB driven prompt but I was hoping that the message "Your Report Is Running" would occur quickly so the user would not be confused.  I initially used the "Auto Postback" but I dont think that most of our users would realize that the screen was going to refresh if it takes 3-5 seconds for the message to appear.  My ideal situation would be for the message to appear immediately.  Does that make sense?

Thanks!

Aaron
Title: Re: "Your Report Is Running" Takes Too Long
Post by: sir_jeroen on 04 Oct 2005 04:11:47 AM
On which table is your prompt based? On the Primary Key table (Dimension) or on the Foreign key table (fact).

You should base your prompt on the smallest (Dimension / Primary key) table.

e.g.
2 tables: Country and Orders.
In both there's a Country Code column.
In this case you should base your Prompt on the Country table and NOT on the Orders table.
Title: Re: "Your Report Is Running" Takes Too Long
Post by: Darek on 04 Oct 2005 11:08:52 AM
Also, how many report processors do you have available? Are they fully utilized?
Title: Re: "Your Report Is Running" Takes Too Long
Post by: SG8096 on 22 Oct 2012 11:46:45 AM
was this issue resolved?? can you please let me know how you made it work