Copying with dynamic ranges

Dynamic ranges can be compared to filters for source elements. If you create a dynamic range, the source elements that correspond to the filter of a dynamic range, are copied into the dimension. If source elements are added that match the filter criteria, they will automatically be added to the dimension, when you open the dimension in OLAP. Thus, you ensure that the dimension always contains all elements matching the properties that you have specified, even if the source database has changed.

To create a dynamic range, click Add on the Dynamic ranges tab. The Dynamic Range dialog opens. Specify the name and the description of the dynamic range.

To select the filter criteria, click Filter in the dialog. The Filter dialog opens. By combining the fields Column, Operator, and Value you specify the filter criteria:
Field Description
Column Select the column of the source table, by which the values are to be filtered, for example, ID.
Operator Select a comparison operator for this value, for example, > (the SQL convention applies to operators).
Value Specify the value that will be checked by the comparison operator of the Operator field using the value of the field Column, for example, 1,000 (the SQL convention applies to wildcards).

Example

Example: Select the ID column from the drop-down list Column. Select the operator > (greater than) from the drop-down list Operator. Specify the value 1,000 into the Value field. As a result, all source elements with an ID greater than 1,000 are transferred into the element list.

To combine various filter criteria, define additional criteria in the Filter dialog. With the option buttons AND and OR you determine, whether those source elements are added exclusively that match all criteria (AND; restrict list), or whether source elements only have to match one of the two criteria (OR; expand list).

To save the dynamic range, close the dialogs Filter and Dynamic Range and click Save on the Dynamic range tab.

Note: If you select the option Use default mapping when creating a business group, a dynamic range will be created in the mapping, which copies all source elements into the element list. Filter: Id LIKE %.