6. Which of them will increase the performance?

Answer Posted / amar

1. Use local cache property set to NO.

2. Validate expression properly.

3. Use detail filters after auto aggregation instead of
summarized filters.

4. Test with limited number of data.

5. minimize sql hard code.

6. Avoid Java script usage maximum.

7. Use sql having clause expressions.

8. Avoid usage of cognos functions Maximum.

I hope this is useful...
If am wrong let me know...

Thanks.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is set to be Cognos configuration?

599


Why is auto-regression used in forecasting used on cognos platform?

540


what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

1501


How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2157


explain how to create powerplay reports?

606






hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1450


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

602


What is Metrics designer?

592


What are all types of Batches?

575


Actually we have 500 users when they run the report display the flage image related country user? How its possible?

1569


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1552


is cognos 7 is better than cognos 8

1688


How can we create a dynamic column name in cognos?

535


how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

693


What is metric store database?

565