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
Explain the difference between native sql and cognos sql?
What are types of batch available in cognos?
What are all types of Batches?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
What is called materialized view?
What junk dimension contains?
How create measures and demensions?
i have one file i saved in csv how can i take these file into framework manager
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
How to generate cubes in cognos?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What are the roles defined by cognos platform?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What is the enterprise class platform architecture of cognos 8?