State Accounting Fiscal Essentials SAFE Manual Section 9: Reporting Topics: OAKS-BI, OAKS-FIN Effective Date: July 1, 2014 Latest Revision: N/A Previous Revisions: N/A Applicable or Related Code Sections: N/A Related Links: MyOhio: https://myohio.oaks.ohio.gov/psp/PAPRD/EMPLOYEE/EMPL/h/?tab=PAPP_GUEST OAKS BI: https://myohio.oaks.ohio.gov/psp/PAPRD/EMPLOYEE/EMPL/h/?tab=OH_BI_HOME OAKS Financials Manual: http://fin.help4u.obm.ohio.gov/ OAKS-BI Reporting OAKS has a business intelligence (BI) environment or data warehouse, running on PeopleSoft EPM (enterprise performance management) with IBM Cognos as a reporting tool. BI is used by OAKS users for producing payroll and financial reports and retrieving read-only data for analysis. This data warehouse environment is created by formatting and extracting detailed financial data from hundreds of FIN and HCM production tables and loading them on a nightly basis with a series of batch jobs into a nonreal-time data warehouse. The majority of these nightly updates are incremental; however, depending on the requirements specified on the table, a full synchronization of the table may be performed daily. In addition, a near full synchronization of the data warehouse with production is performed weekly for financial data and bi-weekly for payroll data. History is maintained for data in EPM. Because the EPM tables are separated from production, one of the advantages of the EPM is the significant reduction in the time it takes to submit transactions or run reports. Only necessary transaction information is copied to the EPM; standing data that does not change often is not copied to the data warehouse. In addition to the OAKS EPM, the OAKS data warehouse environment also includes the HR legacy data warehouse and the financial legacy data warehouse (CAS Data Mart). An automated process is in place to perform a comparison of HCM, FIN and EPM data on a nightly basis as data was uploaded to EPM from FIN and HCM databases. This information is written to tables and a daily Cognos report is generated detailing any discrepancies that were noted. These Cognos reports are reviewed as needed by the EPM team and/or the FIN and HCM teams at the weekly FIN and HCM production meetings. Any discrepancies are researched and appropriate actions taken if possible given existing system limitations. Error reports are also generated during nightly processing if any errors occur during updating. When incidents with possible user impacts occur an Alert is posted on myOhio.gov. If the error is generated for a critical table, the error receives priority and is fixed right away. If the error is generated for a table that is not frequently used, the error will be corrected and updated in the next batch window. Nearly 200 Standard Reports are available to BI Users and listed on the OAKS-BI home page. Office of Budget and Management | 30 East Broad Street, 34th Floor | Columbus, Ohio 43215-3457 www.obm.ohio.gov | (614) 466-4034 | (614) 466-5400 SAFE Manual – Section 9 - Reporting Page 2 Standard Report List There is a standard report list for each data mart. The report list summarizes all of the standard reports by name and provides a brief description of their functionality. Report Books There is a report book associated with each standard report. Report books provide: • A screen shot of a report output; • Features of the report; including hard coded filters, subject areas, and other features; and • A screen shot of the prompt page, a prompt descriptions and examples of acceptable prompt inputs. For more information, training opportunities and material, and FAQs visit MyOhio OAKS Business Intelligence home page through MyOhio. OAKS-FIN Reporting OAKS FIN Reporting Tools offer a range of queries and reports. Visit the OAKS Financials Manual for an inventory of reports and queries available in OAKS FIN.