what is the difference between aggregation and role up aggregation ?



what is the difference between aggregation and role up aggregation ? ..

Answer / 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

More Cognos Interview Questions

can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?

1 Answers  


What are the methods by which it non-durable model could be changed into the durable model?

0 Answers  


What are all the types of report?

0 Answers  


where exactly determinants are used in cognos framework manager?

4 Answers   Satyam,


I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?

1 Answers   Cap Gemini, HSBC,






hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

0 Answers  


Explain what is the difference between microstrategy and cognos reporting tool?

0 Answers  


what is query subject

7 Answers   IBM, TCS,


What is the use of report studio?

0 Answers  


How can we create a dynamic column name in cognos?

0 Answers  


i'm searching on cognos..i want to know real time project explanation..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details for project and interview preparation..pls help me out..my mail-id is al.ramu@yahoo.com hope u will respond as soon as possible..thanks..

1 Answers  


what is logs in cognos

1 Answers   HCL,


Categories