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

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

Question Posted / shivani nadkarni


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

how u migrate the reports from impromptu to reportnet???

3 Answers   Wipro,

what is mean by complex starschema ,star schemagrouping?

0 Answers  

6. Which of them will increase the performance?

1 Answers  

What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

0 Answers   DELL,

how u will design the report if the objects are available

0 Answers   Ness Technologies,




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,

hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save

6 Answers   iGate,

How to schedule the report in Cognos? And i have 2 users u1,u2. how to schedule the report for these 2 users(the 2 users will get result once for a week) but u1 get the result on every monday to his inbox,and u2 get the result on every wednesday to his inbox.

3 Answers   UHG,

What is the difference between Conditional Layout and Conditional Block

1 Answers   TCS,

----------------What is Surrogate Key?

1 Answers   Cap Gemini,

What are the differences between cognos 8.2 and cognos 8.4? Please help me..

1 Answers  

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

0 Answers  

For more Cognos Interview Questions Click Here
Categories