In this example, a variant is defined for a BW selection screen that can then be used to personalize the variables 0DISCHAN, 0DIVISIO, 0I_CALMO, 0P_SLSOF and 0SALEORG that are defined in the query. The time variable 0I_CALMO is filled using the function module SMO2_VARIANT_DATE_CONVERSION (interval extending across the last 12 months). The system takes the selection values for the other variables from CRM Middleware subscriptions that already exist for the users. The definition could thereby look as follows:

The prerequisite for this mechanism is a technical understanding of how the CRM Middleware criteria and the variables defined in BW are related. In the example, the BW variables 0DISCHAN, 0DIVISIO, and 0SALEORG correspond to the CRM Middleware criteria fields of the replication object CAPGEN_OBJECT_WRITE of the respective publication Customer & Prospects. Provided the corresponding subscriptions exist, the Preview for July 2001 would lead to a screen like the following: