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 report burn and where it occurs

3 Answers   IBM, Target,


When we save a report in report studio with what extn it save?

0 Answers  


What is a dashboard in Cognos Report Studio and how do we creae it

2 Answers  


--------------Explain Table of contents?

0 Answers   Cap Gemini,


I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?

6 Answers  


how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

2 Answers   Patni,


Can you explain cognos planning?

0 Answers  


How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

0 Answers   Accenture,


What DB View and Bus View?

0 Answers  


What is a Framework manager?

0 Answers  


Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...

1 Answers  


What is the Main Difference between Conditional Block and Render Variable in Cognos. Both are used for Condtional rendering.But what is the Main Diff?

4 Answers   Wipro,


Categories