WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE
LONG TIME IN CONGNOS?
- 2 Answers
- 9844 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 |
what does my folder and public folder contains? difference between the my folder and public folder?
is there any possibility to hide items other than render variable?
suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???
How do we implement Check Box Prompt in COgnos Report Studio?
How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...
------------------What is Focalpoint?
set scope level in transformer
. how will we hide the “report title ” in pdf format, but title should be remain unchanged in html format.
How many types of models are present in cognos.?
----------------Diff b/w Dimensional modeling and Relational modeling?
Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
Teradata 
