The Analysis Module

Alchemex 7.1

Home > OLAP Module > Modules > The OLAP Module

The OLAP Module

An OLAP (On Line Analytical Processing) database allows business decision makers to analyze data that has been sorted into hierarchical structures. The data is static so all mathematical aggregations can be built into the database query, thereby providing a more efficient and resource friendly means of reporting. This data can then be pulled into a pivot table within Microsoft Excel, where the user is able to drill down into the report, using the hierarchical dimensions built into the query.

Main Functionalities

The OLAP Module allows the user to define the dimensions and measures required and then create the .cub file, which will then become a data source within the Report Manager, as the data remains static, the .cub file should be rebuilt daily, to ensure that the data remains relevant.

  • Define date Dimension Table

  • Define dimensions and measures

Key Components

  • Creates a .cub file

  • Data remains static