what is the difference between aggregation and role up aggregation ?



what is the difference between aggregation and role up aggregation ? ..

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

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Cognos Interview Questions

what is Associated grouping? and how it works in cognos impromptu?

1 Answers   IBM,


What is looping and how to avoid it in framework manager?

0 Answers  


what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?

2 Answers   HCL,


What is Tool Tip? and how to create in report studio?

1 Answers   Wipro,


Can we install cognos on windows 7?

4 Answers  






Hai frnds, Any body tell to What is Granularuty in cognos Please help me.i can search in so many browsers but i canot get the answer

3 Answers   Wipro,


Hi, How the relations will be exists in DMR models if u have any idea please explain me

2 Answers   Polaris,


what is the generated prompt,how can i use?

5 Answers  


hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........

2 Answers  


What is the difference between a cascading report and drill through the report?

0 Answers  


what is Galaxy schema??

2 Answers   IBM, iGate, Wipro,


What is meant by junk dimension?

0 Answers  


Categories