Oracle Analytics Cloud
Oracle Analytics Cloud (OAC) is a comprehensive enterprise analytics environment used for analysis and reporting of data. It offers dashboards, ad hoc querying, and scheduled distribution of the University's financial information in a secure cloud-based environment. While primarily focused on PRISM General Ledger data in the Financial Data Warehouse, it also currently provides access to a variety of other data marts including CONCUR expense reporting and Human Resources employee roster data with significant potential to expand data sources.
OAC provides both a curated data model with subject areas for building "single source of truth" analyses as well as self-service analytics capabilities for users to ingest, cleanse, and combine their own data for rapid data discovery.
Posted General Ledger data is loaded into the Financial Data Warehouse on a daily basis. Please keep in mind that the close of the month occurs on the third business day of the following month and the monthly payrolls are costed just prior to close. Concur and HR Roster data are also loaded on a daily basis.
Typically an account is locked when a user attempts to enter a username and password in the login window rather than selecting the "pittpassport" link for authentication. Please submit a help ticket to the 24/7 IT Help Desk and ask that it be assigned to Business Solutions for resolution.
The As is columns allow for reporting on the current value of those columns as compared to the historical values. Please click here for more information.
Please click here for information on the facts and dimensions in the FIN Warehouse (FIS_FIN_WH) subject area.
Please click here for information on the facts and dimensions in the FIN Employee Warehouse (FIS_EMPLOYEE_WH) subject area.