Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the difference between aggregation and role up aggregation ?

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

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

2128


what is catalog and types of catalogs in cagnos and which is better?

1205


How to create a cube in Transformer? What is the process? Please mention process thank u

1809


----------------Diff b/w Dimensional modeling and Relational modeling?

15093


What are the advantages of cognos?

1029


can we insert all types of charts in a list report? what r the realtime prompts?

2259


What are all the advantages of Cognos?

1079


what is the difference between list report and crosstab report?

1234


Can you define framework manager?

1064


---------------Tell me about DWH Concepts?

2216


What are shortcuts? Where it can be used? What are the advantages?

1139


what are the special features in cognos reportnet?

1100


Please explain the different stages in creating a report in cognos report net?

1056


Can you define materialized view?

1101


how you provide security to reports? How you provide security to packages ?

1111