1 / 11

Breaking the Surface!

Breaking the Surface! . UAT Testing Process and Documentation for SAP B usiness Objects. Sara Allen Associate Director Of Analytics July 8 th , 2013. UAT-User Acceptability Testing Process Overview. Data Prep Data validation Joins BO Attributes Changes Critical Dates

early
Download Presentation

Breaking the Surface!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Breaking the Surface! UAT Testing Process and Documentation for SAP Business Objects Sara Allen Associate Director Of Analytics July 8th, 2013

  2. UAT-User Acceptability Testing Process Overview • Data Prep • Data validation • Joins • BO Attributes • Changes • Critical Dates • Report Validation • Misc. Test https://www.mtholyoke.edu/datawarehouse/documents-and-templates

  3. Overall Use of the Document: • Tabs number correlate with the Test Case • Example: 400 correlate with Critical Dates Test Case • Home Page: Date Tested and Sign offs- List the Names of all the testers • Test Cases: • Test ID numbers for each item Example 100-1 • List the Query criteria when applicable • List the expected results • PASS/FAIL • Retest Date • Comments- start with the date- then your comment-your initials. • Example: 7/1/12- Smith was listed instead of Jones-SA

  4. Data Prep –Regroup and really think through what we have. • Circle back to the Data Inventory - do we have what we need? anything we don't? • Naming • Organization (in universe) • Domain validation - do the attribute names describe the values in the data • Data types, Format

  5. Data validation (100) – This test case validates all of the data attributes and ensures that those data elements are displaying the correct values and the correct format, examples; mm/dd/yyyy, $, commas, text vs. numeric. Is everything there that we need?

  6. Joins (200) - This test case validates how the data elements are joined with the tables at the source level. How are the attributes are joined/ fit together and what is the query criteria.

  7. Counts and BO Created Attributes (300) - This test case validates that all the counts are counting accurately and that all attributes created only in BO function as defined in the requirements. Essentially testing the measures created by the Data Architect and validate the query criteria behind them.

  8. Changes (400) - Tests the changes to the source system and how they are reflected in BO. Tests that all "track" data elements defined in the requirements, are actually tracking the history. This test case is testing how new data is introduced, which in essence is tracking the business process. We want to see how the data is populated, refreshed and tracked.

  9. Critical Dates (500) - Testing that all critical dates and/or snapshots function as they should. Testing a point in time.

  10. Report Validation (600) - Reconcile reports run from the core system against reports created and produced in BO. • Misc. Test (700) - Any misc. test scenarios determined to test during UAT

  11. Looking Ahead • What’s Next? Universe will go into Production/Swan. Tidbits of advice to make testing less painful: • Ask for help • Patience is a virtue • Communication is a must THANK YOU! PowerPoint presentation is saved on AMBR under data-warehouse>users-group.

More Related