what is the difference between aggregation and roll up
aggregation?

Answer Posted / magiccube

Aggregation: It will sum up all group column data.

Rollup Aggregation: It will sum up Groupwise data.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to create measures and dimensions?

604


what are the dimensions that you have in your current project?list them?

1594


----------------Diff b/w Dimensional modeling and Relational modeling?

13886


What is Online View?

1561


How to do Performence Tunning in Cognos Reports?

2066






What are the types of studio present in Cognos?

609


What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2140


How to generate cubes in cognos?

558


What is defined as data mining?

597


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4070


Define query items?

589


What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

3912


Which lifecycle we will use for reporting?

555


How can I test reports in cagonos?

546


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1479