SAP CRM 3.1 oder 3.0: Queries für Zielgruppenselektion definiere 

You use the Business Explorer Analyzer (BEx Analyzer) for the InfoCube 0UCMA_C01 (target group selection by revenue and consumption) to define the queries target group selection.

In order to use these queries for target group selection with the Segment Builder in CRM, drag the characteristics that you want to use as selection criteria to the Lines area and the required key figures to the Columns area of the query.

The 0BPARTNER characteristic (business partner) is mandatory, since the segment builder uses it for target group selection. It can be found in the Lines area or as a free characteristic.

To improve system performance, we recommend that you restrict the values of the characteristics used in the query. This is because the segment builder can only filter using one characteristic at any time. In the query, you must also define the conditions you require for the key figures.

To complete the query  definition, set the Release for OLE DB for OLAP indicator in the global attributes.

If you require criteria from the master data for BW target group selection, check that they are available in BW as navigation attributes of the 0UCMA_C01 InfoCube. This is the case for many attributes of the master data contained in the InfoCube. When you define the query, these attributes can be selected for navigation. In this way, you avoid having to re-read master data via customer enhancements to the extractor and can use the most up-to-date version of the data (from the last master data upload).

As part of a campaign, all the retailers in Boston with a minimum commercial consumption of 100,000 kWh are to be addressed.

In the BEx Analyzer, the query ZUCMA_C01_Q085 (Target group selection,.Regional data, consumption, industry) is defined. The interval of the consumption months, the country and the city code from the city file (UC1T-A-00 in the example) are given as restrictions to the corresponding characteristics. Furthermore, the move-out date of the contract is set to 12/31/9999 (contract does not expire) in order to exclude the master data of expired contracts (generally of no importance to target group selection).

The key figure 0UCMA_C01_CK001 (total consumption from energy) is a standard key figure that displays the total of billed and extrapolated consumption.It uses the rule Total consumption from energy =>100,000 kWh. This rule must be restricted to the 0BPARTNER (business partner) characteristic.

When you define the list of selection attributes for the segment builder in CRM, the Industry characteristic for the installation (contained in the query definition) can be activated. In the selection attributes or in the segment builder, you can set filters, for example by the Retail industry (industry code 001). For details on the segment builder and the selection attributes list see section Working with the CRM Section Builder.