Refreshing Analysis Cubes

You must run a refresh to keep the Analysis Cubes updated with the changes in your Vantagepoint data or cube configuration.

Refreshing Analysis Cubes Data

To ensure that you are reviewing your Vantagepoint Intelligence dashboards and reports with the most current data, a default process to refresh Analysis Cubes occurs every night. This daily refresh process does not include changes in cube configuration (such as KPIs, system labels, user-defined fields, and so on); you run a separate refresh process for these. You view and modify this 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. You can perform this task if the Allow Access to Analysis Cubes Full Refresh option is selected for your role on the Overview tab in Settings > Security > Roles. This setting grants your role access to the Refresh tab on the Analysis Cubes form. When you run a full refresh of the Analysis Cubes, the refresh request is sent to the Process Server and is displayed as RefreshQueue in Settings > General > Process Servers. Use the RefreshQueue process to check the progress of the Analysis Cubes refresh.

To avoid performance and functionality issues, Deltek recommends that you schedule a refresh process at a time when no one is likely to use Analysis Cubes.

If your firm uses the Vantagepoint Cloud product, contact your system administrator to request a full refresh of Analysis Cubes.

Refreshing Analysis Cubes with Setting Changes

Whenever you create or modify system labels, user-defined fields, or selections on the Analysis Cubes form (KPIs, dimensions, measures, calculated measures, or currency exchange information), 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.