Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE
LONG TIME IN CONGNOS?
- 2 Answers
- 10460 Views
- ABC Infotech, Virtusa, I also Faced
- E-Mail Answers
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
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What is the use of powerplay web viewer in cognos?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
how you provide security to reports? How you provide security to packages ?
-----------Diff b/w OLAP and RDBMS?
What is the difference between a cascading report and drill through report?
How to generate cubes in cognos?
What is called Cognos powerplay?
-----------With out using DrillThrough how to do Reports?
What is a Folder?
how to explain health care project and which reports we can create in health care doain?
What are the different uses of a repository manager?
Can you define set to be cardinality?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
How to a create header dynamically in a crosstab report in cognos 8.1?
