2024 Financial Analytics CoP Meetings
Monthly meetings: Every 2nd Friday of the Month at 10:00am. Email busintel@ucsd.edu for an invite.
Want to watch a recorded session? OneDrive > Financial Analytics CoP
Jira Timetracking for those who do: - ACOP-420Getting issue details... STATUS
2024-11-08 Financial Analytics CoP
Topic | Notes |
---|---|
Reminder | All sessions are recorded. See link at the top of the page. |
FINAH November UAT has started | 202411 FINAH Release Notes |
FM Coach 2.0 AI project | Looking for analysts interested in providing feedback on how to answer fund manager questions.
Contact Darcy Frailey (dfrailey@ucsd.edu) to be added to the Teams chat and get access to the spreadsheet. Fund Manager Coach 1.0 = https://blink.ucsd.edu/technology/ai/tritongpt/fm-coach.html TritonGPT = https://blink.ucsd.edu/technology/ai/tritongpt/index.html |
2024-10-11 Financial Analytics CoP
Topic | Notes |
---|---|
Reminder | All sessions are recorded. See link at the top of the page. |
FINAH October | 202410 FINAH Release Notes |
EAH October | 202410 EAH Release Notes |
Concatenation in BI tool | If you are concatenating fields in your report it will impact your run time by increasing the run time. This can be very obvious in Cognos prompt pages. Recommendation: request that the concatenated field be added to the Activity Hub. Email busintel@ucsd.edu with
|
Enhancement Requests for existing data source (Oracle, UCPath, Kuali, EPBCS, Tririga, ISIS, etc.) |
|
Open Q&A |
2024-09-13 Financial Analytics CoP
Topic | Notes |
---|---|
Reminder | All sessions are recorded. See link at the top of the page. |
FINAH September | 202409 FINAH Release Notes |
FINAH Definitions | Activity Hub Field List |
Open Q&A |
2024-08-09 Financial Analytics CoP
Topic | Notes |
---|---|
Reminder | All sessions are recorded. See link at the top of the page. |
FINAH August | 202408 FINAH Release Notes |
Campus BFS | https://blink.ucsd.edu/finance/resources-training/training/camp-bfs/index.html |
2024-07-12 Financial Analytics CoP
Topic | Notes |
---|---|
Reminder | All sessions are recorded. See link at the top of the page. |
FINAH July | 202407 FINAH Release Notes |
EAH + FINAH + RAH + FACAH | If you are using the same blend in multiple reports then let BIA know. Email busintel@ucsd.edu. Why people blend: 1) Where is everyone's payroll coming from? 2) Who (people, departments, project) is in what lab? Challenge: How do I set up my folder/data module/ report to grant the correct access? Email busintel@ucsd.edu. Short Answer: Your data module and reports need to both be in a folder structure that the customer AD group has consumer access to. BIA can help you get organized. |
Why people don't open a ticket | 1) ITS is too busy = yes, we are busy BUT we do want to make your life easier so we want to add it and we will find a time to add it 2) It's only for our team = maybe, BIA hears about projects across multiple teams so once we know multiple teams need it we can bump up the priority (and help introduce the teams) 3) ITS can't add it to AH by the time I need it = let us try, even if we can't add it for this year we can add it for next year or other use cases 4) ITS is too busy = we may already be working on what you want, let us keep you up to date 5) ITS is too busy = ITS work is prioritized by data stewards, who represent what data departments need. If they don't know what data you need then they can't prioritize it. |
When will AR from Oracle be available in FINAH? | Data from SIS in beta testing with the AR team. Data from Oracle is in the queue but may need to wait until after the ESR TSS project. Daniel: Customers are using the AR Panorama but would like a more interactive dashboard. |
FINAH Roadmap | FSPT - Student Financial Data / SIS Accounts Receivable (in progress, data in beta testing, governance in discussion) Accounts Receivable from Oracle (high in queue, after ESR TSS due to limited resources) Fixed Assets from Oracle (low in queue) |
How to get data out of Oracle |
|
Will changing the name of a VC-Area from “Resource Management and Planning” to “Operations Management and Capital Programs” affect already developed reports? | Only if the report is filtered specifically for “Resource Management and Planning” |
2024-06-14 Financial Analytics CoP
Topic | Notes |
---|---|
Reminder | All sessions are recorded. See link at the top of the page. |
June & July | Releases will be small as BIA as we retrofitting underlying tables. |
Requesting access as a consumer | bah.ucsd.edu > Request Access Reports that are not on BAH, if you send us the link to the report we can refer you to the Report Developer Team |
Requesting access as a developer | Blink > Data Sources (https://blink.ucsd.edu/technology/bi/sources/index.html) |
VCHS | RSCore website (https://rscore.ucsd.edu/#/main/home) - customers can request access for their role Health Service employees can request access here: https://ucsdhealth.service-now.com/hub?id=arc_sc_item&sys_id=8e4c782d87d225100548ca68cebb3568 Non-Health Service employees can email: rschelp@health.ucsd.edu |
Active Directory | AD Tool: allows you to create groups for security purposes and/or mail list purposes or other How does AD group membership get managed?
|
AD Group Names | https://blink.ucsd.edu/technology/bi/access/index.html
*This is separate from the AH Report Developer Access |
2024-05-10 Financial Analytics CoP
Topic | Notes |
---|---|
Reminder | All sessions are recorded. See link at the top of the page. |
May & June | Releases will be small as BIA as we retrofitting underlying tables. |
Interest in Cognos/Tableau training using FINAH? | Yes. People interested in this meeting will be notified first, the FINAH mail list will be advertised to 2nd. |
Can a burn down report be created in Cognos? | Yes. See recording for details. Create future years in a separate query. Create separate queries for each category and then union. Create crosstab and then use 'Section' feature from icon menu to pull year out separately. |
2024-04-12 Financial Analytics CoP
Topic | Notes |
---|---|
Reminder | All sessions are recorded. See link at the top of the page. |
April Release going to Prod on Monday 4/15 | 202404 FINAH Release Notes |
Enhancement Requests | BIA Services Form = https://support.ucsd.edu/its?id=sc_cat_item_guide&sys_id=e333d2481b67e9d4484f968f034bcbf5 Or email for now = busintel@ucsd.edu |
Blending data with FINAH | Adding New Data for Blending in Cognos or Tableau Even if you use the Interim solution or Short term solution you should also request that your data source be added to the Activity Hubs. |
Enhancements - how it is decided which AH the data goes into? |
Note: Student data will need to be prioritized against the SIS freeze for the next couple years. The Data Steward can adjust the priorities as needed. There is a SIS freeze exception form. 2. What resources do the Data Integration team and BIA have available. 3. It can go into multiple Activity Hubs in the end. |
SIS Freeze | Everything (data integration and reporting and applications) needs to move off the current SIS and current DW. All SAH requests are evaluated to determine if the data is from SIS and the SIS data is given priority. |
Is this possible? | Would people be interested in a Flag for Most Recent Closed Fiscal Accounting Period / Most Recent Open Fiscal Accounting Period? Yes! We love to add flags that people are going to use in several reports. Please email us the logic that you are using. |
Can you mass schedule a Cognos report? | Mass schedule: Want to send to send to 100 + people but don't want to schedule each and don't want to make a copy of the report that has to be maintained when the original report gets updated. The original report will need to be burst capable and allow default values to be set in the prompts. |
2024-03-08 Financial Analytics CoP
Topic | Notes |
---|---|
Reminder | All sessions are recorded. See link at the top of the page. |
March Release | 202403 FINAH Release Notes |
2024-02-09 Financial Analytics CoP
Topic | Notes |
---|---|
Reminder | All sessions are recorded. See link at the top of the page. |
3 Fund Options | Fund = Fund Code listed on the General Ledger Accounting lines. Derived Fund = The fund that is associated with the project-task based on award setup for sponsored projects or project setup for non-sponsored projects. For Sponsored Projects: (1) "Expenditure Funding Source Code" is internal / 5-digits, then use the "Expenditure Funding Source Code". (2) If "Expenditure Funding Source Code" is not internal / 5-digits then used the match on the Award Type to find the Fund Code. (3) If "Expenditure Funding Source Code" is not internal / 5-digits and "Award Type" = Special State Appropriations, then match on the "Award Sponsor REMS Code" to find the Fund Code. Derived UC Path Fund = The Fund that should be used in UC Path chart strings based on the project/task/award accounting rules. Note, the Derived UC Path Fund and Derived Fund and Fund can differ. Use Case: Capped Funds Use Case: See all the projects associated with a Fund use with Derived Fund. Use Case: See all the transactions that posed to a Fun use the Fund. |
Quick intro of people on the call | See recording for amazing Friday faces |
Go over Quick Start Guides | |
Recommendations for new folks |
|
2024-01-12 Financial Analytics CoP
Topic | Notes |
---|---|
Reminder | All sessions are recorded. See link at the top of the page |
Financial ACoP | Monthly Meeting - Office hours / Q&A session / demo time Maillist Teams Chat Resources |
Resources | What is the FINAH? High Level: https://blink.ucsd.edu/technology/bi/sources/financial-activity-hub/index.html Financial ACOP Meetings: 2024 Financial Analytics CoP Meetings FINAH Quick Start Guides: FINAH Quick Start Guide Activity Hub Field List: https://tableau.ucsd.edu/#/views/ActivityHubFieldList/ActivityHubFieldNames?:iid=1 Protection Levels: https://security.ucop.edu/policies/institutional-information-and-it-resource-classification.html BAH > Budget & Finance: https://bah.ucsd.edu/financial/index.html# Council of Data Stewards: https://blink.ucsd.edu/technology/bi/governance/council.html FINAH Report Developer Training: FINAH Report Developer Training AH Data Load Report: https://tableau.ucsd.edu/#/views/AH-DataLoadStatusReport/Status?:iid=2 System Status: https://status.ucsd.edu/ |
What do you want to see or learn from Financial ACoP in 2024? | What's going on with FINAH? What challenges do Financial Analysts face? What are people reporting on? Recharge Units - what are you guys doing? Different central offices. Tehseen |
Next Time | Go over Quick Start Guides Quick intro of people on the call |