Versions Compared

Old Version 1

changes.mady.by.user SNP

Saved on

compared with

New Version 2

changes.mady.by.user Marian Vidra

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info
ListCube Test Case is a collection of ListCube Variants.

...

Creation of ListCube Test Case


ListCube Test Case variant selection screen

...

  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 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 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 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 Image Modified 'Display Description/Technical Name' button. 

ListCube filters selection

...

  1. InfoProviders – The selection of InfoProviders for which ListCube variants are to be generated.
  2. Characteristics in Output – The selection of characteristic InfoObjects that are to be selected in ListCube output (from Validate version 1.4.2 navigational attributes are also supported).
  3. Filter Objects – The selection of characteristic InfoObjects on which you want to define filters (from Validate version 1.4.2 navigational attributes are also supported).
  4. Set Filters (button) – You can define the filtering values of the characteristics selected in the 'Filter objects' select option. 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 Image Modified 'Display Description/Technical Name' button.

Filter values for the generation of ListCube Variants

...

  1. Characteristics in Output – The selection of characteristics for the InfoObjects that are to be selected in the ListCube Variants (from Validate version 1.4.2 navigational attributes are also supported).
  2. Filter Objects – The selection of characteristic InfoObjects on which you want to define the filters (from Validate version 1.4.2 navigational attributes are also supported).
  3. Description suffix – This is what will be added to the description of generated variants. Description of the variants is generated in the form 'Gen. Variant for $INFOPROVIDER_NAME'. If the description suffix is a specified string then '- $SUFFIX' is added to the description.
  4. Set Filters (button) –Defines the filtering values for the characteristics you have selected in the 'Filter objects' select option. Validate does support using more than 100 different characteristics for the filtering. It is possible to swap between the descriptions of filtering fields and their data element by clicking on Image Modified 'Display Description/Technical Name' button. 

Filter values for the generation of ListCube 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

...

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 are displayed. 


Mass Edit Of ListCube Variants

...


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 Validate-related items and not the InfoProvider structures. These Variants should only be imported to a system where Validate is installed and the same InfoProviders with the same structure exist.

...