ePrints.FRI - University of Ljubljana, Faculty of Computer and Information Science

Performance module for BI4Dynamics platform

Nino Ostrc (2015) Performance module for BI4Dynamics platform. EngD thesis.

Download (1258Kb)


    BI4Dynamics is an analytical Business Intelligence (BI) solution for Microsoft Dynamics ERPs. The solution deploys a data warehouse on a Microsoft SQL server and creates an analytical database on a Microsoft Analysis server; accordingly, due to SQL’s flexibility, it offers an excellent platform for developing custom BI modules; OLAP cubes and dimensions. This paper describes how the BI4Profiler, which is a performace module for BI4Dynamics platform, was developed. In this process my task was to design the core architecture of the module and oversee project development. The BI4Profiler module grew out of our partners’ and our own need for a tool when benchmarking and optimizing custom developed SQL scripts. We wanted to use the existing framework so this tool was packed as a module, thus it can be analyzed using any BI compatible front end tool. To ensure independency of statistic data, the BI4Profiler deploys its own separate data warehouse with staging and presentation area, as well as an OLAP cube with a set of dimensions. Although module, it has an additional core functionality that we had to integrate into the existing framework. During the execution of the scripts, this separate thread pools the SQL Server using DMVs (Dynamics Management Views) for statistics, which first saves said statistics to the data warehouse, thence builds and processes the analytical database.

    Item Type: Thesis (EngD thesis)
    Keywords: BI, BI4Dynamics, OLAP, data warehouse, benchmarking, DMV
    Number of Pages: 58
    Language of Content: English
    Mentor / Comentors:
    Name and SurnameIDFunction
    doc. dr. Luka Šajn307Mentor
    Link to COBISS: http://www.cobiss.si/scripts/cobiss?command=search&base=51012&select=(ID=1536203971)
    Institution: University of Ljubljana
    Department: Faculty of Computer and Information Science
    Item ID: 2900
    Date Deposited: 15 Jan 2015 12:35
    Last Modified: 23 Feb 2015 12:23
    URI: http://eprints.fri.uni-lj.si/id/eprint/2900

    Actions (login required)

    View Item