WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE
LONG TIME IN CONGNOS?
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 |
If anyone need COGNOS 8 Certification Dumps of any "COG - Code", u can get from S_Cog@Yahoo.Com, i scored 100 % with these Dumps
Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?
Can you define framework manager?
-------------How to do Bursting a Report?
how to do page breaks in cognos 8 Report studio pls give the navigation
What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.
Hi,please suggest me how to creat username while creating a report.
what are determinants?
Mention the difference between ‘macros’ and ‘prompt’?
Can u please describe the different types of traps with eg. Thanks
What is difference between content store and content manager?
Is cognos models are version compatible?