Determining Which Fields Populate Analysis Cubes

If you use Analysis Cubes, you can select which Vantagepoint fields (dimensions and measures) populate the data cubes.

Initially, all the possible Vantagepoint fields that can populate the data cubes as dimensions and measures are selected by default to populate the data cubes. Reducing the number of fields that populate the data cubes will reduce the time that it takes to refresh the data cubes.

  • The Analysis Cubes feature does not use Vantagepoint security. You must use SQL Server Analysis Services security to set up permissions by role or by user to define who can access specific dimensions and measures.
  • You can select or clear dimensions and measures to populate the data cubes at any time. Whenever you create or modify the selections on the Analysis Cubes form, you must contact your system administrator to run a refresh to update the Analysis Cubes. Depending on your company's configuration of Vantagepoint, your system administrator runs the refresh process or submits an Analysis Cubes Refresh service request to the Deltek Cloud Ops.
  • 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.
  • To select user-defined fields to populate the data cubes, you must select the Available for Analysis Cubes check box for each user-defined field in Settings > General > Screen Designer.