> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: Cube Transformation

> Use the Cube and Rollup transformation to group data by field combinations and apply aggregate functions like Count, Average, Min, and Max.

<Frame>
  <img src="https://mintcdn.com/integrateio/2ttHYDu3EKov-VoY/images/creating-packages/using-components-cube-transformation/image-1.png?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=bba8b26578e48d606e901a7a9c5a03eb" alt="Cube component configuration panel" width="1200" height="828" data-path="images/creating-packages/using-components-cube-transformation/image-1.png" />
</Frame>

## Grouping fields

Select the grouping dimensions for the cube. The Cube transformation produces combinations of the selected fields and applies aggregate functions to each combination.

<Frame>
  <img src="https://mintcdn.com/integrateio/2ttHYDu3EKov-VoY/images/creating-packages/using-components-cube-transformation/image-2.png?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=8ff61bfe3c30038ff4d479c9891627f7" alt="Selecting grouping dimension fields for the Cube" width="1200" height="828" data-path="images/creating-packages/using-components-cube-transformation/image-2.png" />
</Frame>

<Frame>
  <img src="https://mintcdn.com/integrateio/2ttHYDu3EKov-VoY/images/creating-packages/using-components-cube-transformation/image-3.png?fit=max&auto=format&n=2ttHYDu3EKov-VoY&q=85&s=57ecbfc37f77c8800a9eae42e6b1a063" alt="Cube grouping fields with multiple dimensions selected" width="1200" height="828" data-path="images/creating-packages/using-components-cube-transformation/image-3.png" />
</Frame>

## Aggregate functions

Select the aggregate function and input arguments and assign each an output alias. The Cube component works similarly to the Aggregate transformation but generates multiple grouping combinations (including subtotals and grand total) in a single pass.