Answer / suresh

Hi,
Aggregation is normal aggregation like we do in SQL
query(Total,Avg,Count,Max,Min,Sum).
Rollup aggregation is at the end what should do for the
total report.
for example below:
Country Quantity
India 10
India 24
Singapore 6
Malaysia 4
when you group this report Aggregation for India
34,Singapore 6,Malaysia 6 and Rollup aggregate for this
report will be 44 calculated

How to apply securities for reports in cognos connection?

0 Answers   TCS,

---

What is difference between drill through and drill down?

3 Answers  

---

Mention the difference between ‘macros’ and ‘prompt’?

0 Answers  

---

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,

---

What is the difference between Conditional Layout and Conditional Block

1 Answers   TCS,

---

Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?

0 Answers  

---

-------------How to do Bursting a Report?

1 Answers   Cap Gemini,

---

how to create relationship between emp and salgrade tables in frameworkmanager?

1 Answers   TCS,

---

How can we change any header or footer for a group of reports

1 Answers   Satyam, Tech Mahindra,

---

. how will we hide the “report title ” in pdf format, but title should be remain unchanged in html format.

3 Answers  

---

What is Cardinality b/w Fact to Fact?

4 Answers   IBM,

---

I have the below IBM COGNOS 8 Certification latest Dumps: COG-112: IBM Cognos 8 BI Author COG-122: IBM Cognos 8 BI Administrator COG-125: IBM Cognos 8 BI Data Warehouse Developer COG-132: IBM Cognos 8 BI Metadata Model Developer COG-135: IBM Cognos 8 BI OLAP Developer COG-145: IBM Cognos 8 BI Multidimensional Author COG-180: IBM Cognos 8 BI Professional Recently new questions also have been updated in this Dump. If interested,mail me on kris.bi121@gmail.com with Exam Code and Exam name

37 Answers   Cisco, L&T,

---