How to Improve the Performance of the Report? i need this
urgently .

Answer Posted / kumar

1. check the governor settings.

2.Avoid using 'NOT' function in the query

3.Avoid using more no:of filters, complex calculations and
complex reports.

4.Move all the calculations and filter conditions from
report level to FM level.

5.Check the client server balancing

6. check the table qualifying and weighting

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the advantage of using shortcuts?

843


Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

829


Explain the difference between powerplay transformer and power play reports?

775


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2499


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2152


Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

1889


Define the cognos reporting tool?

756


what is the role of cognos comsultant?what actually it means?pls reply

2072


What you mean by drill across and what is the difference between drill through, drill across?

761


How do we drill through from a powerplay cube to reportnet?\

2109


What is the complex report you faced in real time?

1934


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2196


how to perform single sign in cognos by using url?

752


can we insert all types of charts in a list report? what r the realtime prompts?

1941


What are the other methods working as deployment functionality?

720