Calculated Measures

If you use Vantagepoint Analysis Cubes, you can create calculated measures to add to the project data cube.

With calculated measures, you can:

  • Create unique calculations for the Contract Backlog or apply company-designated multipliers to analyze project profitability for Project data with Vantagepoint standard fields and your own user-defined fields.
  • Calculate an employee utilization amount based on labor cost, labor billing, employee realization amounts, or your own user-defined fields.

Important Information

  • You can create calculated measures for the project data cube only.
  • You cannot create nested calculated measures.
  • If you create a calculated measure for a user-defined field and then delete the user-defined field, you must manually delete the calculated measure on the Calculated Measures tab. The calculated measure is not deleted automatically. If you do not delete the calculated measure from the Calculated Measures tab, it still displays in the Excel PivotTable List and in Tableau. If you add it to a report, it does not return anything meaningful.