fms users group 200907.ppt
TRANSCRIPT
![Page 1: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/1.jpg)
Finance Reporting Oracle B siness Intelligence EnterpriseOracle Business Intelligence Enterprise
Edition (OBIEE) Training
Corazon WongJuly 2009
![Page 2: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/2.jpg)
Topics to be Covered
Data Warehouse OverviewOBIEE Answers and DashboardsBusiness Intelligence (BI) andBusiness Intelligence (BI) and
PeopleSoft (PS) Finance (FMS) SecuritySecurityDashboardsL di PLanding PageReports and PromptsAvailable Balance CalculationAvailable Balance Calculation
Demo of the General Fund dashboard
![Page 3: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/3.jpg)
Data Warehouse Overview
• A data warehouse is a relational database that is designed for query and analysis rather than transaction processing.
• A data warehouse usually contains historical data that is derived from transaction datatransaction data.
• It separates analysis workload from transaction workloadtransaction workload.
• Enables a business to consolidate data from several sourcesfrom several sources.
![Page 4: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/4.jpg)
Data Warehouse
PS Finance - SLCPS Finance SLC
End-UsersNightly updates
SF St t Fi
End Users
SF State Finance Reporting Data Warehouse
![Page 5: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/5.jpg)
Access Requirements…
• SF State ID – University identification number (aka employee ID, UIN, etc)
• SF State Password – used to be known as PAC (Personal Access Code)
• Completed ESIP (Employee/Student I f ti P i ) T i iInformation Privacy) Training
• FMS Account with permissions for either Department or Project reportsDepartment or Project reports
![Page 6: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/6.jpg)
Security
LDAP Authentication –◦ SF State ID and Password
Data Authorization –◦ Using FMS data security on Business Unit,
Departmental Level and Project/sDepartmental Level and Project/s◦ Grants Attribute Module – PI set up and PIA◦ OBIEE Presentation Server Permissions -OBIEE Presentation Server Permissions
Control access to Web Catalogs, Folders, Dashboards, etc…
![Page 7: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/7.jpg)
OBIEE Answers and Dashboards
• Oracle Answers Report building interface provided by Oracle– Report building interface provided by Oracle Business Intelligence Enterprise Edition (OBIEE)
– Used for the construction of both Queries (the data) and Reports (the presentation)
Dashboards• Dashboards – Visual display of the most important
information, consolidated and arranged on ainformation, consolidated and arranged on a single screen
– Repository for reports and other links– Contain data summarized at a high level with
the ability to “drill down” to levels of detail
![Page 8: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/8.jpg)
Dashboard – based on Fund Types
General Fund – NG001
Trust Funds – Trust Fund and Revenue Fund Codes (Other Fees, CEL, Housing, etc)
Grants and Contracts – ORSP Projects
Capital Outlay – BH###
![Page 9: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/9.jpg)
Dashboard – Reports within a Dashboard
Department / Project Overview –Fi i l S R t i l t tFinancial Summary Report – equivalent to
Revenue / Expenditure Summary Report (SFOGL104)(SFOGL104)
GL Detail Activity -> GL Detail Report (SFOGL100)(SFOGL100)
Open Commitment Report (SFOGL109)
![Page 10: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/10.jpg)
Dashboard – Prompts/Criteria
1st Level Criteria : Business Unit, Fiscal Year, A ti P i d PS Ch t Fi ld h F dAccounting Period, PS Chart Field such as Fund, Dept, etc..2nd Level : Additional filter is built for Account Type ypand PS Chart Field
![Page 11: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/11.jpg)
Dashboard – Landing Page
• Department Security – General Fund
Project Sec rit Grants & Contracts• Project Security – Grants & Contracts
![Page 12: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/12.jpg)
Reports – Available Balance CalculationCalculation
• General Fund= Revised Budget – sum(Year-to-date Actuals +
Open POs + Open REQs)• Positive Balance > there’s money left• Positive Balance -> there s money left• Negative Balance -> deficit
• Grants & Contracts = Revised Budget – sum(Project-to-date
Actuals + Open POs + Open REQs)Actuals + Open POs + Open REQs)• Positive Balance -> there’s money left• Negative Balance -> deficit
![Page 13: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/13.jpg)
Reports – Available Balance Calculation (cont’d)Calculation (cont d)
• Capital Outlay= Revised Budget – sum(Project-to-date
Actuals + Open POs + Open REQs)• Positive Balance > there’s money left• Positive Balance -> there s money left• Negative Balance -> deficit
• Trust and Revenue Funds= Beginning Balance + Year-to-Date Actuals
(Revenue + Expenses) + Open POs + Open(Revenue + Expenses) + Open POs + Open REQs)
• Negative Balance -> there’s money left• Positive Balance -> deficit
![Page 14: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/14.jpg)
Graphics
• Department / Project Financial Status – Expenditures within/less than budgeted or
revenue collections; there’s money left
• Department / Project Financial Status expenditures greater than budgeted or revenue collections; in deficitrevenue collections; in deficit
![Page 15: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/15.jpg)
Acronyms
• MTD – Month-to-Date. Current Month’s Activity for the accounting period specified in the criteria
• YTD – Year-to-Date activities in Accounting Period between 1 – 12PTD P j t t D t (P i d 0 YTD• PTD – Project-to-Date (Period 0 + YTD activities)FY Fiscal Year• FY – Fiscal Year
![Page 16: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/16.jpg)
Vocabulary/Acronyms – For more informationinformation …..visit the following Fiscal Affairs web page:
http://fiscaff sfsu edu/services/fms/training/http://fiscaff.sfsu.edu/services/fms/training/tutorials/tutorials_big.jsp
![Page 17: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/17.jpg)
Tips on Navigation
• When can you drill down?:A l ll i bl– Any row or column cells in blue
When can we sort the report?:• When can we sort the report?:– Go to the column header and click; when the
symbol “^” appears, the selected column cansymbol appears, the selected column can be sorted in ascending or descending order
![Page 18: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/18.jpg)
Tips on Navigation …. con’t
• How to download to Excel, PowerPoint, etc.– Locate at the bottom
f h hof the report the“Download” link and clickclick
- select the desireddownload optiondownload option
![Page 19: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/19.jpg)
Tips on Navigation …. con’t
• How to go back to previous screen– Locate a “return” link
at the bottom of the report and click
- If you don’t see the“return” link then usereturn link, then usethe internet browser “back arrow”back arrow key
![Page 20: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/20.jpg)
Tips on Navigation …. con’t
• How to run and generate a report with new criteria– Update the criteria fields
Cli k “ ” h i i i l l– Click “go” at the appropriate criteria level
![Page 21: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/21.jpg)
Demo - Test environment
https://bitest.sfsu.edu/analytics/saw.dll?Dashboard– General Fund / Trust / Grants & Contracts– Other Reports
• Payroll by Employee• Payroll by Employee• Travel by Employee
– Download to• Excel• Powerpoint• Excel 2000Excel 2000• Data• Web Page
![Page 22: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/22.jpg)
Summary/Benefits
• Ease of Use• Performance• Report criteria defaults• Drill-down to details• Download to Excel, PowerPoint, data, and , , ,
web page• Security maintained at object and data y j
level
![Page 23: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/23.jpg)
What’s next :
• Review Phase II Requirements – Requisition, PO and Voucher Drilldown– Search by Journal ID, Voucher No, Req and
PO number/sPO number/s– Ad-hoc reporting using Answers – BI Publisher and SchedulerBI Publisher and Scheduler
Y f db k iYour feedback is very important !
![Page 24: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/24.jpg)
Contact / Help Desk :
• LDAP ID x 5-4357 (5-Help)• Access x 8-7143
– Data– Report– Fund
• Feedback x 8-7143
![Page 25: fms users group 200907.ppt](https://reader030.vdocuments.us/reader030/viewer/2022012804/61bd304761276e740b10360f/html5/thumbnails/25.jpg)
Any questions?