If you use Vision Analysis Cubes, you can create calculated measures to add to the Vision project data cube. These calculated measures display in Microsoft Excel, so that you can use them when you create custom reports. When you create frequently used calculated measures in Vision, then you do not need to recreate them repeatedly in individual reports in Excel.
For example, you can:
-
Create unique calculations for Contract Backlog or apply company-designated multipliers to analyze project profitability for Project data with Vision 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 you 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. If you add it to a report, it does not return anything meaningful.