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
Name the types of gateway?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What is Additive function?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is the difference between set functions and filter function in dimensional data?
What is dtm?
What is meant by alternate drill down with ex?
How to apply securities for reports in cognos connection?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What is a Query Subject?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What is difference between informatica power mart and power center?
Explain the difference between native sql and cognos sql?
What is model?