1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

What is Performance Tunning Test?

Question Posted / arkchowdary

Answers were Sorted based on User's Feedback



What is Performance Tunning Test?..

Answer / 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 0 No

What is Performance Tunning Test?..

Answer / ashok

To reduce the run time of a report is known as performance tuning. to reduce the run time we have follow some tricks like query optimization, remove unwanted filters.. etc..

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

what is symmetric key?where do u use this?

1 Answers  

what is prompt variable

2 Answers   HCL,

-------------What is Coditional Prompting?

0 Answers   IBM,

what is the automation tool used for data warehouse testing???

3 Answers   Covansys, IBM, Wipro,

how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.

4 Answers  




Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!

5 Answers   DELL,

How do you test the reports? Explain the Unit testing procedures after developing the reports?

1 Answers   HP, TCS,

wt is tupple , Embed function ? wt is regular dimension ?

1 Answers  

what is the different between primarykey and surrogated key.. why we are going for surrogatekey...

1 Answers  

What are cognos connection initial page components?

0 Answers  

is there any difference between operational database and data base?if yes what r they?

0 Answers  

What is Tool Tip? and how to create in report studio?

1 Answers   Wipro,

For more Cognos Interview Questions Click Here
Categories