Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

From: Parnell, Sarah <saparnell@ucsd.edu>
Sent: Monday, September 14, 2020 3:58 PM
To: Financial-Analytics-COP-l (Financial-Analytics-COP-l@ucsd.edu) <Financial-Analytics-COP-l@ucsd.edu>
Cc: ITS-BIA <its-bia@ucsd.edu>; ITS-DataIntergrationServices <ITS-DataIntergrationServices@AD.UCSD.EDU>; Kilburn, Erin <ekilburn@ucsd.edu>; Kim, Elliot <etkim@ucsd.edu>; Blankenship, Laura <lsblankenship@ucsd.edu>
Subject: FINAH enhancements - UAT available - due Sept 21st


Hello Financial Activity Hub Developers - We are excited to release new views for you to test between now and end of day September 21.  If you find an issue, please email busintel@ucsd.edu right away with the subject line “FINAH UAT due Sept 21st so we can address it prior to September 21.

  • Cognos: Use the packages in Cognos DEV > Financial Activity Hub > FINAH Data Sources – 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. 
  • Tableau: Sign into Tableau QA 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. 
  • Hana QA:  FINAH data in Hana Prod is production Oracle data and Hana QA contains Oracle test data.

...

  • 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?  What departments were you approved for via the new FINAH row level security?
ViewEnhancementEpic
EAH-LLFringeDetail-View
  • Add "LL Fringe Earnings Period Start Date”  
  • Add "LL Fringe Earnings Period End Date"
EAHMAINT-1060
EAH-UCRole-View
  • Add Employee Name
  • Add HR Status
  • Add Employee Status
  • Add Transact for Dept.IDs
  • Add Access level
  • Add Employee Class
  • Add Email ID
  • Add Reports to Position Number
  • Add Dept ID
  • Add Dept Name
  • Add VC Name
  • Add Job AsOf Indicator
  • Add User Authorized Department
  • Add User Authorized Department Code
EAHMAINT-721

UAT completed when we published the General Ledger so these were moved directly into production.

ViewEnhancementEpic
FINAH-Account-ViewNew ViewFINAHCORE-186
FINAH-Entity-ViewNew ViewFINAHCORE-188
FINAH-FoundationInvestmentPool-ViewNew ViewFINAHCORE-195