Generate and Execute Random Queries

[ccc_ccc]

ABAP Program

RSDRT_INFOPROV_RANDOM_QUERIES

Purpose

With this program, a sequence of simple queries can be generated and executed randomly.

You can execute, record and compare this sequence with one that was recorded previously. To reproduce an error, it is also possible to "replay" a certain query of a sequence.

Selection

•Specify the name of the InfoProvider

•Specify the number of queries here that is to be generated.

•Here, specify a start value for the random number generator. This must be an integer that is not equal to 0. This value determines a sequence of random numbers. This value can be used to reproduce a random sequence.

•Here you can specify the time in seconds between execution of queries.

•If you enter a value here that is not equal to 0, only the query stated will be executed from the sequence.

•This option is only relevant if the InfoProvider entered above is an InfoCube: Here you can select whether aggregates should be used in query execution or not.

•Here you can specify whether the result of the  sequence is to be saved as a trace. A sequence is uniquely characterized by the first three parameters, that is, the InfoProvider, the number of queries and the start value of the random number generator.

•Any result that has already been recorded for the same sequence (InfoProviders, queries, start value) will be overwritten.

•Here you can activate or deactivate debug mode.

•Here you can force comparison of the specified sequence of queries with a sequence recorded earlier (as available). The standard comparison includes:
o Number of results rows
o Average of all key figure values

•Here you can force another comparison with a sequence recorded previously, that is, the comparison of query execution times. You can specify what max. percentage slower the query currently being executed can be compared to the one that was recorded previously.