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.

OAC Data

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.

User Access

User access is typically granted at the RC level by Pitt IT Business Solutions in collaboration with the Office of the CFO. Click here for OAC Financial Data Warehouse and Concur dashboard access. Click here for HR Analytics dashboard access.

FAQ


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.

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.

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.