how can we improve performance of the reports?

Answer Posted / arkchowdary

To set Governer Settings we can improve the performance.

Ex: Quesry Execution limit.
Avoid using complex calculations
Check the table qualifying and weighting.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

1675


--------------Explain Table of contents?

1546


Can you define materialized view?

609


Can you define query studio?

556


--------------Diff b/w ODS and OLAP?

2745






what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

564


Why cognos decision stream is used?

630


Can you explain a cognos controller?

595


What is the difference between drill through, drill across?

570


7. What is performance tuning?

1565


Can you define cognos impromptu?

618


how to test reports in cognos?

580


Explain the difference between powerplay transformer and power play reports?

590


------------------What is Inline Query?

1782


write a query to display the departments with no employee?

1540