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
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?
what is catalog and types of catalogs in cagnos and which is better?
How to create a cube in Transformer? What is the process? Please mention process thank u
----------------Diff b/w Dimensional modeling and Relational modeling?
What are the advantages of cognos?
can we insert all types of charts in a list report? what r the realtime prompts?
What are all the advantages of Cognos?
what is the difference between list report and crosstab report?
Can you define framework manager?
---------------Tell me about DWH Concepts?
What are shortcuts? Where it can be used? What are the advantages?
what are the special features in cognos reportnet?
Please explain the different stages in creating a report in cognos report net?
Can you define materialized view?
how you provide security to reports? How you provide security to packages ?