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 many types of models are present in cognos.?

4 Answers  

---

Main Differnce between Cognos7 and Cognos8

1 Answers   IBM,

---

Can you define query studio?

0 Answers  

---

What are the considerations regarding performance kept in mind while setting up cognos?

0 Answers  

---

-----------------What is Determination Model?

0 Answers  

---

what is Cognos Visualizer?

1 Answers  

---

What is the difference between Standard and Metrics folder?

0 Answers  

---

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

0 Answers  

---

Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya

1 Answers  

---

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

0 Answers  

---

How to create model and how to test model?

0 Answers  

---

In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha

0 Answers   TCS,

---