APLIKASI PELAPORAN DAN OLAP UNTUK PERPUSTAKAAN DAN KEARSIPAN PROVINSI JAWA TIMUR (Studi Kasus SubBidang Penyusunan dan Program, Badan Perpustakaan dan Kearsipan Provinsi Jawa Timur)

Abstract: Bapersip has eight areas that support business processes. Three areas of the recording process business using Online Transaction Process (OLTP) and Excel. Five other areas recording business processes using excel. Each month, business process data is processed by the areas to be reported. The process of making a report to transfer data from the source OLTP excel and to form reports manually. The data transfer process allows the human error such as redundant data and their data is not recorded in the report, so potentially resulting in inaccurate reports. Reports generated from the OLTP library service areas on Bapersip subfield SUNGRAM not fulfilling the needs for analysis. The solution to Bapersip problem is reporting and OLAP applications. Reporting application will help each area to create a report and eliminates the risk of human error by taking and processing the data from the source. OLAP application used to fulfill the needs of analysis using patterns based on the information you want displayed by SUNGRAM subfields.
Keywords: Reporting, OLAP, Data Mart, ETL, OLTP
Penulis: Yudi Hariyanto, Teguh Sutanto, Romeo
Kode Jurnal: jptinformatikadd160552

Artikel Terkait :