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 use of powerhouse?
Can you define folder?
Tell me about Dnamic and Static Dashboards?
What is a Cube?
what do u mean by bridge group? where we r using this one?
Why are meta service important then other services?
how you create security to reports?
What is the difference between the standard and metrics folder?
Why cognos decision stream is used?
What is the complex report you faced in real time?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What is the difference between regular dimension and derminant?
what are the special features in cognos reportnet?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
How we check the errors before running the report?