Analysis Cubes

In Analysis Cubes, the Vantagepoint project data cube and general ledger data cube serve as data sources for the Vantagepoint Intelligence dashboards that you create. Analysis Cubes is part of the Vantagepoint Intelligence module.

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 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 of 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 check box 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 product, contact your system administrator to submit an Analysis Cubes Refresh service request to the 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 product, contact your system administrator to request a full refresh of Analysis Cubes.

For more information, see Refreshing Analysis Cubes.