...
A Query Test Case consists of a number of Query Variants. If you click on the Variants button, a screen for the Query Variants selection is displayed.
Figure 120. Creation of Query Test Case
Figure 121. Query Test Case variant selection screen
...
The screen for creating new Query Variant is accessible by clicking on the Create new Query Variant button (Shift + F1).
Figure 122. Creating new Query Variant
...
- RFC Destination – RFC destination of the Query Variant. When the RFC destination is specified using F4 help, this will display the query name values from the specified destination system. RFC with F4 help is only available if the dialog RFC connection (does not need to be the same as the filled one) is available in the system in the specified RFC destination.
- Query name (required) – the technical name of a query. F4 help is available for this field.
- Query Variant Description – lets – allows you to add a description for the new Query Variant.
- Set query variables – allows you can to specify the filtering values (if any) for a query. For RFC Query Variants there is the possibility to specify the filtering values that are available only if the dialog RFC connection (does not need to be same as filled one) is available in the system to the specified RFC destination and . Validate is also installed on the RFC destination system.
Figure 123. Query Filters
5. After image variant – Query/Bookmark Variant ID enables you to compare the outputs for different queries or for the same query on a different system. This can be executed instead of the variant during the creation of an after image.
6. (hidden) Run as different user - click on the Advanced Settings, an option to run query as a different user is displayed. Query execution under different user may serve to check user authorizations to access data. When the field is left empty, variant will be executed with the current user. Setting is hidden by default, visibility of this setting can be changed in expert settings.
To save, click on Continue (Enter) and the Query Variant is saved. Various checks are done to ensure the correctness of a variant definition before the Variant variant is saved.
| Warning |
|---|
If If different Query/Bookmark Variants are specified for the after image creation then the following rules apply, in order for outputs to be compared. Both of the compared query/bookmark variants must have exactly the same structure of columns/rows to allow Validate to compare them. If the structure of the variants differs, then the correctness of comparison cannot be guaranteed. |
By double clicking on a created Query Variant, you can reenter re-enter the dialog and edit the variant properties. However, it is not possible to edit variant properties, if this variant is already in use for another Test Run.
Create New Bookmark Variant 
Figure 124. Create new Bookmark Variant
...
- RFC Destination – RFC Destination of a system on which the bookmarked query is run on. Validate must be installed on the RFC destination system in order to successfully create a RFC enabled Bookmark Variants.
- Bookmark ID (required) – identification for the query bookmark. Bookmarks that were also created with data can also be used here. In such a case, the bookmarked data is not being read from the bookmark; only the query is executed by using the bookmark structure information.
- Bookmark Variant Description –to – to specify the description for a new Query Variant.
- After Image Variant – Query/Bookmark Variant ID that is executed during the creation of after image. This allows you to compare outputs for different queries or even the same queries on different systems.
The Query Variant is saved when clicking on Continue button (Enter); before saving is complete, various checks are performed to ensure the correctness of variant definition.
Add existing Query Variant 
By clicking the on the Add existing Query Variant button, a list of all the existing Query Variants in the system is displayed. Here you can select your set of variants and by using the Copy button (Enter) these are added into the list of selected variants. Please note that each Query Variant can only be used once for each Test Case.
...
By selecting a test run and clicking the Add Query Variants of Run button a list of all the existing Query Test Runs is displayed and you can add all the variants used in the selected run into to the Test Case variant selection.
...
By selecting a test run and clicking the Copy Query Variants of Run button, a list of all the existing Query Test Runs is displayed and you can add all the variants used in the selected run into to the Test Case variant selection as copies.
...
This functionality is available, only if the HeatMap Query Statistics is are already installed on the system. After clicking on the button Generate Query Variants from HM (Shift + F6), the screen is displayed is where you can define which InfoProvider and Query selection are to be searched for in statistics.
Figure 125. Specification of filter for queries search
After a filter is specified (optional), you can click on the Continue (Enter) button. The next screen displays the information about queries that are present in HeatMap Statistics and the number of times the query was executed in the system.
You can generate the Query Variants from these statistics by selecting queries and specifying the number of variants to be created for each of the selected queries. This number only specifies the maximum number of variants that are to be generated. If there are not enough distinct (in terms of used filters) query executions in the statistics, then fewer Query Variants are generated. Variants are then generated after clicking on Continue button (Enter).
Figure 126. Generation of Query Variants
...
You can also create Query Variants for all of the queries used in specified Web Template, to . To do this you can click on Create Based on Web Template button (Shift + F8).
Figure 127. Selection of Web Template
In this screen you can define the Web Template ID and after clicking on Continue button (Enter) the Web Template is searched for all the used queries. These queries are presented in a table afterwards (Figure 128) and in this table you can choose the queries to be generated for the Query Variants by using the checkboxes.
Figure 128. Queries of web template
For each selected query you are presented with the standard Create New Query Variant screen Variant screen where you can define or change the prefilled pre-filled variant values.
Generate Web Template Bookmark Variants 
...
You can create Query Variants based on a specified Web Template Bookmarks , click by clicking on Gen. Based on Web Template Bookmark button (Shift + F12). The Screen for Web Template Bookmark ID selection is then displayed (Figure 129).
Figure 129. Selection of Web Template Bookmarks for Query Variant generation
Afterwards, click on Continue button (Enter); each Web Template Bookmark selected is searched for all the used queries. For each query found, a new Query Variant is created. All the Query Variants filters are filled with the corresponding filtering values from Web Template Bookmark they were found in.
...
Once the Query Variants have been selected, click on the Continue button (Enter), to save the Variants selection for the Query Test Case and click on the Ok button OK button (Enter) in the Test Management.
By selecting the variants from the list and from the context menu, additional options are displayed where you can access following functions:
Add Variants of Test Case 
By clicking on the Add Variants of Test Case button, a list of all the existing Query Test Cases is displayed and you can add all the variants used in the selected Test Case into to the Test Case variant selection.
Copy Variants of Test Case 
By clicking on the Copy Variants of Test Case button, a list of all the existing Query Test Cases is displayed and you can add all the variants used in the selected Test Case into to the Test Case variant selection as copies.
...
Select multiple variants and create after image variants from them. To access this functionality you need to right click on access the context menu of the selected variants and choose Create After Images as copies. A Dialog is displayed where you can define RFC destination that will be applied to all generated after image variants. All other settings are copied from source variants.
Figure 130. Create After Image Variants as copies
...
You can compare the chosen settings for variant with its defined after image variant (if there is one). Select the requested variants and choose Compare Settings option from the context menu.
Figure 131. Compare settings of before and after image variant
It is possible to check the settings and you can choose what should be compared between variants. After you confirm the selection, the check is done and the table with compare status messages is displayed.
...
You can copy settings of variant to its defined after image variant. After the selection of variants is done, you can choose Copy Settings context menu option. A dialog is displayed where you can define which settings should be copied and the source variant for after image variant (if there is any).
Figure 132. Copy settings of variant to its after image variant
...
You can create copies of Query variants by selecting on multiple variants in the selection table and clicking on 
Copy Query Variants toolbar button. For each selected variant a new variant is created with exactly the same settings as the source variant. If a copied source variant has a different after image variant specified a copy of this would also be created. The copied after image variant is then assigned to copied source variant as its after image variant.
Figure 133. Copy Variants
Generate Query Variants from HeatMap Statistics
This functionality is available, only if the HeatMap Query Statistics is already installed on the system. After clicking on the button Generate Query Variants from HM (Shift + F6), the screen displayed is where you can define which InfoProvider and Query selection are to be searched for in statistics.
Figure 134. Specification of filter for queries search
After a filter is specified (optional) you can click on the Continue (Enter) button. The next screen displays the information about queries that are present in HeatMap Statistics and the number of times the query was executed in the system.
You can generate the Query Variants from these statistics by selecting queries and specifying the number of variants to be created for each of the selected queries. This number only specifies the maximum number of variants that are to be generated. If there are not enough distinct query executions (in terms of used filters) query executions in the statistics, then fewer Query Variants are generated. Variants are then generated after clicking on Continue button (Enter).
Figure 135. Generation of Query Variants
...
You can also create Query Variants for all of the queries used in specified Web Template, to . To do this you can click on Create Based on Web Template button (Shift + F8).
Figure 136. Selection of Web Template
In this screen you can define the Web Template ID and after clicking on Continue button (Enter) the Web Template is searched for all the used queries. These queries are presented in a table afterwards (Figure 128) and in this table you can choose the queries to be generated for the Query Variants by using the checkboxes.
Figure 137. Queries of web template
For each selected query you are presented with the standard Create New Query Variant screen where you can define or change the prefilled pre-filled variant values.
Generate Web Template Bookmark Variants
...
Afterwards, click on Continue button (Enter); each Web Template Bookmark selected is searched for all the used queries. For each query found a new Query Variant is created. All the Query Variants filters are filled with the corresponding filtering values from Web Template Bookmark they were found in.
...