Deltek-Provided Key Performance Indicators
Deltek provides some pre-designed key performance indicators (KPIs) on the Key Performance Indicators tab in Analysis Cubes Configuration. You can use these when you create Vision custom reports (pivot table reports) in Excel.
You can change all except the following settings on the Key Performance Indicators tab for the Deltek-provided KPIs:
-
Measure
-
Measure Type
-
Dimension
-
Timeframe
-
Label
If you use Microsoft SQL Server Standard Edition, the following Deltek-provided KPIs are not available:
-
DSOTargetPrincipal
-
DSOTargetOrg1
-
DSOTargetProject Manager
-
DSOTargetNoDimension
-
DWOTargetPrincipal
-
DWOTargetOrg1
-
DWOTargetProject Manager
-
DWOTargetNoDimension
These KPIs are available if you use SQL Server Enterprise Edition.
Warning
If you try to delete one of these KPIs on the Key Performance Indicators tab, Vision displays a warning. The warning informs you that if you delete the KPI, you will receive errors within the Vision pivot table reports that contained the KPIs.
Predefined Key Performance Indicators
The following KPIs are provided by Deltek:
| KPI Description | KPI Label |
|---|---|
| Billed by Plan Org1 | RevenueTargetOrg1 |
| Billed by Plan Principal | RevenueTargetPrincipal |
| Contract Total Compensation by Project Org1 | ContractSalesTargetOrg1 |
| Days Sales Outstanding over 90 by Project Principal | DSOTargetPrincipal |
| Days Sales Outstanding over 90 by Project Org1 | DSOTargetOrg1 |
| Days Sales Outstanding over 90 by Project Manager | DSOTargetProject Manager |
| Days Sales Outstanding over 90 with no dimension (system wide) | DSOTargetNoDimension |
| Days Work In Process Outstanding over 90 by Project Manager | DWOTargetProject Manager |
| Days Work In Process Outstanding over 90 by Project Org1 | DWOTargetOrg1 |
| Days Work In Process Outstanding over 90 by Project Principal | DWOTargetPrincipal |
| Days Work in Progress Outstanding over 90 with no dimension (system wide) | DWOTargetNoDimension |
| Effective Multiplier with no dimension (system wide) | EffectiveMultiplierNoDimension |
| Effective Multiplier by Project Principal | EffectiveMultiplierTargetPrincipal |
| Effective Multiplier by Project Org1 | EffectiveMultiplierTargetOrg1 |
| Effective Multiplier by Project Manager | EffectiveMultiplierTargetProject Manager |
| Employee Contract Credit Amount with no dimension (system wide) | ContractSalesTargetNoDimension |
| Employee Contract Credit Amount by Employee | ContractSalesTargetEmployee |
| Gross Margin Percent with no dimension (system wide) | ProfitPercentNoDimension |
| Gross Margin Percent by Project Org1 | ProfitPercentexlcudingOHTargetOrg1 |
| Gross Margin Percent by Project Manager | ProfitPercentexlcudingOHTargetProject Manager |
| Gross Margin Percent by Project Principal | ProfitPercentexlcudingOHTargetPrincipal |
| Opportunity Revenue by Opportunity Project Manager | OpportunitySalesTargetProject Manager |
| Opportunity Revenue by Opportunity Principal | OpportunitySalesTargetPrincipal |
| Opportunity Revenue by Opportunity Org1 | OpportunitySalesTargetOrg1 |
| Opportunity Revenue with no dimension (system wide) | OpportunitySalesTargetNoDimension |
| Realization Ratio by Project Manager | RealizationRatioTargetProject Manager |
| Realization Ratio by Project Org1 | RealizationRatioTargetOrg1 |
| Realization Ratio by Project Principal | RealizationRatioTargetPrincipal |
| Revenue by Project Org1 | RevenueTargetProjectOrg1 |
| Revenue by Project Principal | RevenueTargetProjectPrincipal |
| Variance Percent by Project Manager | VariancePercentTargetProject Manager |
| Variance Percent by Project Principal | VariancePercentTargetPrincipal |
| Variance Percent by Project Org1 | VariancePercentTargetOrg1 |