Answer / vijay kalyan.v

1.Additional add-ons like Event studio, Analysis studio,
Metrics Studio.

2.In Cognos 8 framework manager we can create dimension map
i.e.(levels for hierarchies)

3.In Cognos 8 Report studio data items are created directly
in Query explorer, but in c7 we create data items in
tabular model. In c8 tabular model is excluded

4.In Query studio: conditional formatting, drill down and
drill up is extra features of c8 when compared to c7

Answer / rao

In cognos 8 we can create Business key and member description for identify purpose.If am right

Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated

1 Answers   IBM,

---

what is the procedure for scheduling conditional rendering?

0 Answers   Syntel,

---

How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)

4 Answers   Mphasis,

---

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,

---

1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm?

1 Answers   CTS,

---

what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull

2 Answers   IBM,

---

Why need staging area database for dwh?

0 Answers  

---

What is Report item

1 Answers   TCS,

---

What r the names of the reports that you prepared?

0 Answers  

---

how u will design the report if the objects are available

0 Answers   Ness Technologies,

---

Can you define a catalog and types of catalogs in cognos?

0 Answers  

---

what is the difference between list report and crosstab report?

0 Answers   IBM,

---