Thursday, August 26, 2010

Cognos - Difference between 'Aggregate Function' and 'Rollup Aggregate Function'

The 'Aggregate Function' is used to rollup the values when "Auto Group & Summarize" is set to yes for the query, it applies some logic depending on the datatype. The 'Rollup Aggregate Function' is used for summary values like totals in the report

For example:

Fred       $5
Fred       $15
Barney   $20
Barney   $30

Put both columns on your report,
Aggregate function tells Cognos what to do with them with each other, ie.if you specify Total, this will show...

'Aggragate function'-Total
Fred     $20
Barney $50

'Aggragate fuction'-Average
Fred     $10
Barney $25

'Rollup Aggragate Function' tells Cognos what to do when you want a "Rollup" at the end of the Report or a Grouping (usually a Total or Subtotal, but could be any of the functions.)
So, if Aggregate is set to Total and Rollup is set to Total you get this...
Fred        $20
Barney    $50
Summary $70

If Aggregate is set to Total and Rollup is set to Average you get this...
Fred $20
Barney $50
Smmary $35
Posted by at

5 comments:

  1. SharepointUserAugust 27, 2010 at 6:28 AM

    This comment has been removed by the author.

    ReplyDelete
  2. venkateswarluNovember 22, 2012 at 10:51 PM

    This is very clear, good example.Thanks

    ReplyDelete
  3. UnknownJanuary 9, 2013 at 6:57 PM

    i have a problem with my report. Example, In DataWareHouse have some table _fact and _dim :
    Item_Unit_Cost_fact with Unit_Cost :update data monthly for earch item
    Inventory_fact with Quantity :update data daily for earch item
    Amount=Quantity*Unit_Cost
    Item_Type_dim and Item_dim with Item_type is Item'father .
    How to extract the Quantity,Amount by ITEM_TYPE without the item and show the data is not wrong?

    thanks

    ReplyDelete
  4. SaurabhJuly 24, 2013 at 8:48 AM

    Thanks for the example.

    ReplyDelete
  5. punithaFebruary 9, 2014 at 8:35 AM

    Good Example

    ReplyDelete

Subscribe to: Post Comments (Atom)