Analysis Cubes Configuration Overview

The Analysis Cubes feature is part of the Vision Performance Management module. It provides you with a Vision project data cube and a general ledger data cube from which you can create custom Vision reports. Use Analysis Cubes Configuration yo set up the feature.

To configure Analysis Cubes, complete the following general steps:

• 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 the Vision 7.0 release. You have access to only the dimensions and measures available in prior releases.

Important Information

• 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 Installation and Configuration Guide for Performance Management (Analysis Cubes). Completing the Analysis Cubes configuration within Vision is only one part of the overall Analysis Cubes configuration. You can download the PDF guide from the Deltek Customer Care Connect site.

• 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 Tabs. This applies only if you purchased the Performance Management module.