Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE
LONG TIME IN CONGNOS?
- 2 Answers
- 10638 Views
- ABC Infotech, Virtusa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ajay
deselect the option auto-aggregate&sumarry option if it
selected it takes much time to get the data
| Is This Answer Correct ? | 4 Yes | 1 No |
A list box contains 1000 records, while running the list, inside the header the content has to scroll down. Note the header should not go up?
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
How can we do the unit testing?
give me scenario on cascading prompts&master-detail relation
------------------- What is Busschema?
what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?
What is a Complex report and explain?
How to perform single signon in Cognos by using URL?
what is dimention?explain dimentable with example?
How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.
What are the types of security?
how to get the all values from a prompt using 'ALL' use and display value in prompt
Teradata 
