Analysis Cubes Configuration Overview

Vision Analysis Cubes is part of the Vision Performance Management module.

Analysis Cubes provides you with a Vision project data cube and a general ledger data cube from which you can create custom Vision reports with Microsoft Excel^® or any business intelligence tool that supports SQL Server Analysis Services OLAP cubes. It also serves as the data sources for the performance dashboards that you create.

The Analysis Cubes configuration in Vision Configuration > General > Analysis Cubes is only part of the overall Analysis Cubes configuration. When you configure Analysis Cubes for the first time or upgrade to a new version, you must follow the Analysis Cubes configuration instructions in the Deltek Vision Installation and Configuration Guide for Performance Management (Analysis Cubes). You can download the PDF guide from the Deltek Customer Care Connect site. This guide provides you with complete configuration instructions and the correct order in which you must perform the various configuration steps.

You complete the following Analysis Cubes configuration in Vision Configuration > General > Analysis Cubes:

• Select which measures and dimensions populate the data cubes.
• Create key performance indicators (KPIs) for the data cubes.
• Create calculated measures for the data cubes.
• Set up currency exchange information for the data cubes (used for presentation currencies).

You can access Analysis Cubes Configuration in Vision only if you purchased and activated the Performance Management application. If you have not purchased Performance Management, you still have access to Analysis Cubes, but you do not have access to Analysis Cubes Configuration and the additional capabilities that it provides, or to the dimensions and measures that were added in Vision 7.0 and later releases. You have access to only the dimensions and measures available in prior releases.

Important Information

• After you make the initial Analysis Cubes configuration selections in Vision Configuration, and anytime that you modify these settings, a system administrator must use the Vision Resource Kit to update the changes in the data cubes.
• If you remove dimensions and measures from the data cubes after they have populated the data cubes and you have reports that include these removed fields, the fields are automatically removed from custom reports after you refresh report data. You must rebuild the reports.
• If you activate the Performance Management edition of Vision Performance Management, the sample performance dashboards require that the Analysis Cubes include a specific set of dimensions, measures, and KPIs. If one of those required data items has been removed from the Analysis Cubes, you may receive errors when you try to publish or display the sample dashboards or your custom dashboards that are based on those sample dashboards.

  If you receive an error when you publish or display a dashboard, and the message indicates that required data is missing from the Analysis Cubes, click Restore Required Configuration on the toolbar on the Analysis Cubes form (Configuration > General > Analysis Cubes) to restore all of the dimensions, measures, and KPIs that the performance dashboards need. You must also reprocess the Analysis Cubes to apply the updated configuration.

User-Defined Fields that You Want to Populate the Vision Data Cubes

You select user-defined fields to populate the Vision data cubes in Configuration > General > User Defined Components. This applies only if you purchased the Performance Management module.