Versions Compared

Version Old Version 4 New Version 5
Changes made by

Saparnell

Saparnell

Saved on

Key

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

Welcome to the Financial Analytics Community of Practice! Both Cognos,Tableau and other tool users are invited. This Community of Practice is a great place to get your questions answered and see real examples of how financial data is used at UCSD.

Monthly meetings: Every 2nd Friday at 9:30am.  Email busintel@ucsd.edu for an invite.

Having issues?  email busintel@ucsd.edu.

Burning questions? Slack the COP at UCSD Analytics #finah_cop

Great enhancement Ideas? User Echo or email busintel@ucsd.edu

Want to keep up on Financial Analytics news?  Join our mail list: https://mailman.ucsd.edu/mailman/listinfo/financial-analytics-cop-l



Ui expand
title2020-08-11 Financial COP


Date, Time, Jira Time Tracking

2020-08-11 at 9:30am for ACOP-171
Recording
FINAH StatusGoing live with Production data in Hana Production / Cognos Production / Tableau Production this weekend for FINAH-UCSDGeneralLedger-View.
FINAH in Hana QADo you all want Oracle Test data in Hana Test or Oracle Production data?
Where to find Oracle Office Hours for reporting support

https://blink.ucsd.edu/finance/fis-project/fin-training.html#Training-Office-Hours-

Look for Oracle BI & Financial Reporting

Oracle In System Reports (OOTB)https://blink.ucsd.edu/finance/fis-project/data-reports/index.html#Oracle-In-System-Reports-(OOTB)



Ui expand
title2020-07-10 Financial COP


Date, Time, Jira Time Tracking

2020-07-10 at 9:30am for ACOP-171
Recordinghttps://ucsdcloud-my.sharepoint.com/:f:/g/personal/jmwhite_ucsd_edu/EmhbuFP_zQREqql4JHV9-58BGtqSSh7dIfFFQ05zomDpSg?e=ZRJpKH
FINAH Status

With the success of the RAH go live and EAH go live, we are disappointed to be behind schedule with FINAH.  After consideration of year end close in IFIS, current stabilization of Oracle and remaining work needed to release the Financial Activity Hub, we estimate that the first wave of Financial Activity Hub will be launched on August 15, 2020.

Our goal is to go live with Wave 1 on August 15th with General Ledger and Advancement (STAR report) data in FINAH and Wave 2 on August 31st with PPM and Budget data.

User acceptance testing (UAT) started on July 9th with a small set of Beta Testers. As part of UAT we are gaining clarity on the needs around Budget data, Account Receivable (AR) and Accounts Payable (AP).  As FINAH development progresses we'll be able to include more users in UAT so that report development can being prior to go live.

Optional Cognos and Tableau training with FINAH data starts July 29 and extends through September 17.  Oracle access with a role of UCSD BI Consumer JR is a per-requsite to signing up for the Cognos / Tableau training.

For more details about FINAH see https://esr.ucsd.edu/projects/activity-hubs/financial/index.html

Beta Testing has started
Where to find Oracle Blink Pagehttps://blink.ucsd.edu/finance/fis-project/index.html
Where to find Oracle Access Blank Page

https://blink.ucsd.edu/finance/fis-project/fin-access.html

On the Oracle & Concur Access Request (Temporary Form) note the following:

  • You can select more than one option for most questions.  You should be able to fill out this form just once and request all roles and departments you need.
  • Use Standard Roles = UCSD BI Consumer JR (w/ 1hr training)
  • Use Elevated roles if you want to build reports in Oracle.
  • The second to last question is where you can indicate departments you need access to that are not your own.
Where to find Oracle Training

https://blink.ucsd.edu/finance/fis-project/fin-training.html#Live-Virtual-Instructor-Led-Cla

Look for Oracle: BI Tools for Report Consumers

Where to find Oracle Office Hours for reporting support

https://blink.ucsd.edu/finance/fis-project/fin-training.html#Training-Office-Hours-

Look for Oracle BI & Financial Reporting

Oracle In System Reports (OOTB)https://blink.ucsd.edu/finance/fis-project/data-reports/index.html#Oracle-In-System-Reports-(OOTB)
Question: where to find an Oracle to FINAH data dictionary?

1) We haven't built that yet.

2) It will be posted to our How to Get AH Data Page for both Report Developers and Data integration developers. Financial Activity Hub FCVs and Fields

FinAH Announcements/wiki/spaces/FinAH/overview



Ui expand
title2020-06-12 Financial COP


Date, Time, Jira Time Tracking

2020-06-12 at 9:30am for ACOP-171
Recordinghttps://ucsdcloud-my.sharepoint.com/:f:/g/personal/jmwhite_ucsd_edu/EvWRKsN9em9Cv2pMMpTohTgBs1-en3p0pT_yI_rf99dr3Q?e=iDuDRn
Where to find Oracle Blink Pagehttps://blink.ucsd.edu/finance/fis-project/index.html
Where to find Oracle Access Blank Page

https://blink.ucsd.edu/finance/fis-project/fin-access.html

On the Oracle & Concur Access Request (Temporary Form) note the following:

  • You can select more than one option for most questions.  You should be able to fill out this form just once and request all roles and departments you need.
  • Use Standard Roles = UCSD BI Consumer JR (w/ 1hr training)
  • Use Elevated roles if you want to build reports in Oracle.
  • The second to last question is where you can indicate departments you need access to that are not your own.
Where to find Oracle Training

https://blink.ucsd.edu/finance/fis-project/fin-training.html#Live-Virtual-Instructor-Led-Cla

Look for Oracle: BI Tools for Report Consumers

Where to find Oracle Office Hours for reporting support

https://blink.ucsd.edu/finance/fis-project/fin-training.html#Training-Office-Hours-

Look for Oracle BI & Financial Reporting

Oracle Roles to FinAH Access


Oracle RolesAccess to FinAH Data?Access to Develop Reports with FinAH?Access to other team's folders?
  • Standard Roles: UCSD BI Consumer JR w/ 1hr training

Automatically get access to FinAH data as a Consumer

Will need to request Report Developer access to

FinAH including Dept/Supervisor approval.

Folder Owner / Report Developer Discretion
  • Elevated Roles: UCSD BI Administrator JR
  • Elevated Roles: UCSD BI Modeler JR
  • Elevated Roles: UCSD BI Author JR
  • with 6 week training

Automatically gets access to FinAH data as a Report Developer

Automatically gets access to FinAH as a Report DeveloperFolder Owner / Report Developer Discretion

More information: AH Security

FinAH Announcements/wiki/spaces/FinAH/overview
reports.ucsd.edu feedback
  • Users as assuming they have access and clicking on report
  • Cognos error message and redirect is confusing
  • Having to fill out the form multiple times to just get DOPE report is confusing.
Next monthFinancial Analytics Community of Practice will be cancelled for July.  We will instead collaborate with the Oracle Reporting Office Hours: https://blink.ucsd.edu/finance/fis-project/fin-training.html#Training-Office-Hours-