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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2393


What is the difference between regular dimension and derminant?

1794


how to perform back drill through in cognos 8 what is the use of it

2138


I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1640


How to Reset Pagenumbers in one report.

2299






What are the steps to import the two data sources in framework manager?

690


Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

998


What is Fullouterjoin?

1636


How to a create header dynamically in a crosstab report in cognos 8.1?

2075


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

1966


What is defined as Query studio?

698


What are the roles defined by cognos platform?

654


How to select multiple values from type-in prompt?

736


Can you define slice?

704


what is the procedure for scheduling conditional rendering?

2121