When using and upgrading a SAP system, an extensive amount of manual testing is required, which consumes time, resources and manpower. The main Main advantages of automated testing are:
...
- Test query outputs on a large scale – Query testing is based on an idea of using a before image and an after image. These images contain results of all the selected queries/bookmarks, which are then stored for later comparison. The after images and before images are then compared to check if both results are the same. The testing of the same queries between two different systems is also supported with the use of RFC functionality.
- Test InfoProviders content – Involves the Execution of ListCubes with specified characteristics selections. All key figures are always returned while settings for the DB aggregation, Read NLS, MAX Rows and Number of Hits can also be applied. Results of ListCube execution are stored as before/after images and are compared for similarity. Testing the same queries between two different systems is also supported with the use of RFC functionality.
- Test of transformations – is Is for the Generation of Data Transfer Processes (DTP) and their execution. From the loaded data, the before and after images are created for comparison. By executing the same load two times, you can verify if these were performed correctly or if there were any changes made in the transformation logic (changes in lookupsLookups, runtimes and otherothers).
- Test table content – Involves the creation of data images for database tables with specified fields. These fields are used either as characteristics or aggregated key figures columns; the images created are stored and compared for similarity. The testing of the same tables between different systems is also supported with use of RFC functionality.
- Test report outputs – Involves the execution of reports with/without variants and the gathering of their outputs that are saved in the spool.
...
The Validate tool is supplied to the customers in the form of a transport requests with all available functionalities included. DataVard’s Reuse Library is also provided together with Validate and is necessary for the customers that did not receive it yet with other DataVard tools.
...
Validate Section | Prerequisites |
General | Windows 7, Windows 8.1, Windows 10 machine SAP BW 7.0 to 7.5 (Recommended 7.01 or higher) |
Dashboard | Internet Explorer 8 or more (9 or more recommended) |
Test Case Document, Status Document | MS Word (Office 2007 – Office 2016) |
Test Plan Report | MS Word (Office 2007 – Office 2016) |
Web Template Test Case | Internet Explorer 8 or more with:
MS Excel (Office 2007 – Office 2016, 32-64 bit) Web Templates newer than 3.5 version |
Web Intelligence Test Case | Internet Explorer 8 or more with:
MS Excel (Office 2007 – Office 2016, 32-64 bit) SAP BusinessObjects BI Platform 4.1 Support Pack 6 |
ListCube and DrillDown Test Case | For NLS data testing, SAP 7.3 or more needed |
DTP Test Case | Transformation with source: InfoCube, DataSource and DSO are supported Transformation with target: InfoCube, DSO and WODS are supported |
Frontend Testing | Scripting enabled on server for ‘sapgui/user_scripting’ parameter Activated scripting for SAP GUI without notifications Disabled SAP GUI security settings on test execution machine |
BEx Analyzer Testing | MS Excel (Office 2010 – Office 2016, 32 bit) BI AddOn 7.X (based on 7.40) BI AddOn 7.X (based on 7.50) Excel add-in BExAnalyzer.xla added to Excel Add-ins |
Note |
---|
Validate contains tables that are client dependent. Therefore it is required that the Validate transport is imported into the system using the same client where the users will be working with the tool. |
Validate Terminology
In this section, basic terminology used in Validate tool is described for better understanding of following chapters.
...
- Variants: InfoProvider ZDC_CUBE1, InfoProvider ZDC_DSO1
Test Plan – specifies the combination of a Test Cases that can be executed. Test Cases (with variant/variants) assigned to a Test Plan have their execution statusstatuses.
Initial Validate Setup
Validate supports several Test Case types, not all of which may be relevant for you. Therefore, the customization transaction /DVD/VALIDATE_SETUP provides options to only display the Test Cases that are relevant.
...