What is Local Cache and how does it help in performance tuning



What is Local Cache and how does it help in performance tuning..

Answer / shivani nadkarni

Local Cache basically uses the pre run query information rather than hitting the DB every time. The link has a very good explanation on how it works
https://www.ibm.com/support/pages/how-improve-performance-reusing-cached-data-when-running-report-cognos-analytics-11#:~:text=Steps%20to%20enable%2Fdisable%20the%20cache%20in%20Cognos%20Analytics,to%20enable%2Fdisable%20the%20default%20use%20of%20local%20cache.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

Explain about Parametermap?

1 Answers  


How you create IQD In ReportNet FrameWork?

3 Answers   IBM,


For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?

5 Answers   TCS,


diff b/w grouping and aggregation

1 Answers   HCL,


diff b/w layout calculation and query calculation

2 Answers   Cap Gemini,


Define metrics studio?

0 Answers  


I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?

5 Answers   SAIC,


What is the difference between static and dynamic conditions?

0 Answers  


suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?

5 Answers   TCS,


What is slicer & dicer ? what is sub session parameter ?

2 Answers   Cap Gemini,


What is slowely changing dimensions?why we are used SCD?

2 Answers  


what is boxtype

1 Answers   IBM,


Categories