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.

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

0 Answers   IBM,

---

How to create measures and Demensions?

2 Answers  

---

suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me

2 Answers  

---

What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.

3 Answers  

---

im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?

1 Answers   IBM,

---

---

Part 1 : Cognos 1.What are the technologies that are used in cognos? 2.What are complex reports? 3.What is page break? 4.What is layout component? 5.How do you use extract function? 6.What is the use of Crosstab space? 7.What is Rank()? 8.What is the use of Query calculation and layout calculation? 9.What is Slicer and Dicer? 10.How can you create users in Cognos? 11.What is last child member? 12.What is the use of Conditional blocks? 13.What is Conditional Formatting? 14.What is group span? 15.In which types of reports does the page breaks applicable? Is it applicable in excel reports? 16.I want to show a up arrow and down arrow image in cross tab report, if the revenue is > 5000 (up arrow) and if <5000 (down arrow)? How will you achieve this? 17.What are types of Filters in RS? What is Summary Filter and Detail Filter? 18.What is Cast Function? 19.How will you create prompts for the example like this : In a single report I want a) List report (Need a prompt for this) b) Crosstab report (Need a separate prompt for this) c) Chart ()(Need a separate prompt for this) Part II : Framework Manager (FM) 1. What is Determinant in FM? 2. What is Cardinality? 3. What are the types of filters used in FM? 4. Can we create cubes with Relational Data sources? 5. What is Aliasing and Shortcut? 6. What is Session Parameter & Parameter Maps? 7. How many types of securities that we have in FM? 8. What is Data Security in FM? Part III : Data warehousing 1.What are various types of Schemas? 2.What is Star Schema and Snow Flow Schema? Difference between both? 3.What is surrogate key? Part IV : Databases 1.What are NVL Functions? 2.What is left outer join? Give an Example? 3.Can we straightaway use the tables that we have in the database instead of creating the package’s FM and making use of them, through Report Studio (RS)?

2 Answers   Satyam,

---

In a Single page we are having 3 list. While running each has to populated in separate page?

2 Answers   TCS,

---

Difference betwween cognos report net architecture and cognos8 architecture

3 Answers  

---

what is an associated query?

2 Answers  

---

tell me the creation of Snapshots?

2 Answers  

---

how can i test the reports in cognos

1 Answers   IBM,

---

how many types of keys are there i.e primary key and foreign key etc..?

2 Answers   IBM,

---