THANK YOU! User Acceptance Testing (UAT) is a critical time for report developers to complete their own testing scenarios against the SAH DEV0 / Canvas Update. BIA relies on the business expertise of the SAH report developers to examine SAH from a business user perspective.

Open For Developer UAT

Hana QA Available for UAT July 26 - August 6, 10:45am-11:59pm Daily

Zoom office hours for how to perform UAT in Cognos and Tableau

• Wednesday, July 24, 12:15-12:45pm PT

  • https://ucsd.zoom.us/j/98896321217?pwd=a8xfxZdwtuQdoc2pbyT0vrqxoh2I6P.1&from=addon

• Thursday, July 25, 12:00-1:00pm PT

  • https://ucsd.zoom.us/j/91293320515?pwd=W8npFwLJ5IyKwTsXsLhfW6aFgbzrmw.1&from=addon

• Monday, July 29, 10:00-11:00am PT

  • https://ucsd.zoom.us/j/92942193013?pwd=Rg2bXrvTj2wIcINE8yCARCbc1uAwsv.1&from=addon

How to perform User Acceptance Testing (UAT)

Goal: Hana QA data matches Hana Prod data

Below are instructions on how to run your report in Hana QA for each BI tool.

Cognos Report Developers

1. In Cognos DEV open your report and run the report select Hana QA.

2. In Cognos DEV open your report and run the report selecting Hana Prod. This can be done in the same or a different browser.

3. Compare the output of the reports. They should be the same.

Tableau Report Developers

1. Open your report in tableau.ucsd.edu to see the Hana Prod data.

2. In the Tableau desktop tool and open your report. 

3. Add a new data source with the same name and -QA at the end of the title.  This will show you the Hana QA data.

4. Replace the original data source with the –QA data source. 

5. Compare the output of the reports. They should be the same.

Data Integration Developers

1. Run your code against Hana QA

2. Compare the output to your Hana Prod results. They should be the same.

What to do if you find a mismatch

1. Check to see if the mismatch is due to the changes made during SAH DEV0 / Canvas Update - Phase 1 Details .

2. Check to see if anyone else has reported the same mismatch: https://ucsdcloud-my.sharepoint.com/:x:/g/personal/jmwhite_ucsd_edu/EZ9kbZnjGAdKrRtOvOdIUdQBaRZKrCM7tz6kqDcw3OJQbA?wdOrigin=TEAMS-MAGLEV.p2p_ns.rwc&wdExp=TEAMS-TREATMENT&wdhostclicktime=1721689422633&web=1

3. Identify if Hana QA or Hana Prod matches ISIS.

   1. If Hana QA is correct then no further action is needed.

   2. If Hana Prod is correct then notify BIA of an issue.

What to do with issues found during UAT

Any issues found during UAT should be sent to busintel@ucsd.edu with the subject line “SAH DEV0 UAT” along with the following details:

• Name and location of the report, or name of the column group

• Name of the View showing the issue

• Sample of results from Hana QA and Hana Prod (screenshot or Excel)

Track your time and effort

We understand that UAT requires time and effort, and we greatly appreciate yours.

For members of ITS or anyone who would like to track their time and effort performing UAT please use ACOP-561 - Getting issue details... STATUS . This will help BIA plan for future SAH Retrofit Phases and allow us to thank your management for your collaboration.