Home > Analysis Module > Analysis Module Defined
The Analysis Module Defined
A cube is a data structure that aggregates data by the levels and hierarchies of each of the dimensions that you wish to analyse. Cubes combine several dimensions, such as time, geography, and product lines with summarised data, such as sales or inventory figures.
Cubes are not “cubes” in the strictly mathematical sense because they do not necessarily have equal sides.
The Analysis Module is an additional module that functions between the Sage Accpac Intelligence Connector Module and the Sage Accpac Intelligence Report Manager module. The purpose of the Analysis Module is to use an existing connection to a database provided by the Sage Accpac Intelligence Connector to access data and create an offline .cub file. This .cub file is then in turn used by the Sage Accpac Intelligence Report Manager module to create reports and finally Microsoft Excel is used to browse this cube data and create an output that can be linked to Sage Accpac Intelligence and refreshed as and when required.
In short, the use of the Sage Accpac Intelligence modules for data analysis purposes is summarised in sequential order as follows:
| Sage Accpac Intelligence Connector Module | Connects to the underlying database and publishes metadata from source data |
| Analysis Module | Creates a .cub file off the metadata made available by the Sage Accpac Connector Module |
| Sage Accpac Intelligence Report Manager Module | Creates a report of the .cub file established by the Analysis Module |
| Microsoft Excel | Used as the browser interface to analyse the data in the report created by the Analysis Module. |
| Create and Link Template | When a final layout is concluded the normal “Create and link” function within Sage Accpac Intelligence Report Manager is used to create a template of the final analysis output in Microsoft Excel. |