Vision OLAP Data Cubes

Vision Analysis Cubes and Microsoft SQL Server use OLAP (Online Analytical Processing) technology to provide Vision reporting databases—data cubes, which are subsets of the Vision transactional database.

In Microsoft Excel 2007, you connect to a Vision OLAP data cube (external data source) and display the Vision OLAP data in a PivotTable report.

The Analysis Cubes application provides you with the following Vision data cubes to create Vision custom reports:

• Project OLAP Data Cube — For reports with project, labor, expense, billed, plan, accounts receivable, and time analysis data.

• General Ledger OLAP Data Cube — For reports with general ledger and financial information.