Versions Compared

Old Version 2

changes.mady.by.user Marian Vidra

Saved on

compared with

New Version Current

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.

...

  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 add ListCube Variants to the transport, so these can be transferred to another system (with 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

...