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 are the limitations of cognos reportnet? What are the enhancements in reportnet ?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
how you create security to reports?
difference between impromptu and cognos8
What is the difference between Open Connection command ang Open Session Command?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What is cognos powerhouse?
Explain about scorecarding?
how you migrate reports to cognos 8 from previous versions?
What is the difference between drill through, drill across?
How to select multiple values from type-in prompt?
----------------Diff b/w Dimensional modeling and Relational modeling?
----------------Describe DWH Architecture?
What DB View and Bus View?