20220217 - RAH Start UAT Notes

Hello RAH Report Developers - The below enhancements are now available for user acceptance testing (UAT) in Hana QA.  If you find an issue, please email busintel@ucsd.edu prior to end of day Wednesday, February 23 so we can address it before the Thursday, February 24 release.

Keep up with our future enhancements here: RAH Bugs and Enhancements In Progress

Completing the Transition:  Sunsetting

While campus moved from Coeus to Kuali in January of 2020, many users continued to reference data warehouse reports for Coeus data.  With last month's completion of our move of the Kuali data into our standard Activtiy Hub table structure we are ready for the final phase of Coeus, sunsetting the old Coeus reporting structure.

Sunsetting the old Coeus reporting structure will save UCSD money in person-hours and in re-use of the server space.  The old Coeus reporting structure has not been enhanced since February 2020 yet it requires person-hours to monitor and server space to exist.  All of the data in the old Coeus reporting structure can be found in the RAH views and reports using the RAH views will run significantly faster.

ITS will retire of the old Coeus reporting structure during this release.   Here is some guidance on what to replace the Coeus reporting structure with:

  • Single row per Award reports built on Research Administration - Developer Package - Award - KUALI will be repointed to RAH-Award-View.
  • Multi-row per Award reports built on Research Administration - Developer Package - Award - KUALI will be repointed to RAH-AwardDetail-View.
  • Single row per IP reports built on Research Administration - Developer Package - IP - KUALI will be repointed to RAH-IP -View.
  • Multi-row per IP reports built on Research Administration - Developer Package - IP - KUALI will be repointed to RAH-IP Detail-View.
  • Single row per PD reports built on Research Administration - Developer Package - PD - KUALI will be repointed to RAH-PD -View.
  • Multi-row per PD reports built on Research Administration - Developer Package - PD - KUALI will be repointed to RAH-PDDetail-View.

Your Requested Enhancements!

Items marked with an asterisk (*) are report breaking enhancements if you have these fields in your report.

Customer Service Reminder

Data in UAT is not ready to be shared with end customers, is not considered completely validated and can change suddenly.  For optimal customer satisfaction, do not connect your production solutions to packages / data sources that are in UAT.  If you choose to share UAT items with end customer, be explicit that the data and report is in UAT and can change suddenly or be broken by UAT changes.

Follow our Enhancement Testing Steps

Use this UAT time to adjust your reports as needed prior to the Production release where your customers will be able to see any issues these enhancements cause. 
  • Cognos: Use the packages in Cognos DEV > Research Activity Hub > Research Activity Hub Packages UAT to build your report and select Hana QA.  Do not select Hana Prod as the report will fail.  Using Hana QA will allow you to see the below enhancements with Production data. 
  • Tableau: Sign into Tableau on your Tableau desktop tool and open your report.  Add a new data source with the same name and -QA at the end of the title.  Using this data source will allow you to see the current enhancements with Production data.
  • Hana QA:  RAH data in Hana QA is production data loaded daily, just like in Hana PROD.

If you find an issue, please include in your email to busintel@ucsd.edu the following:

  • What browser are you using?
  • What environment are you using?  Cognos DEV, QA or PROD?  Or Tableau?
  • What data source / package are you using?
  • What results were you expecting?