202311 RAH Release Notes

Owned by Saparnell
Nov 16, 2023
3 min read

Hello RAH Report Developers - The below enhancements are included in this month's RAH Release.

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

Learn more about the Research Activity Hub in the RAH Quick Start Guides.


Schedule

  • Thursday, November 16, end of day: release enhancements to User Acceptance Testing

  • Extra UAT time due to Thanksgiving Holiday

  • Thursday, November 30, end of day: release enhancement to Production

  • Friday, December 1, end of day: delete QA models

Reminder

Due to the winter break there will be no RAH monthly release in December.  The next RAH monthly release will be January 2024.


Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests.

  • Ernesto Donate
  • Cheryl Kettnich


New View: RAH-PDProposalPersonDetail-View

BIA and OCGA are excited to release the RAH-PDProposalPersonDetail-View.  This new view has more details than the RAH-PD-View but less details than the RAH-PDDetail-View.  Per report developer request, this view will allow reports to run faster as removing questionnaire data creates a smaller data set.  Per our standard release process this view will remain in UAT until our next standard release in January 2024.

Epic:   RAHE-921 - Getting issue details... STATUS

Enhancements will address the following SNOW tickets: CS1745029 and CS1755478

Fields included in this view:  Same fields as RAH-PDDetail-View less the Proposal Questionnaire fields.


Your Requested Enhancements!

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

RAH-PD-View and RAH-PDDetail-View

Epic:   RAHE-923 - Getting issue details... STATUS

Enhancements will address the following SNOW tickets: CS1745029 and CS1755478

Added the following fields:

  • PD Budget Comments Current
  • PD Budget Cost Sharing Amount Current
  • PD Budget End Date Current
  • PD Budget Final Version Flag Current
  • PD Budget Modular Budget Flag Current
  • PD Budget Name Current
  • PD Budget On Off Campus Code Current
  • PD Budget Residual Funds Current
  • PD Budget Start Date Current
  • PD Budget Submit Cost Sharing Flag Current
  • PD Budget Total Cost Current
  • PD Budget Total Cost Limit Current
  • PD Budget Total Direct Cost Current
  • PD Budget Total Direct Cost Limit Current
  • PD Budget Total Indirect Cost Current
  • PD Budget Under Recovery Amount Current
  • PD Budget Update Timestamp Current
  • PD Budget Updated By Email Current
  • PD Budget Updated By Employee ID Current
  • PD Budget Updated By Identity AD Username Current
  • PD Budget Updated By Name - First Current
  • PD Budget Updated By Name - Full Current
  • PD Budget Updated By Name - Last Current
  • PD Budget Updated By Name - Middle Current
  • PD Budget Version Number Current


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

A duty cycle has been implemented for Hana QA.  During this time, Hana QA will not be available.  Please schedule your UAT work around this duty cycle.

  • Hana QA will not be available from 7pm-5am nightly
  • Hana QA will not be available Saturday and Sunday
  • Data loads will occur from 5am-10am on weekdays

Follow our Enhancement User Acceptance Testing (UAT) 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 > Student Activity Hub > Student 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:  SAH 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? 

Reminder: QA data sources will be deleted the Friday after the enhancements are migrated to Production.