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 March 24
Hello Award Report Developers - Continuing on from our February release, we have completed another step towards turning RAH into a true Activity Hub by moving the underlying tables into our standard Activity Hub design layout and making this new view available in both Tableau and now Cognos. During UAT, review the RAH-AwardDetail-View in Cognos and the added filters in both Cognos and Tableau. If you find an issue, please email busintel@ucsd.edu right away so we can address it prior to the Thursday, March 25 release.
As mentioned in February, these changes come with aggregation strategy changes in Tableau.
Tableau Level of Detail Pilot
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-Award-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:
| Data Source / Package | Cognos | Tableau |
|---|---|---|
| RAH-AwardDetail-View | Available with enhancements | Available with enhancements Tableau LOD included in data source |
| Research Administration - Developer Package - Award - KUALI | Available but NO enhancements | Available but NO enhancements |
| Research Administration - Developer Package - IP- KUALI | Available with February enhancements | Available with February enhancements |
| Research Administration - Developer Package - PD - KUALI | Available with February enhancements | Available with February enhancements |
How to test the new enhancements:
- Cognos: Use the packages in Cognos DEV > Research Administration Activity Hub > Research Administration 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.
...
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
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
From: White, Judy <jmwhite@ucsd.edu>
Sent: Thursday, February 18, 2021 6:41 AM
To: Parnell, Sarah <saparnell@ucsd.edu>; 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>; Joyce, Nicole <njoyce@ucsd.edu>; ITS-DataIntegrationServices <DBA@ucsdcloud.onmicrosoft.com>
Subject: RE: RAH enhancements - UAT available - due February 16
Importance: High
Good morning all,
As many of you may have noticed, we unfortunately were not able to move these updates to production yesterday as planned. Changes in the Award view functionality were identified during the UAT period and we are working hard on a strategy and communication plan for how this update will be rolled out to assure there are no unexpected changes in your Tableau deliverables.
We currently expect to deliver this release to production next week.
As we continue to refine our underlying structures, we move into a state where we are better able to facilitate blending of RAH data with other hubs and the changes made this release cycle are a significant move in that direction. However, as we do that we are taking precautions to assure that your existing content continues to function as expected. To that end, if you have any unreported findings from the UAT period please let us know as soon as possible so that we are sure to address them in our final rollout.
We sincerely apologize for the delay, and look forward to getting this release to production very soon.
Thanks for your patience and support!
Judy White
Director Business Intelligence & Analytics
Information Technology Services
UC San Diego
jmwhite@ucsd.edu
(858)534-8414
(858)257-6725 (cell)
From: Parnell, Sarah
Sent: Thursday, February 11, 2021 9:09 AM
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>; Joyce, Nicole <njoyce@ucsd.edu>; ITS-DataIntegrationServices <DBA@ucsdcloud.onmicrosoft.com>
Subject: RAH enhancements - UAT available - due February 16
Hello RAH Developers - We are excited to release a number of enhancements for you to test between now and end of day February 16. If you find an issue, please email busintel@ucsd.edu right away so we can address it prior to the Thursday release.
How to test the new enhancements:
- Cognos: Use the packages in Cognos DEV > Research Administration > Research Administration 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?
...
View
...
Enhancement
...
Epic
...
Research Administration - Developer Package - Award – KUALI
...
· Added "Award Financial Description"
· Added "KR Clinical Trial Type"
...
...
Research Administration - Developer Package - IP – KUALI
...
· Added "IP Financial Description"
· Added "KR Clinical Trial Type"
...
...
Research Administration - Developer Package - PD – KUALI
...
· Added "PD Financial Description"
· Added "KR Clinical Trial Type"
...
Thanks,
Sarah Parnell
Analytics Community of Practice Manager
...