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 |
Anybody sugest me either url address or website for cirtification in Cognos from cognos.com !
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.
how data modeling is usefull to cognos?
Can you define a catalog and types of catalogs in cognos?
what is prompt variable
What are the different types of OLAP. Which one is Cognos Powercube?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain
in u r data u having duplicates how to fetch the latest data in our report?
i have a table with 3 columns country,empname,salary and i want the query for get the name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance
How security is concerned with Reportnet? Explain its implementing steps.
How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?