Measures Tab of the Analysis Cubes Form

Use the Measures tab on the Analysis Cubes form to select which measure fields from your Vantagepoint database will populate the data cubes.

Initially, all the Vantagepoint measure fields listed on this tab are selected by default to populate the data cubes. You must select at least one to populate the data cubes. The measures that you select display in the Microsoft Excel PivotTable List when you create custom reports or in Tableau when you create workbooks.

Whenever you create or modify measures, these 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.

Contents

Field Description
Cube Select the data cube (Project or General Ledger) for which you want to select or clear measure fields.
Select All Click this option to select the check box for all measures in the grid.
Unselect All Click this option to clear the check box for all measures in the grid.
Check boxes This column displays check boxes for each measure in the grid. By default, this check box is selected for all measures when you open the Measures tab for the first time. Clear the check box for the measures that you do not want to populate the Vantagepoint data cubes.

There are two ways to clear or select the check boxes:

  • To clear or select the check box for individual measures one at a time, click the check box in a measure's row.
  • To clear or select the check box for all the measures in the grid at once, click the Unselect All or Select All option on the grid toolbar.

Group This column displays the group to which a measure belongs. You cannot modify a measure's group.

Measures are organized and displayed by group in the custom report and workbook. For example, billed measures are in the Billed group in the PivotTable list for the Project data cube.

The measures that display at the beginning of the Measures grid with no group name in the Group column are the measures from the Values measure group.

Folder This column displays the folder within the group to which a measure belongs. You cannot modify the folder name.

Measures are organized and displayed by group and folder in the custom report and workbook. For example, the Billed measures group contains a Billed By Category folder, a Billed By Category - Multicurrency folder, and a Multicurrency folder.

Default Field Name This column displays the default field label for a field (measure), which you cannot modify. The default field label is entered in Settings > Labels and Lists > Labels. Any field name changes that you make in Screen Designer do not display in the data cubes.

For additional information on Project and General Ledger data cube dimensions and measures, see the Vantagepoint Intelligence Content and Functionality Overview PDF guide. To find and download the file, click the Deltek logo at the upper left corner of the help page and then click the PDF Guides tile in the Vantagepoint Information Center.