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
- 10625 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 is difference between page break and section report? What is main advantage datawarehousing over oracle?
What do you understand by the cognos?
What is the report studio?
What do you understand by the term 'aggregate cache'?
What do you mean by drill across?
How can I schedule reports in cognos?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
What do you understand by ‘ibm predictive maintenance and quality’?
Why cognos decision stream is used?
What are the different kinds of panes included in cognos?
what is the role of cognos comsultant?what actually it means?pls reply
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What DB View and Bus View?
---------------Describe OLAP Reporting and RDBMS Reporting?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
