Return to search

Verslo valdymo sistemos Navision Attain ir OLAP priemonių integravimas / Enterprise resource planning software Navision Attain data analysis using OLAP tools

This work investigates the problem of company not able to handle it’s data analysis using Navision Attain tools alone. A more powerful system is needed, and Microsoft SQL Server OLAP tools are selected as such. The work carried out covers data extraction, transformation and loading (ETL) for analyzing Navision Attain data using OLAP data analysis tools. Different integration architectures, as well as needed transformations and most often encountered problems are covered, together with possible solutions to them.. After completing business process analysis, and identifying user roles and required data, four different data cube were created on data from Navision Attain. Namely cubes for sales analysis, purchase analysis, item inventory tracking and customer debt analysis. In addition, an example schedules for cube updating are created, and wider usage guidelines are provided. The complete system is then optimised to provide efficient performance and low main system load. The optimisation results are compiled into generic suggestions for further analysis system development.

Identiferoai:union.ndltd.org:LABT_ETD/oai:elaba.lt:LT-eLABa-0001:E.02~2006~D_20060114_121412-78673
Date14 January 2006
CreatorsKepežinskas, Algirdas
ContributorsKiauleikis, Valentinas, Stulpinas, Raimundas, Butleris, Rimantas, Maciulevičius, Stasys, Nemuraitė, Lina, Gudas, Saulius, Butkienė, Rita, Lopata, Audrius, Bareiša, Eduardas, Kaunas University of Technology
PublisherLithuanian Academic Libraries Network (LABT), Kaunas University of Technology
Source SetsLithuanian ETD submission system
LanguageLithuanian
Detected LanguageEnglish
TypeMaster thesis
Formatapplication/pdf
Sourcehttp://vddb.library.lt/obj/LT-eLABa-0001:E.02~2006~D_20060114_121412-78673
RightsUnrestricted

Page generated in 0.0019 seconds