Was this page helpful?
Yes No
Have a comment? Please leave it here.Thanks for your feedback!

Home > 

Reference > Quick Starts > Quick Starts about Connections and Data Sources > Aggregated Extracts

Quick Start: Aggregated Extracts

You can optimize your extracts by only including the data you need. Specifically, you can exclude columns, create filters to limit the number of rows, aggregate data, and roll up dates.

1 Hide unused fields

Hidden fields are not included when you create an extract. By hiding unnecessary fields before you create an extract, you make the extract smaller and improve performance.

On the Data pane, click the drop-down arrow to the right of Dimensions and select Hide All Unused Fields from the context menu.

2 Define filters for the extract

Right-click the data source and select Extract Data.

In the dialog box, optionally define one or more filters to limit how much data gets extracted.

Global filters are automatically added as filters on the extract.

3 Aggregate data for visible dimensions

After defining any filters, select Aggregate data for visible dimensions. This aggregates the data using the default aggregation for measures.

If the extract contains Date fields, you can also select Roll up dates to to adjust date granularity and further minimizing the size of the extract.

4 Click Extract

When ready, click Extract and specify a location for the extract (TDE) file. The extract will only contain the visible fields and the data will be aggregated as you specified.

Refresh the extract at any time by selecting Data > Refresh All Extracts from the toolbar.