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 |
How to schedule the report twice in a day?
How to test reports in cagonos ?
10 Answers CST, CTS,
What is the information present in the cognos configuration file?
where do we see the run time of the report ?
How to write a condition for multy select in conditional formatting... Eg:- i added list,crosstab, barchart, columchart, guagechart, pie chart for value prompt by using static choices.. if i select multiple that all the things has to be display.. this is requirement how is possible to display..
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What is use of Field Set present in toolbox?
What are all types of Batches?
-----------------What is Determination Model?
What is the difference between a cascading report and drill through the report?
What are user classes?
what is power prompt in cognos ep7series?what is the use of this?