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 |
What are the types of studio present in Cognos?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What is Index?
how u provide security to reports??how u provide security to packages ?
If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.
What is a Complex report and explain?
Why is auto-regression used in forecasting used on cognos platform?
Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You
How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
how can i test the reports in cognos
What are the differences between main Cognos 8.2 and 8.3 ?