how can we improve performance of the reports?

Answer Posted / prasad

1. Check the Governor Settings.
2. Dont use the Not in function in the query.
3. Check the client/server balancing.
4. Avoid using complex calculations
5. Check the table qualifying and weighting.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

2795


What are all the different types of prompt in cognos?

538


Can you define slice?

616


please please give me some banking calculations in framework manager.

1645


What is cognos powerhouse?

579






What are the services provided in cognos 8?

548


We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2074


What is defined as data mining?

593


what are slowly changing dimensions? Why we are used scd?

609


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?

1674


Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

1615


What is Additive function?

1545


Can you define pivot?

536


Can you define drill down and drill up?

626


What are the roles defined by cognos platform?

558