20210429 - RAH Production Release Notes

From: Parnell, Sarah <saparnell@ucsd.edu>
Sent: Monday, February 1, 2021 4:01 PM
To: RA-BI-Developers <RA-BI-Developers@ucsd.edu>
Cc: ITS-BIA <its-bia@ucsd.edu>; Urrutia, Gonzalo <gonzalo@ucsd.edu>; Donate, Ernesto <edonate@ucsd.edu>; Joyce, Nicole <njoyce@ucsd.edu>; ITS-DataIntegrationServices <DBA@ucsdcloud.onmicrosoft.com>
Subject: RAH enhancements - Complete in Production

Hello all -  The below new view has been moved to production.  The RAH-Award-View is a less detailed version of the RAH-AwardDetail-View, we encourage you use this new view when you do not need additional details like Key Person, IDC or Investigator.

Thanks for being awesome,

Sarah Parnell

From: Parnell, Sarah
To: RA-BI-Developers <RA-BI-Developers@ucsd.edu>
Cc: ITS-BIA <its-bia@ucsd.edu>; Urrutia, Gonzalo <gonzalo@ucsd.edu>; Armenta, Eduardo <earmenta@ucsd.edu>; Kettnich, Cheryl <ckettnich@health.ucsd.edu>; Joyce, Nicole <njoyce@ucsd.edu>; ITS-DataIntergrationServices <ITS-DataIntergrationServices@AD.UCSD.EDU>
Subject: RAH enhancements - UAT available - due April 28

Hello RAH Report Developers - UAT has begun on our latest view, RAH-Award-View.  This view is focused on items that are unique to an Award and is a great place to start your reporting (or repoint your report) if you only need Award level information.  If you find an issue, please email busintel@ucsd.edu prior to end of day April 18 so we can address it before the Thursday, April 29 release.

Tableau Level of Detail Pilot for RAH-AwardDetail-View

Given your feedback, we're trying something new and adding the now required Level of Detail calculations to the Tableau data source directly.  We have added the granularity information to the RAH-AwardDetail-View Quick Start Guide for your reference.  Report developers using RAH-AwardDetail-View will no longer need to create the Level of Detail calculations, they have already been created for you.

Please let us know if the built-in Tableau Level of Detail calculations are beneficial to you.  Based on your UAT results for the measures in the RAH-AwardDetail-View we will look to implement a similar strategy with other Activity Hubs.

In Summary:

How to test the new enhancements:

• 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:  data in Hana QA is production Kuali 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?
• What data source / package are you using?
• What results were you expecting? 

Enhancements included in this release:

Thank you for your ongoing feedback and support.

Thanks,

Sarah Parnell

Analytics Community of Practice Manager

Business Intelligence & Analytics | Information Technology Services | UC San Diego

saparnell@ucsd.edu

work cell: 858-354-9709

My pronouns [https://www.mypronouns.org/]: she/her/hers

 “My job is to make your job easier.  Where do you want to start?” - Sarah