Deltek Vantagepoint Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Analysis Cubes

When you enable the Analysis Cubes module, the Vantagepoint project data cube and general ledger data cube serve as data sources for custom reports. Analysis Cubes is also part of the Vantagepoint Intelligence module, where it is used as a data source for custom reports and Vantagepoint Intelligence dashboards.

On the Analysis Cubes form (Settings > General > Analysis Cubes), you can:

  • Select which measures, dimensions, or user-defined fields from your Vantagepoint database populate the data cubes.
  • Create key performance indicators (KPIs) for the project data cubes and enter specific goals for individual dimension records.
  • Create calculated measures for the project data cubes.
  • Set up currency exchange information for the data cubes (used for presentation currencies).
  • Schedule a refresh run to update and recalculate cube values at any time or on a regular basis.

Important Information

  • You can access Analysis Cubes in Vantagepoint only if you have the Vantagepoint Intelligence module or Analysis Cubes module activated.
  • You can create custom reports with Microsoft Excel or any tool that supports SQL Server Analysis Services Online Analytical Processing (OLAP) cubes.
  • If you remove fields that previously 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.
  • If you use the Multicompany feature, the selections that you make on the Analysis Cubes form apply for all the companies in your enterprise.
  • Multi-string, hierarchical dimensions on the Dimensions tab (such as Vendors by Geography and Projects by Organization in the Projects dimension group) group items by a predefined hierarchy. For example, when you select Vendors by Geography, vendors are grouped by their country, state, and city. These multi-string, hierarchical dimensions always populate the data cubes; you cannot remove them. They display in the Dimensions grid with the checkbox selected, and you cannot clear it.

    Also, if in the Dimensions grid you clear a field that is a component of a multi-string hierarchical dimension (for example, the city for the Vendors by Geography dimension), the hierarchical dimension still populates the data cubes.

    You can use Microsoft SQL Server Analysis Services security to filter multi-string, hierarchical dimensions out of the data cubes.

Refreshing Analysis Cubes Settings

Whenever you create or modify KPIs, dimensions, measures, calculated measures, user-defined fields, or system labels, these cube configuration changes must be applied in the PowerShell script to be available in Analysis Cubes.

If your firm uses the Vantagepoint on-premises product, contact your system administrator to run a refresh of the Analysis Cubes.

If your firm uses the Vantagepoint cloud-based product, and a full refresh or rebuild is necessary, contact your system administrator to submit an Analysis Cubes Refresh service request to Deltek Cloud Ops.

Refreshing Analysis Cubes Data

By default, a refresh is run every night to update the Analysis Cubes with the most current Vantagepoint data. This daily refresh process does not include changes in cube configuration (such as KPIs, system labels, user-defined fields, and so on). You can view and modify the daily refresh process in Utilities > Process Server > Queue Manager.

If your firm uses the Vantagepoint on-premises product, you can run a full refresh of the cube data at any time if your role has access rights to the Refresh tab of the Analysis Cubes form.

If your firm uses the Vantagepoint cloud-based product, and a full refresh or rebuild is necessary, contact your system administrator to submit an Analysis Cubes Refresh service request to Deltek Cloud Ops.

For more information, see Refreshing Analysis Cubes.

Key Reference Materials

The following references about VI are available in the Vantagepoint Information Center. To access the Vantagepoint Information Center, click the Deltek logo at the upper-left corner of the help page.

Field Description
Vantagepoint Intelligence and Analysis Cubes Installation and Configuration Guide This PDF guide explains how to install Vantagepoint Intelligence, Analysis Cubes, and the dashboard components that are included in the Vantagepoint Intelligence module for an on-premises installation of Vantagepoint.

Click the PDF Guides tile in the Vantagepoint Information Center to find and download the Vantagepoint Intelligence and Analysis Cubes Installation and Configuration PDF guide.

Vantagepoint Intelligence and Analysis Cubes Content and Functionality Overview Guide This PDF guide describes Analysis Cubes and the data cubes that you can use to create Vantagepoint Intelligence workbooks with the Vantagepoint Intelligence Desktop Tool. The guide also provides descriptions of the dimensions and measures that are available for Project and General Ledger data cubes.

Click the PDF Guides tile in the Vantagepoint Information Center to find and download the Vantagepoint Intelligence and Analysis Cubes Content and Functionality Overview PDF guide.