Show TOC

Limiting Data VolumeLocate this document in the navigation structure

Use

The Limit Data Volume transformation enables you to restrict the volume of data to be processed by specifying selection conditions. The columns in the table are not changed. Single values and intervals are available to specify the condition.

Prerequisites

If you want to use variables, you must have created them in the Query Designer.

For more information, see: Variables

Activities
  1. On the Field Selection tab page, select the fields for which you want to specify conditions.

  2. On the Filter Conditions tab page, enter the conditions for these fields.

  3. Choose Complex Selections to specify multiple conditions for a field.

  4. You can use variables in your selection conditions, for example, to always filter data for the current month. You may only use variables if the fields are InfoObjects. To do this, choose the Variables button next to the Selection From or Selection To column. In the dialog box that is displayed, you can select the required variable and can specify, for example, an offset for time characteristics.

    Caution

    You can only use those variables that do not require manual input.

    You cannot create complex selections with variables; this means, for each field, you can enter just one selection condition with variables.

Example
  1. You only want to read the data for specific customers from a DataStore object. For this purpose, you add a filter node to the analysis process, in addition to the InfoProvider data source. If you define the interval 1000-2000 as a filter condition for the Customer field, this condition is passed on to the data source during execution. This reduces the volume of data read.

  1. Filter with Variable: You want to use the filter to select the data for the previous three months. Variable CURRMON, which returns the current month, exists for time characteristic 0CALMONTH. For the corresponding field in the analysis process, enter the variable CURRMON and the offset -3 for Selection From. For Selection To, enter CURRMON and the offset -1.