Show TOC

Specifying Selections for IndexingLocate this document in the navigation structure

Context

You can selectively index ODP data in the database or in the SAP NetWeaver BW Accelerator. This means that you do not always have to index all of the data from the source. Instead, you only need to replicate data that is relevant for the analysis (the data for the current fiscal period, for example).

For information about query behavior dependency on indexing selections, see Using the Analytic Query for an Operational Data Provider.

Procedure

  1. Call the indexing selections maintenance screen by executing transaction RODPS_REPL_SEL.

    Alternatively, you can call the selection maintenance screen by choosing Start of the navigation path Associated Links Next navigation step BW DataSource Extraction Filter End of the navigation path in the Administrations Cockpit.

  2. In the Model and Node, select the node who DataSource you want to define the selection conditions for.
  3. Confirm your entries.

    If selection conditions have already been defined for the DataSource, the system shows these in the table.

  4. Create a new table entry for every selection condition:
    1. To define a selection condition for a field, choose Insert Row.

    2. Select the DataSource field under Field Name and make the relevant entries under From Value and - if necessary - under To Value. For character type data types, you can use * or + as placeholders. # is defined as the escape character.

      From the entries that you have made, the system derives the selection options EQ, BT or CP.

      Note

      A variable selection can be made for the following date fields:

      • Calendar month fields with domain RSCALMONTH

      • Calendar day fields with the integrated ABAP type D (8 character date fields with the format YYYYMMDD)

      You can define variable selection in the From Value column by placing a minus sign in front of the value. The entry is as follows: -<A number that defines how many calendar days or calendar months to take into account before replication>. In the To Value column, you define the variable selection by placing a plus sign in front of the value. The entry is as follows: +<A number that defines how many calendar days or calendar months to take into account after replication>. For the above-mentioned date fields, the plus sign is not interpreted as a placeholder.

      For example, you can make a setting for the Calendar Day field so that the last 10 calendar days are included when the data is indexed. To do this, enter -10 under From Value.

      The current calendar day or calender month can be selected by +0 or -0.

  5. When defining multilple selections, note the following:

    Multiple selection conditions for a field are interpreted as an OR link. Multiple selection conditions for more than one field are interpreted as an AND link.

    Example

    If you define two selection conditions for CARRID, one with From Value= AA and the other with From Value= BA, the conditions are interpreted as (CARRID = AA OR CARRID = BA) during the indexing process.

    If you also define a selection condition for FLDATE with From Value= 20100101 and To Value= 20111231, all conditions are interpreted as (CARRID = AA OR CARRID = BA) AND (FLDATE BT 20100101 AND 20111231) during the indexing process.

  6. Check and save the selection conditions entered.
  7. If you want to define more DataSource selection conditions, choose Other Node. The entries for Model and Node are removed together with the table entries. You can continue as described under Step 3.

Results

During the indexing process, the selection conditions defined here are applied.

If an extraction filter has already been defined in the modeling screen for search and analysis in the Node Reply step for a model whose DataSource already has selection conditions defined for it, the conditions are linked with one another during indexing.

Example

If you have set X for FLTYPE in the modeling screen for search and analysis and you have set the From ValueLH in transaction RODPS_REPL_SEL for CARRID, the selection conditions are interpreted as (FLTYPE = X) AND (CARRID = LH) during the indexing process.