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
- 10733 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 |
Can you explain a cognos controller?
what are summary filters? grouped filters?
What is the use of Excel files in Cognos8?
how to connect datamarts
where exactly determinants are used in cognos framework manager?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
What do you mean by drill through report?
Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?
What is Index?
Can you define cube?
Can you define dimension?
what is crosstab space
Teradata 
