WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE
LONG TIME IN CONGNOS?
Answer Posted / joydeep
go through the generated sql and try to compare it with the
regular sql code by running the sql in the navigator. that
will give you an estimate of the time difference.
secondly try to check the joins. avoid outer joins as far
as possible.
thirdly try to add prompts and filters if possible to
reduce the number of records to be pulled into the query.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How to create model and how to test model?
What are the components of report net?
what is the procedure for scheduling conditional rendering?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What are the different uses of a repository manager?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
How to do Performence Tunning in Cognos Reports?
What is the difference between static and dynamic conditions?
How can I schedule reports in cognos?
What is a Transformer?
What are the two types of framework manager?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What are the different types of important services used in cognos?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..