You are here
PRISM: Oracle Analytics Cloud (OAC)
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. The tool is primarily used by the CFO’s Office and is focused on PRISM General Ledger data in the Financial Data Warehouse and also provides access to CONCUR expense reporting.
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 data is also loaded on a daily basis.
User access is typically granted at the RC level by Pitt IT ERP Financials in collaboration with the Office of the CFO. Click here for OAC Financial Data Warehouse and Concur dashboard access.
Frequently Asked Questions
What do I do if my OAC account is locked?
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 ERP Financials for resolution.
What is the use of the As is column?
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.
Can I schedule submission and delivery of reports?
Additional roles can be added to allow users to setup agents to automatically run and deliver reports. Information on agents can be found here. Please submit a help ticket to the 24/7 IT Help Desk to request access and training.
What is in the FIN Warehouse Subject Area?
Please click here for information on the facts and dimensions in the FIN Warehouse (FIS_FIN_WH) subject area.
What is in the FIN Employee Warehouse Subject Area?
Please click here for information on the facts and dimensions in the FIN Employee Warehouse (FIS_EMPLOYEE_WH) subject area.