WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE
LONG TIME IN CONGNOS?
Answer Posted / 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 |
Post New Answer View All Answers
how to merge 2 crosstabs thans
Name the types of gateway?
--------------Diff b/w ODS and OLAP?
What are the types of hierarchies?
--------------Explain Table of contents?
What do you mean by drill across?
Can you define folder?
What are the components of the report studio?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
How do you improve the performance of the Cognos Analytics report
Define dimensions?
What is meant by Reportstudio shortcut?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What is drill down and slicing and dicing whats the difference between them?