20201217 EAH Production Release Notes

From: Parnell, Sarah <saparnell@ucsd.edu>
Sent: Thursday, December 17, 2020 9:09 PM
To: EmployeeAnalytics-COP-l@ucsd.edu
Cc: ITS-BIA <its-bia@ucsd.edu>; ITS-DataIntergrationServices <ITS-DataIntergrationServices@AD.UCSD.EDU>; Beatrice Dormoy <bea@ucsd.edu>; Linardos, Nickolas <nlinardos@UCSD.EDU>; Lorentz, Brian <blorentz@ucsd.edu>
Subject: EAH Enhancements - In Production


Hi all – In support of Zoom free Friday afternoons, we have released the below enhancements on Thursday 12/17.  You’ll find these enhancements in production now.


Thanks for being awesome,

Sarah Parnell

Analytics Community of Practice Manager

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

https://ucsdcollab.atlassian.net/wiki/x/A4C0C

work cell: 858-354-9709

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

 “I take care of step 1 thru 3 so you can get to step 4 faster. What’s your step 1?” - Sarah


From: Parnell, Sarah <saparnell@ucsd.edu>
Sent: Friday, December 11, 2020 4:01 PM
To: EmployeeAnalytics-COP-l@ucsd.edu
Cc: ITS-BIA <its-bia@ucsd.edu>; ITS-DataIntergrationServices <ITS-DataIntergrationServices@AD.UCSD.EDU>; Beatrice Dormoy <bea@ucsd.edu>; Linardos, Nickolas <nlinardos@UCSD.EDU>; Lorentz, Brian <blorentz@ucsd.edu>
Subject: EAH enhancements - UAT available - due December 18

Hello EAH Developers - For the last month we've spent significant time and effort on optimizing our view delivery process.  This allows us to migrate enhancements more efficiently and consistently.  We are excited to below Employee Activity Hub enhancements for you to test between now and end of day December 18.  If you find an issue, please email busintel@ucsd.edu with a subject line "EAH UAT due Dec 18" right away so we can address it prior to December 18.

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

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.

How to perform User Acceptance Testing (UAT):

  • In Cognos DEV open your report and replace the current package with the package of the same name from the Team Content > Employee Activity Hub > EAH Analytics Packages UAT folder.  Run the report and select Hana QA.  Do not select Hana Prod as the report will fail.  Using the new package from the EAH Analytics Packages UAT folder will allow you to see the below enhancement.  EAH data is the same in Hana Prod and Hana QA.
  • Sign into Tableau Prod 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.  Replace the original data source with the –QA data source.  Using the –QA data source will allow you to see the below enhancements.  EAH data is the same in Hana Prod and Hana QA. 

Please use this UAT time to adjust your reports as needed prior to December 18 when your customers will be able to see any issues these enhancements cause. 

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?  Tableau QA or Prod?
  • What data source / package are you using?
  • What results were you expecting?

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

ViewEnhancementEpic
EAH-AbsenceDetail-View
  • Added "Leave Balance PIN Code"
EAHMAINT-1273
EAH-LLDeductionDetail-View
  • Repointed "LL Deducation CCOA Task" from UCPath to FinAH (Oracle)
EAHMAINT-1288
EAH-LLFringeDetail-View
  • Repointed "LL Fringe CCOA Task" from UCPath to FinAH (Oracle)
EAHMAINT-1198
EAH-PositionFunding-View
  • Removed row level security per Data Steward's request
  • Added "Position Funding Derived Effort Percent"
  • Added "Position Funding Derived Percent of Pay"
  • Added additional pay figures
  • Added "Position Funding Project Manager Name"
  • Added "Award Budget Period Start Date"
  • Added "Award Budget Period End Date"

  • Added "Award Start Date"

  • Added "Award End Date"

  • Added "Project Budget Period Start Date"

  • Added "Project Budget Period End Date"

  • Added "Project Start Date"

  • Added "Project End Date"

  • Repointed "Position_Funding_CCOA_TASK" from UCPath to FinAH (Oracle)

EAHMAINT-1192

EAHMAINT-1118

EAH-LLSalaryDetail-View
  • Repointed "LL Salary CCOA Task" from UCPath to FinAH (Oracle)
EAHMAINT-1194
EAH-LLSalaryFringeDetail-View
  • New view combining EAH-LLSalaryDetail-View and EAH-LLFringeDetail-View
EAHMAINT-1178
EAH-LLSummary-View
  • Repointed "LL Summary CCOA Task" from UCPath to FinAH (Oracle)
EAHMAINT-1196

If you cannot view the FINAHCORE links, please request access to Jira here:  https://ucsdservicedesk.service-now.com/its?id=sc_cat_item&sys_id=9af5d148db514450008c9837db96190b