Rollup
===========

Rollup Node generates a result set that shows aggregates for a hierarchy of values in the selected columns.

Type
--------- 

transform

Class
--------- 

fire.nodes.etl.NodeRollup

Fields
--------- 

.. list-table::
      :widths: 10 5 10
      :header-rows: 1

      * - Name
        - Title
        - Description
      * - rollupCols
        - Rollup Columns
        - 
      * - aggregateCols
        - Aggregate Columns
        - Aggregate Columns
      * - aggregateOperations
        - Aggregate Operation to use
        - Aggregate Operation


Details
-------
Rollup Node generates a result set that shows aggregates for a hierarchy of values in the selected columns.


Outgoing Dataframe is created by applying aggregated functions on aggregate columns for all combinations of values present in the selected cube columns.


More than one aggregations can be selected.


It is same as Cube node with data displayed in hierarchical order.


Examples
-------
Incoming Dataframe has following rows:


::

    EMP_CD    |    EMP_NAME    |    LOCATION    |    DEPT         |    SALARY
    -----------------------------------------------------------------------------
    E05       |    ROSS        |    NEW YORK    |    FRONT DESK   |    10000
    E06       |    LISA        |    NEW JERSEY  |    FRONT DESK   |    11000
    E07       |    PAUL        |    NEW YORK    |    MAINTENANCE  |    12000
    E08       |    MARK        |    NEW JERSEY  |    MAINTENANCE  |    13000


if Rollup node is configured as below:


ROLLUP COLUMNS      :    LOCATION, DEPT


::

    AGGREGATE COLUMNS    |    AGGREGATE OPERATION
    -------------------------------------------------
    SALARY               |    SUM


then outgoing Dataframe would be created as below after performing specified aggregation

Summation of Salary all Employees is computed for all combinations of values present in [LOCATION] and [DEPT] columns:


::

    LOCATION           |    DEPT           |    sum_SALARY
    ----------------------------------------------------------------
                       |                   |    46000               <=    Summation for all values
    NEW YORK           |                   |    22000               <=    Summation of Salary of Employees at NEW YORK location                                            
    NEW YORK           |    FRONT DESK     |    10000               <=    Summation of Salary of Employees at NEW YORK in FRONT DESK department
    NEW YORK           |    MAINTENANCE    |    12000               <=    Summation of Salary of Employees at NEW YORK in MAINTENANCE department
    NEW JERSEY         |                   |    24000               <=    Summation of Salary of Employees at NEW JERSEY location
    NEW JERSEY         |    FRONT DESK     |    11000               <=    Summation of Salary of Employees at NEW JERSEY in FRONT DESK department
    NEW JERSEY         |    MAINTENANCE    |    13000               <=    Summation of Salary of Employees at NEW JERSEY in MAINTENANCE department