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

Dimensions Tab of the Analysis Cubes Form

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

Initially, all the Vantagepoint dimension 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 dimensions 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 dimensions, 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
Select All Click this option on the grid toolbar to select the check box for all dimensions in the grid.
Unselect All Click this option on the grid toolbar to clear the check box for all dimensions in the grid, except multi-string, hierarchical dimensions.
Check boxes This column displays check boxes for each dimension in the grid. By default, this check box is selected for all dimensions when you open the Dimensions tab for the first time. Clear the check box for the dimensions that you do not want to populate the data cubes.

The check box is disabled for all multi-string and hierarchical dimensions in the grid. You cannot clear the check boxes for these dimensions.

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

  • To clear or select the check box for individual dimensions one at a time, click the check box in a dimension's row.
  • To clear or select the check box for all the dimensions 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 dimension belongs. You cannot modify a dimension's group.

Dimensions are organized and displayed by group in the custom report and workbook. For example, dimensions for the Projects hub are in the Projects group in the PivotTable list and in Tableau. If all of the dimensions in a group are not selected, the group does not display at all in the Excel PivotTable list and in Tableau.

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

Dimensions are organized and displayed by group and folder in the custom report and workbook. For example, dimensions for the Project hub are in the Projects group. Within the Projects group you see the following folders that contain dimensions: Location Address, Multicurrency, Phase, Project, Project Billing Client, Project Primary Client, and Task. If all of the dimensions in a folder are not selected, the folder does not display at all in the Excel PivotTable list and in Tableau.

Default Field Name This column displays the default field label for a field (dimension), which you cannot modify. You specify default field labels 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.