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 or in any business intelligence tool that supports Microsoft SQL Server Analysis Services OLAP cubes. You can also use them when you create Performance Management dashboards.
If you use Microsoft SQL Server Standard Edition, the following Deltek-provided KPIs are not available:
- DSOTargetPrincipal
- DSOTargetOrg1
- DSOTargetOrg2
- DSOTargetOrg3
- DSOTargetOrg4
- DSOTargetOrg5
- DSOTargetProject Manager
- DSOTargetNoDimension
- DWOTargetPrincipal
- DWOTargetOrg1
- DWOTargetOrg2
- DWOTargetOrg3
- DWOTargetOrg4
- DWOTargetOrg5
- 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.
On the Key Performance Indicators tab, you can change all except the following settings for the Deltek-provided KPIs:
- Measure
- Measure Type
- Dimension
- Timeframe
- Label
Deltek-Provided Key Performance Indicators
The following pre-defined KPIs are provided by Deltek on the Key Performance Indicators tab in :
KPIs with "Org1," "Org2," "Org3," "Org4," or "Org5" in their label apply if you use organizations in Vision. These KPIs applies for the specified organization level (1–5).
| KPI Description | KPI Label |
|---|---|
| Billed by Plan Org1 | RevenueTargetOrg1 |
| Billed by Plan Org2 | RevenueTargetOrg2 |
| Billed by Plan Org3 | RevenueTargetOrg3 |
| Billed by Plan Org4 | RevenueTargetOrg4 |
| Billed by Plan Org5 | RevenueTargetOrg5 |
| Billed by Plan Principal | RevenueTargetPrincipal |
| Contract Total Compensation by Project Org1 | ContractSalesTargetOrg1 |
| Contract Total Compensation by Project Org2 | ContractSalesTargetOrg2 |
| Contract Total Compensation by Project Org3 | ContractSalesTargetOrg3 |
| Contract Total Compensation by Project Org4 | ContractSalesTargetOrg4 |
| Contract Total Compensation by Project Org5 | ContractSalesTargetOrg5 |
| 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 Org2 | DSOTargetOrg2 |
| Days Sales Outstanding over 90 by Project Org3 | DSOTargetOrg3 |
| Days Sales Outstanding over 90 by Project Org4 | DSOTargetOrg4 |
| Days Sales Outstanding over 90 by Project Org5 | DSOTargetOrg5 |
| 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 Org2 | DWOTargetOrg2 |
| Days Work In Process Outstanding over 90 by Project Org3 | DWOTargetOrg3 |
| Days Work In Process Outstanding over 90 by Project Org4 | DWOTargetOrg4 |
| Days Work In Process Outstanding over 90 by Project Org5 | DWOTargetOrg5 |
| 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 Org2 | EffectiveMultiplierTargetOrg2 |
| Effective Multiplier by Project Org3 | EffectiveMultiplierTargetOrg3 |
| Effective Multiplier by Project Org4 | EffectiveMultiplierTargetOrg4 |
| Effective Multiplier by Project Org5 | EffectiveMultiplierTargetOrg5 |
| 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 Org2 | ProfitPercentexlcudingOHTargetOrg2 |
| Gross Margin Percent by Project Org3 | ProfitPercentexlcudingOHTargetOrg3 |
| Gross Margin Percent by Project Org4 | ProfitPercentexlcudingOHTargetOrg4 |
| Gross Margin Percent by Project Org5 | ProfitPercentexlcudingOHTargetOrg5 |
| 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 by Opportunity Org2 | OpportunitySalesTargetOrg2 |
| Opportunity Revenue by Opportunity Org3 | OpportunitySalesTargetOrg3 |
| Opportunity Revenue by Opportunity Org4 | OpportunitySalesTargetOrg4 |
| Opportunity Revenue by Opportunity Org5 | OpportunitySalesTargetOrg5 |
| 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 Org2 | RealizationRatioTargetOrg2 |
| Realization Ratio by Project Org3 | RealizationRatioTargetOrg3 |
| Realization Ratio by Project Org4 | RealizationRatioTargetOrg4 |
| Realization Ratio by Project Org5 | RealizationRatioTargetOrg5 |
| Realization Ratio by Project Principal | RealizationRatioTargetPrincipal |
| Revenue by Project Org1 | RevenueTargetProjectOrg1 |
| Revenue by Project Org2 | RevenueTargetProjectOrg2 |
| Revenue by Project Org3 | RevenueTargetProjectOrg3 |
| Revenue by Project Org4 | RevenueTargetProjectOrg4 |
| Revenue by Project Org5 | RevenueTargetProjectOrg5 |
| Revenue by Project Principal | RevenueTargetProjectPrincipal |
| Variance Percent by Project Manager | VariancePercentTargetProject Manager |
| Variance Percent by Project Principal | VariancePercentTargetPrincipal |
| Variance Percent by Project Org1 | VariancePercentTargetOrg1 |
| Variance Percent by Project Org2 | VariancePercentTargetOrg2 |
| Variance Percent by Project Org3 | VariancePercentTargetOrg3 |
| Variance Percent by Project Org4 | VariancePercentTargetOrg4 |
| Variance Percent by Project Org5 | VariancePercentTargetOrg5 |