Versions Compared

Key

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

...

From: Parnell, Sarah <saparnell@ucsd.edu>
Sent:
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 October 30


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

  • 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-Account-View
  • Add field: CBO Account Hierarchy L1 Code
  • Add field: CBO Account Hierarchy L1
  • Add field: CBO Account Hierarchy L1 Code and Name
  • Add field: CBO Account Hierarchy L2 Code
  • Add field: CBO Account Hierarchy L2
  • Add field: CBO Account Hierarchy L2 Code and Name
  • Add field: CBO Account Hierarchy L3 Code
  • Add field: CBO Account Hierarchy L3
  • Add field: CBO Account Hierarchy L3 Code and Name
  • Add field: CBO Account Hierarchy L4 Code
  • Add field: CBO Account Hierarchy L4
  • Add field: CBO Account Hierarchy L4 Code and Name
  • Add field: CBO Account Hierarchy L5 Code
  • Add field: CBO Account Hierarchy L5
  • Add field: CBO Account Hierarchy L5 Code and Name
FINAHCORE-528
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

...