20211117 - RAH Start UAT Release Notes

Owned by Saparnell
Last updated: Nov 17, 2021
4 min read

Hello RAH Report Developers - UAT has begun a day early so that we can migrated these enhancements to production prior to the Thanksgiving holiday. If you find an issue, please email busintel@ucsd.edu prior to end of day Tuesday, November 23 so we can address it before the Wednesday, November 24 release.

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

Holiday Season

Given the upcoming holiday season, this will be the last RAH release for 2021.  We'll see you again in January 2022!

Completing the Transition:  Sunsetting & Celebrating

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 is targeting February 2022 for the retirement of the old Coeus reporting structure.  This will provide report developers time to repoint their reports at the appropriate RAH view.  BIA will be reaching out to affected report developers directly to ensure they are award of the retirement date and how to repoint their reports.

  • 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.

Celebrating

All are invited to the Research Activity Hub (RAH) Virtual Happy Hour on Friday, November 19, 2021 at 2:30pm PT.  Zoom meeting https://ucsd.zoom.us/j/98467567448?pwd=MFJiUUZ6T2h3MnVOYURQZnR4K0lKZz09.

Join us as we celebrate the addition of Subaward data to the Research Activity Hub and the completion of moving the Kuali data into our standard Activity Hub structure.  BYOB and be ready to share your face (live or via a photo) – it’s been too long since we’ve seen you!

Big THANK YOU to OCGA for providing guidance and UAT testing during these projects!!

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 below 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?