Canada Spends Logo

Explore our Budget 2026 analysis

Grant: Engage Grants Program

McMaster University

$23,924.00

Multi-dimensional reporting and analysis

FY 2012-13

Summary
Vena Solutions is an innovative software provider delivering financial and regulatory solutions for the office of finance, i.e., finance and accounting departments of publicly traded companies. In particular, Vena delivers a comprehensive, innovative and simple-to-use Spreadsheet Process Management (SPM) solution. Online Analytical Processing (OLAP) is an approach that allows for multi-dimensional analysis to occur on a set of data in real-time. The Vena solution currently produces a multi-dimensional data model using standard relational tables, which are connected together to form what is known as a star schema. That is, SPM imitates multi-dimensional database through this schema. It creates a customized database view and connects to that view directly from an analysis tool such as Excel. The main problem of this solution is that it does not scale with problem size. To achieve faster response time to queries, Vena's challenge is to replace the star schema in SPM by an in-memory cube. The purpose of this project is to investigate how to achieve this: we need to evaluate various possibilities, chose the best solution, and produce a prototype implementation. We shall research possibilities for building an in-memory OLAP cube and how it can connect to Vena SPM Excel framework. This includes literature review, narrowing down the options to a few tools, and performing empirical studies. Here we should assess the suitability of tools such as the open-source Pentaho Mondrian OLAP Server, MSAS, voltDB, etc. Criteria include how fast the cube can be updated, ease-of-use, ability to connect to Excel, memory requirements, etc. A crucial goal is to ensure that the time taken to build, process and update the cube will scale to large datasets in real-time. We shell produce a comprehensive report that assesses open-source and inexpensive commercial tools. Based on it, we shall make a recommendation to the Vena Solutions team what approach to pursue in terms of building an OLAP cube.
Program
Engage Grants Program
Location
Ontario, Canada
Recipient Type
Academia
Type
Grant
Source
NSERC's Awards Data

As published

Application id
433817-2012
Name nom
Nedialkov, Nedialko
Department département
Computing and Software
Organization id
27
Institution établissement
McMaster University
Province en
Ontario
Province fr
Ontario
Country en
CANADA
Country fr
CANADA
Fiscal year exercice financier
2012
Competition year année de concours
2012
Award amount
23924
Program id
EGP
Program name en
Engage Grants Program
Program name fr
Programme de subventions d'engagement partenariat
Group en
Research partnerships programs
Group fr
Programmes de partenariat
Committee code
1553
Committee name en
Ontario Internal Decision Committee
Committee name fr
Comité de décision interne pour l'Ontario
Area of application code
801
Area of application group en
Information and communication services
Area of application group fr
Services d'information et de télécommunications
Area of application en
Computer software
Area of application fr
Logiciel
Research subject code
2713
Research subject group en
Information technology
Research subject group fr
Technologie de l'information
Research subject en
Algorithms
Research subject fr
Algorithmes
Partie
1
Nb partie
1
Application title
Multi-dimensional reporting and analysis
Keyword
NSERC
Application summary
Vena Solutions is an innovative software provider delivering financial and regulatory solutions for the office of finance, i.e., finance and accounting departments of publicly traded companies. In particular, Vena delivers a comprehensive, innovative and simple-to-use Spreadsheet Process Management (SPM) solution. Online Analytical Processing (OLAP) is an approach that allows for multi-dimensional analysis to occur on a set of data in real-time. The Vena solution currently produces a multi-dimensional data model using standard relational tables, which are connected together to form what is known as a star schema. That is, SPM imitates multi-dimensional database through this schema. It creates a customized database view and connects to that view directly from an analysis tool such as Excel. The main problem of this solution is that it does not scale with problem size. To achieve faster response time to queries, Vena's challenge is to replace the star schema in SPM by an in-memory cube. The purpose of this project is to investigate how to achieve this: we need to evaluate various possibilities, chose the best solution, and produce a prototype implementation. We shall research possibilities for building an in-memory OLAP cube and how it can connect to Vena SPM Excel framework. This includes literature review, narrowing down the options to a few tools, and performing empirical studies. Here we should assess the suitability of tools such as the open-source Pentaho Mondrian OLAP Server, MSAS, voltDB, etc. Criteria include how fast the cube can be updated, ease-of-use, ability to connect to Excel, memory requirements, etc. A crucial goal is to ensure that the time taken to build, process and update the cube will scale to large datasets in real-time. We shell produce a comprehensive report that assesses open-source and inexpensive commercial tools. Based on it, we shall make a recommendation to the Vena Solutions team what approach to pursue in terms of building an OLAP cube.