Custom Reports and Analysis Cubes
With Analysis Cubes, you can create Vision custom reports with Microsoft® Excel® 2007 or other report writing software that uses Microsoft Analysis Services, a component of Microsoft® SQL Server™.
Analysis Cubes provides the following data cubes with which you create reports:
In Excel, you connect to one of the two Vision OLAP data cubes (external source) and display the Vision data in a PivotTable report. Users who are familiar with Excel and pivot table reports can quickly rearrange report information. You can drill down instantly on report information to see the transaction detail. The process to create a report is less complex because you do not need to understand the Vision database structure.
Before you can create custom reports using Vision data cubes, a Vision system administrator must complete the Analysis Cubes configuration as outlined in the Deltek Vision Installation and Configuration Guide for Performance Management (Analysis Cubes). You can download this guide on the Deltek Customer Care Connect site.
Vision data cubes must be refreshed on a regular basis so that the reports you create access current Vision data.
Deltek uses Microsoft Excel 2007 internally to create reports and test the Analysis Cubes software. Vision Analysis Cubes help topics are based on using Microsoft Excel 2007 to create custom reports. Vision help topics cover only some of the many ways you can accomplish an action in Excel.