1. Use local cache property set to NO. 2. Validate expression properly.

6. Which of them will increase the performance?

Question Posted / amar

1 Answers
3720 Views
I also Faced
E-Mail Answers

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 model filter?

1104

how you migrate reports to cognos 8 from previous versions?

984

What are the other methods working as deployment functionality?

892

What is Metrics designer?

976

Why are meta service important then other services?

914

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4654

2. What functional area you worked on.

2274

What is the use of powerhouse?

988

What are all the advantages of Cognos?

972

how to test reports in cognos?

966

What do you mean by query studio?

887

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

2141

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...