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
- 10642 Views
- ABC Infotech, Virtusa, I also Faced
- E-Mail Answers
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 is filter?give me one example that you created a report in your project?
You get a parsing error when you run a report. What will be your first steps to resolve the error?
give me scenario on cascading prompts&master-detail relation
What is a dashboard in Cognos Report Studio and how do we creae it
what is the different between primarykey and surrogated key.. why we are going for surrogatekey...
what is conditional query subject and example
Hi Experts, Can a single package be shared by multiple users?
1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?
-----------------What is Direct and Conventional loading?
What is Crossproduct?
Which service handles requests for cognos connection,query studio and event studio.
What is the difference between the standard and metrics folder?
Teradata 
