(Glue-2011) Generate the Variants for Query Extraction

This document describes the process of creation and subsequent execution of variants for BW query extraction by using the Datavard tool Task Handler. After the execution of the variant for the BW query extraction, the standard SAP job is created that replicates the specified data into external storage. 

Generation of query variants

To generate the variants for query extraction proceed as follows:

1. Run the transaction /DVD/GL_GEN_QVAR
   
2. Specify the following parameters: 
   • Extractor - name of the extractor for which the variants should be generated. You may use F4 help.
     
   • Variant Name Prefix - prefix of the variant name. The complete name of the variant is generated from this prefix and an incremental number.
     
   • Description Prefix - prefix of the variant description. A complete description is also generated from this prefix and an incremental number.
   • Package Size - maximum number of rows transferred within one package. This field defines the package size for each variant you generate through the next selection screen.
     
     
3. You may choose between two options on how to generate variants.

   1. The first option is to generate the query variants in the selection screen. In the selection screen, you can specify the values for a variant generation.
      Based on specified values, the program reads the master data of an InfoObject and generates the variants for all combinations of selected values.
      
      

      To perform this:

      1. Click Continue.
      2. Mark the checkboxes with variables you want to use for your selection.

      3.  Specify the values for previously selected variables under Values selection.
         
         

         

         Variants generation example

         Using the variants generator, see the screenshot below as an example, the following variants will be generated:

         Variant Name	Smoker	Manager	Facility or State Park
         Variant 1		BENEDICT SHAFFER	OPERATIONAL
         Variant 2		BENEDICT SHAFFER	OPERATIONAL
         Variant 3		CAMERON SANTANA	OPERATIONAL
         ...
         Variant N-1		REECE WEST	OPERATIONAL
         Variant N		REECE WEST	OPERATIONAL

   2. The second option is to generate the query variants from a CSV file.
      
      To perform this:
      

      1. Select Generate template in the previous Generate Variant for Query Extractor screen. Using this template, you can manually define the variants you want to generate.
         See template.csv as an example of the generated template file. 

      2. Select Generate variants from .CSV.
         Each variant is defined by a number of lines (depending on the number of queries parameters), where each line represents the value for 1 parameter. A line consists of the following columns:

         • Variant name
         • Query variable technical name
         • Selection type - the type of the statement, either P - Parameter or S - Select option
         • Sign - whether the result of the row condition is included or excluded from the resulting set. Possible values are I - inclusive and E - exclusive.
         • Option - selection operator. Possible values are EQ - equal, NE - not equal, GT - greater than, LT - less than, LE - less than or equal, GE - greater than or equal, and BT - between.
         • Low value
         • High value
4. The following confirmation screen displays the exact number of variants, which will be generated. Confirm and check the results in the Extractor Workbench afterward - newly generated query variants should appear under your extractor.
5. After the variants are generated, you can find them under specified extractor in Glue Extractor Workbench and (Glue-2011) Execute the Data Extraction in parallel by using Task Handler tool.