Answer Posted / 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

What are the types of folder present in cognos?

1097

---

What are the different types of important services used in cognos?

1018

---

What are the other methods working as deployment functionality?

939

---

How is possible this scenario using in type-in prompt.?

1056

---

What are all the types of indexes in Cognos?

1238

---

What is Online View?

1959

---

What is a dimension?

1032

---

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

2212

---

What is the difference between group and associare?

1048

---

1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

2143

---

What are all the components of Report Studio?

1097

---

what is degenerate key in oracle ?whare do we use it?

2563

---

7. What is performance tuning?

1996

---

How to a create header dynamically in a crosstab report in cognos 8.1?

2440

---

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2283

---