Page Comparison

...

Backend Testing scenarios:

Query/wiki/spaces/KATE/pages/14564658

Listcube Execution & Backend Testing

Drill Down testing

Transformation testing

Table based testing

Report based testing

...

/wiki/spaces/KATE/pages/14565441

/wiki/spaces/KATE/pages/14616661

/wiki/spaces/KATE/pages/14613549

/wiki/spaces/KATE/pages/14616914

/wiki/spaces/KATE/pages/16817513

Anchor
Comparison logic Comparison logic

Comparison logic

...

• Before Runtime [s] (optional) – runtime of Query/Table/ListCube/SLO ListCube/DTP load/ Drilldown execution in Before image.
• After Runtime [s] (optional) – runtime of Query/Table/ListCube/SLO ListCube/DTP load/Drill Down execution in After image.
• Before Runtime [hh:mm:ss] (optional) – runtime of Query/Table/ListCube/SLO ListCube/DTP load / Drilldown execution in a Before image in time format.
• After Runtime [hh:mm:ss] (optional) – runtime of Query/Table/ListCube/SLO ListCube/DTP load /Drill Down execution in a After image in time format.
• InfoProvider A Runtime [hh:mm:ss] (optional) – runtime of a Drill Down execution in an InfoProvider A in time format.
• InfoProvider B Runtime [hh:mm:ss] (optional) – runtime of a Drill Down execution in an InfoProvider B in time format.
• InfoProvider A Runtime [s] (optional) – runtime of a Drill Down execution in an InfoProvider A in time format.
• InfoProvider B Runtime [s] (optional) – runtime of a Drill Down execution in an InfoProvider B in time format.
• Difference [s] (optional) – difference in seconds between After image runtime and Before image runtime.
• Difference [hh:mm:ss] (optional) – difference in seconds between After image runtime and Before image runtime in time format.
• Result – result of data comparison.
• Reporting Result – reporting status set be Validate/user.
• Before Image Creation Time (optional) – time of before image creation.
• Before Image Creation Data (optional) – date of before image creation.
• After Image Creation Time (optional) – time of after image creation.
• After Image Creation Data (optional) – date of after image creation.
• Before Image Rows (optional) – number of rows of before image.
• After Image Rows (optional) – number of rows of after image.
• Reporting Status Text (optional) – text supplied when Validate/ user set reporting status.
• Variant ID (optional) – Validate technical ID of variant.
• Before Image Status (optional) – Task execution status for the before image
• After Image Status (optional) – Task execution status for the after image
• Before Image Overflow Handled (optional) – notification of overflow occurrence
• After Image Overflow Handled (optional) – notification of overflow occurrence
• Conversion Runtime [s] (optional) – conversion runtime of a Before image in the SLO ListCube/ListCube.
• Conversion Runtime [hh:mm:ss] (optional) – conversion runtime of a Before image in the SLO ListCube/ListCube in time format.

...

This example shows you a step-by-step guide as to how to create, execute and display results in Backend Testing.

1. Run the transaction /DVD/VALIDATE in your SAP BW system

2. In Validate Dashboard screen, choose Backend Testing (last icon on the function panel).

...

8. After you save the query variant, you can view this in the list of all query variants.

_{Set query variables}

9. Once all your query variants are added, save the selection by pressing 'Save' button (Ctrl + S), then you can return to the Test Run ID tasks. In the next step you need to Execute (F8 or double click) Generate tasks for before image, once generated, the first two status icons should be green.

_{Generate Tasks for before image} 

...

_{Generate Tasks for before image} 

10. Once the tasks are generated you can then execute Create before image. A new pop up appears where you can specify the number of background jobs and the name of Application server to be used.

If you want the number of background jobs to stay the same even when one or more jobs fail, you can check the 'Keep alive' option. 

...