Skladište podataka računovodstvenog sustava

master's thesis

• Title (english): Accounting System Data Warehouse
• Author: Antonija Mandić
• Mentor: Igor Mekterović (mentor)
• Committee member: Igor Mekterović (predsjednik povjerenstva)
• Committee member: Mirta Baranović (član povjerenstva)
• Committee member: Slaven Zakošek (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2016-07-11, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

U ovome radu dan je prikaz izgradnje skladišta podataka za računovodstveni sustav, uključujući i kontroling. Za realizaciju skladišta korištena je Oracle 11gR2 baza podataka u kojoj se nalaze tablice izrađenog dimenzijskog modela. Mapiranja za premještanje podataka iz relacijskog modela u dimenzijski, izgrađena su pomoću Oracle Warehouse Buildera 11gR2, a za izradu izvještaja koristio se Oracle Business Intelligence Enterprise Edition 12c. Na početku je dan opis poslovnih procesa u računovodstvu i kontrolingu, te opis izvora podataka. Zatim slijedi opis tehnologija koje se koriste, a potom prikaz osmišljenog dimenzijskog modela, te je na kraju opisan način na koji se kreiraju izvještaji.

Abstract (english)

This paper provides an overview of building a data warehouse for accounting system and controlling system. Tables of dimensional model used in data warehouse, are stored in Oracle 11gR2. Mappings for transfering data from relational model to dimensional model are designed using Oracle Warehouse Builder 11gR2 and reports are built using Oracle Business Intelligence Enterprise Edition 12c. Business logic of accounting and controlling is described at the beginning and it is followed by the description of the source data. Afterwards is given a display of used technologies, and later the description of the designed dimensional model. At the end of this paper, report creating is described.

• Keywords: skladište podataka; dimenzijski model; poslovna inteligencija; ETL; hijerarhije; izvještajni sustav; računovodstveni sustav; kontroling; Oracle; Oracle Warehouse Builder; OWB; Oracle Business Intelligence Enterprise Edition; OBIEE; SAP
• Keywords (english): data warehouse; dimensional model; business intellingence; ETL; hierarchy; reporting system; accounting system; controlling; Oracle; Oracle Warehouse Builder; OWB; Oracle Business Intelligence Enterprise Edition; OBIEE; SAP
• Language: croatian
• URN:NBN: urn:nbn:hr:168:785368
• Study programme: Title: Computing; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra inženjer/inženjerka računarstva (magistar/magistra inženjer/inženjerka računarstva)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2018-02-06 10:21:05