(DV-2211) ListCube Test case Definition

After you click on the 'Variants' button a screen for ListCube Variants selection is displayed 

_{Creation of ListCube Test Case}

_{ListCube Test Case variant selection screen}

Here you can create a new or add an existing ListCube Variants into a ListCube Test Case. All functions are accessible from the toolbar menu.

Create New ListCube Variant  

The screen for creating a new ListCube variant is displayed after clicking on the 'Create New ListCube Variant' button (Shift + F4). 

_{Create a new ListCube Variant screen}

In this screen you can specify the following variant detail:

1. RFC Destination – RFC Destination of the system where the InfoProvider is to be read. When the RFC destination is specified, the F4 help displays values from the specified RFC destination in the InfoProvider field.
2. Variant Description – description of the new ListCube Variant.
3. InfoProvider (required) – technical name of the InfoProvider to be read. F4 help is available for this field.
4. Max. Rows. – Max. Rows. – Maximum number of rows to be read from the InfoProvider. If this field is set to 0 or left empty, then all possible rows will be selected. 0 value should be always used as ListCube functionality does not guarantee the order of rows returned.
5. Data Access Type:
   1. Read Online Data – option to read-only online data via the ListCube.
   2. Read Online + NLS Data – option to read the NLS Data via the ListCube. This option is ignored for releases below 7.3 (i.e. only online data will be read for such releases).
   3. Read Only NLS Data – option to read-only data from NLS. InfoProvider that will be read will need to have an active DAP created. This option is not release-dependent.
   4. Read Online / Read NLS Data – when this option is selected two variants are generated with the only difference being in the data access type. One variant is generated with Read Online Data option selected while the second one is created with the Read-Only NLS Data option selected.
6. Use DB Aggregation – option to use DB Aggregation for the ListCube execution. It is always recommended to use DB aggregation so the output of ListCube is aggregated on the Database level. This reduces the chance of multiple rows with the same key and image memory footprint. Turning this setting off should only be done in special cases when the SNP Validate additional aggregation is used.
7. Display the number of Hits – option for the column 'ROWCOUNT' to be added to the output of ListCube.
8. Use mat. Aggregates – option to use materialized aggregates during the ListCube execution. If selected the defined aggregates should be used for the InfoCube when preparing the output list. If you choose to use materialized aggregates, the query is not executed directly in the fact table, instead, aggregate tables are used and performance is improved. However, if aggregates are not recalculated there may be differences in the data returned.

9. Use Conversion: If enabled, on writing into the Cluster step the info objects conversion exit will be applied to the data. Important Note: In the current version of SNP Validate the Automated Root Cause Analysis doesn't support this.

10. Characteristics in Output – selection of the defined characteristics to be selected from the InfoProvider (from SNP Validate version 1.4.2 also navigational attributes are supported). All the key figures are always selected together with the unit characteristics*.
11. Set Filters (button) – used for defining the filter values to be displayed and you can define the filtering values to be used during ListCube execution. It is possible to swap between the descriptions of filtering fields and their data element by clicking on  'Display Description/Technical Name' button. 

_{ListCube filters selection}

11. After Image Variant – ID of the ListCube variant that is used for the after image creation. Allowing you to compare the output of different InfoProviders or InfoProviders from different systems.

12. Referenced Time point – click on the 'Advanced Settings', an option to set up the reference time point is displayed. The referenced time point is the date and time setting that is used in the following way: When a ListCube Variant has a referenced time point set up, a check is done before each execution. This check searches for the load request ID from all of the requests in the system that has an update time equal to or lower than the specified referenced time point. This request ID is then used in ListCube execution as a filter on the 0REQUID field where the condition is set to – Select all the data with 0REQUID equal to or lower to the found request ID. You can make a snapshot of only part of this data available in InfoProvider. Please see the important notes below for any restrictions that apply to this functionality.

It is also important that the referenced time point specified by the user is the same Time Zone setting as the user who will execute the test in SNP Validate. In addition, when searching for a referenced time point on the remote server you need to also check that the user (or RFC user if used) has the same time zone setting as the user who will execute the tests in SNP Validate. 

For ADSO InfoProviders the filter is created on top of the 0REQTSN field while using the same logic. For composite providers, filters are created on both 0REQUID and 0REQTSN fields.

13. Exclude old data – mark this checkbox if you want the ListCube variant to read data newer than the specified referenced time point instead of the older ones.

14. Excluded Key Figures – All Key Figures specified here will be not read from the InfoProvider during the image creation. If excluded, the key figure does use a unit that is not used by any of the non-excluded key figures this unit will also not be read from the InfoProvider.

15. Excluded Units – You can define which units that are not to be read from InfoProvider during the image creation. For each excluded unit all key figures that are dependent on this unit will be excluded automatically from the InfoProvider read.

To save the ListCube Variant click 'Continue' (Enter), before saving various checks are done to ensure the correctness of the variant definition.

*Important Notes:

• All the key figures and appropriate unit/currency characteristics are always returned in the ListCube output. There is an exception for Key Figures with the aggregation function NOP. When the 'Use DB Aggregation' setting is active, Key Figures of this type are not returned in the output.
• All characteristics of the InfoProvider (from SNP Validate version 1.4.2 navigational attributes are also supported) are checked for compliance with the specified characteristic selection. If yes then they are returned in ListCube output.
• From SNP Validate version 1711 order of characteristics for output is important. The same order will be used for storing data of the current image. Make sure before/after images have the same order/number of key characteristics otherwise, data comparison will not be successful. 
• Reference Time Point setting usable only for InfoCubes, MultiProviders, certain types of ADSOs, and Composite Providers. For other InfoProviders, this setting is ignored, as it is not possible to use the filtering on 0REQUID/0REQTSN field in the ListCube. For InfoCubes this setting influences only the read data from the Fact table. For ADSOs read of data from the Inbound table. Please note that in MultiProvider Cubes, this setting will affect the InfoCubes below but not the DSOs as their data have 0REQUID set to value ‘0’. 
• t to value '0'.

Add Existing ListCube Variant 

The 'Add Existing ListCube Variant' button displays all existing ListCube variants in the system and you can select one or more variants to be added to the current Test Case.

Add ListCube Variants of Run 

The 'Add ListCube Variants of Run' button displays all the ListCube runs in the system and you can select one that variants to be added into the current test case.

Copy ListCube Variants of Run 

The 'Copy ListCube Variants of Run' button displays all the ListCube runs in the system and you can select one that variants to be added as copies into the current test case.

Generate ListCube Variants 

The Screen for the generation of ListCube variants is displayed after clicking on the 'Generate ListCube variants' button (Shift + F5). 

_{Generate ListCube Variants screen}

1. InfoProviders – The selection of InfoProviders for which ListCube variants are to be generated - Characteristics are also supported as InfoProviders.
2. RFC destination- Where the InfoProvider is located
3. Description - Placeholders: [PL_NAME] - Test plan, [TC_NAME] - Test case, RUNID - RunID.
4. Characteristics in Output – The selection of characteristic InfoObjects that are to be selected in ListCube output (from SNP Validate version 1.4.2 navigational attributes are also supported).
5. Filter Objects – The selection of characteristic InfoObjects on which you want to define filters (from SNP Validate version 1.4.2 navigational attributes are also supported).
6. Select Mapping to be used for generated variants
7. Button for opening screen for entering multiple InfoObjects
8. Set Filters (button) – You can define the filtering values of the characteristics selected in the 'Filter objects' select option. SNP Validate does not support more than 100 different characteristics for filtering. It is possible to swap between the descriptions of filtering fields and their data element by clicking on  'Display Description/Technical Name' button._{Filter values for the generation of ListCube Variants}
9. Checkboxes for functions to be used on the generated variants: DB aggregation (It is turned on by default in SNP Validate settings), Mat. aggregation and Conversion exit.
10. Data Access Type:
    1. Online – option to read only the online data in the generated ListCube variants.
    2. Online and NLS– option to read the NLS Data in the generated ListCube variants. This option does not apply for releases below 7.3 (i.e. only online data will be read for such releases).
    3. NLS – option to read only the data from NLS. InfoProviders that are to be read need to have an active DAP created.
11. Must click to 'Before'/'After' to enable these settings, you can define
    1. Timestamp to specify what data within a certain time range should be excluded.
    2. Key figure: Key figures to be excluded - entering them works the same as Characteristics
    3. Units: Units to be excluded - entering them works the same as Characteristics
12. Maximum Rows – You can define the maximum number of rows to be selected in all generated ListCube variants. Leave empty for the unlimited number of rows.
13. Display Number of Hits – The option to add column 'ROWCOUNT' to the output of generated ListCube Variants.
14. Buttons in this column are for copying values from Before to After image.
15. In order from left to right: Check (ctrl + F2) - Checks entered data, Generate (ctrl + F3) - Generate variants, Cancel (ESC) - Exit generator
16. Refresh screen - it erases all entered data.
17. Button to transform generator into ListCube Outboard variant generator.

After starting generating, you will be prompt to start it.

The InfoObjects are filtered based on current InfoProvider being processed and only valid ones will be added to a newly generated Variant. After generation is done, log is displayed.

In case there are no errors the screen closes itself and adds created variants into either test case or test plan, based on where the generation was started.

By clicking on the 'Show OutBoard Variants' button you can generate ListCube variants based on NLS secondary indexes. This option is only supported when SNP OutBoard ^TM is installed on the same system as SNP Validate.

_{Generate ListCube Outboard Variants screen}

1. InfoProviders – The selection of InfoProviders for which ListCube variants are to be generated - Characteristics are also supported as InfoProviders.
2. RFC destination - Where the InfoProvider is located
3. Description - Placeholders: [PL_NAME] - Test plan, [TC_NAME] - Test case, RUNID - RunID.
4. Characteristics in Output – The selection of characteristic InfoObjects that are to be selected in ListCube output (from SNP Validate version 1.4.2 navigational attributes are also supported).
5. Button for opening screen for entering multiple InfoObjects
6. Checkboxes for functions to be used on the generated variants: DB aggregation (It is turned on by default in SNP Validate settings), Mat. aggregation.
7. Outboard specific settings: 
   1. Maximum variants: InfoProviders can contain large amounts of archiving requests and for each arch. request is created one test variant. By this setting, we can define the maximum number of variants generated from one InfoProvider.
   2. Select by: additional filter for maximum variants. We can select to generate x Largest/Most average/Smallest variants (where x are maximum variants defined in Maximum variants field) from archiving requests.
8. Maximum Rows – You can define the maximum number of rows to be selected in all generated ListCube variants. Leave empty for the unlimited number of rows.
9. Display Number of Hits – The option to add column 'ROWCOUNT' to the output of generated ListCube Variants.
10. Buttons in this column are for copying values from Before to After image.
11. Button to transform into general ListCube variant generator
12. In order from left to right: Check (ctrl + F2) - Checks entered data, Generate (ctrl + F3) - Generate variants, Cancel (ESC) - Exit generator
13. Refresh screen - it erases all entered data.

After the generation is confirmed the InfoProviders archived via OutBoard NLS that has active DAP (Data Archiving Process) multiple variants are generated. The number of variants depends on the number of archiving requests for which secondary indexes are defined. Each variant is then created with filters defined by the archiving request index selection. If the index selection object cannot be used in ListCube, it is omitted. 
By selecting the variants additional options are displayed in the context menu where you can access the following functions:

Add Variants of Test Case 

The 'Add Variants of Test Case' button displays all the ListCube Test Cases in the system and you can select one that variants to be added into the current test case.

Copy Variants of Test Case 

The 'Copy Variants of Test Case' button displays all the ListCube Test Cases in the system and you can select one that variants to be added into the current test case as copies.

Create After images as copies

Select multiple variants and create after image variants for them. To access this functionality, in the context menu of the selected variants choose 'Create After Images as copies'. A Dialog is displayed where you can define the RFC destination that will be applied to all generated after image variants. All other settings are copied from source variants.

_{Create After Image Variants as copies}

Compare settings

You can compare chosen settings for variant and it's defined after image variant (if there is one). Select the requested variants and then choose the 'Compare Settings' option from the context menu. 

_{Compare settings of before and after image variant}

Settings that can be checked are displayed and you can choose what is to be compared between the variants. After you confirm the selection check is done and the table with compare status messages is displayed.

Copy settings

You can copy the settings of variants to its' defined after image variant. After the selection of variants, choose 'Copy Settings' from the context menu. A dialog allows you to define which settings are to be copied from the source variant to the after image variant (if there is any). 

_{Copy settings of the variant to its after image variant}

After you confirm the selection, the specified settings are copied and a message table is displayed with information about the updated variants.

Copy variants

You can create copies of ListCube variants by selecting multiple variants in the selection table and clicking on  'Copy ListCube 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 then a copy of this will also be created. The copied after image variant is then assigned to a copied source variant as an after image variant. 

_{Copy Variants}

Edit ListCube Variant

To edit the existing ListCube variants, you double click on these in the table, only Variants that are not already used in a Test Run can be edited. If a ListCube Variant is already being used, their details can be only reviewed but not changed. 
When variant details are displayed you can check where this variant is used. By pressing the 'Where Used'  button, a table is displayed that contains all Test Plan/Test Case/Run ID information where this variant is used. 

_{Where Used List for Variant}

By clicking on  'Copy Settings to After Image' button you can copy specified settings of this variant into its After image variant if it is specified.

Mass Edit Variants

You can edit more ListCube variants at once. Mass edit is performed by selecting the variants in the list and clicking on 'Mass Edit Variants'  button, a dialog for mass editing the selected variants is displayed. 

_{Mass Edit Of ListCube Variants}

You can define new values for numerous settings. Changing these values is done after clicking on the 'Continue' (Enter) button. Only the values which you specified to be changed, using the marking 'Edit' checkbox (on left) will be replaced in the selected variants. If a ListCube variant has a different After Image specified, then only the After Image parameters will be replaced in that variant, as nothing else needs to be updated with the changes. Note: Only variants that are not yet used in test runs can be changed by mass edit. Settings you can change are:

• RFC Destination – RFC destination of the system where ListCube will be executed
• Use DB Aggregation – The option to select if DB aggregation should be used in the generated ListCube variant.
• Use mat. aggregates – To choose if the mat. aggregates are to be used in the generated ListCube variant.
• Display Number of Hits – The option if the column 'ROWCOUNT' is to be added to the output of the generated ListCube Variant.
• Use Conversion Exit – If enabled, on writing into the Cluster step the info objects conversion exit will be applied to the data
• Read – Data access type
• Mapping ID – ID of the field mapping that will be used when comparing ListCubs. Support F4 help or double-click to create a new one.
• Reference Time and Reference Date – When a ListCube Variant has a referenced time point set up, a check is done before each execution. This check searches for the load request ID from all of the requests in the system that has an update time equal to or lower than the specified referenced time point. This request ID is then used in ListCube execution as a filter on the 0REQUID field where the condition is set to – Select all the data with 0REQUID equal to or lower to the found request ID. You can make a snapshot of only part of this data available in InfoProvider.
• Exclude Old Data – Check this checkbox if you want the ListCube variant to read data newer than the specified referenced time point instead of the older ones. 
• Max Rows To Display – Max rows to display

Additional options available from (DV-2211) Variant Editor:

Delete ListCube Variants

To delete the existing ListCube Variants, select the rows and click on the delete button in the ALV toolbar. 

Transport ListCube Variants

You can add ListCube Variants to the transport, so these can be transferred to another system (with SNP Validate installed). Specify the ListCube Variants you want to transport by selecting them from the list (Figure 146). There are options for filtering and sorting in the ALV table and can be used to select specified ListCube Variants more easily. 

_{Selecting ListCube Variants to be transported}

After selecting the desired ListCube Variants and clicking on the  'Transport ListCube Variants' button, a screen for choosing the transport request is displayed, once selected press Confirm. 
It is important to note that ListCube Variants only carry the information about SNP Validate-related items and not the InfoProvider structures. These Variants should only be imported to a system where SNP Validate is installed and the same InfoProviders with the same structure exist.

ListCube with mapping - Test Case Definition

The ListCube with the mapping test Case consists of a number of ListCube Variants. If you click on the 'Variants' button a screen for the ListCube Variants selection is displayed.

_{Creation of SLO ListCube Test Case}

The SLO ListCube scenario uses the same variants as the standard ListCube scenario therefore the same screen is displayed.