Project Data Cubes Valid Measures and Dimensions
There are valid measure and dimension combinations that must be used when you create Project data cube custom reports.
Valid Measure and Dimension Combinations
| Measure Group (values) | Dimension Group (sorting and grouping categories) |
|---|---|
|
Values |
Valid dimension groups:
|
|
Accounts Receivables |
Valid dimension groups:
|
|
Activities Measures |
Valid dimension group:
|
|
Activity Client Measures |
Valid dimension group:
|
|
AR Balance |
Valid dimension groups:
|
|
AR Trending |
Valid dimension group:
|
| Billed |
Valid dimension group:
|
|
Compensation - Contract |
Valid dimension groups:
|
|
Compensation - Plan |
Valid dimension groups:
|
|
Compensation - Project |
Valid dimension groups:
|
|
Employee Measures |
Valid dimension group:
|
|
Employees Contract Credits |
Valid dimension group:
|
|
Expenses - Billing and Expenses - Cost |
Valid dimension groups:
|
|
Labor - Billing and Labor - Cost and Labor - Employee |
Valid dimension groups:
|
|
Opportunity Client Measures |
Valid dimension group:
|
|
Opportunity Measures |
Valid dimension group:
|
|
Overhead |
Valid dimension groups:
|
|
Plan Client Measures |
Valid dimension group:
|
|
Plan Expenses - Billing and Plan Expenses - Cost Baseline folder |
Valid dimension groups:
|
|
Plan Expenses - Billing and Plan Expenses - Cost Baseline - EAC folder |
Valid dimension groups:
|
|
Plan Expenses - Billing and Plan Expenses - Cost EAC folder |
Valid dimension groups:
|
|
Plan Expenses - Billing and Plan Expenses - Cost ETC folder |
Valid dimension groups:
|
|
Plan Expenses - Billing and Plan Expenses - Cost Percent Complete folder |
Valid dimension groups:
|
|
Plan Expenses - Billing and Plan Expenses - Cost Planned folder |
Valid dimension groups:
|
|
Plan Expenses - Billing and Plan Expenses - Cost Planned - EAC folder |
Valid dimension groups:
|
|
Plan Labor - Billing and Plan Labor - Cost Baseline Folder |
Valid dimension groups:
|
|
Plan Labor - Billing and Plan Labor - Cost Baseline - EAC Folder |
Valid dimension groups:
|
|
Plan Labor - Billing and Plan Labor - Cost EAC Folder |
Valid dimension groups:
|
|
Plan Labor - Billing and Plan Labor - Cost Earned Value Folder BCWP and BCWS dimensions |
Valid dimension groups:
|
|
Plan Labor - Billing and Plan Labor - Cost Earned Value Folder ACWP dimension |
Valid dimension groups:
|
|
Plan Labor - Billing and Plan Labor - Cost ETC Folder |
Valid dimension groups:
|
|
Plan Labor- Billing and Plan Labor - Cost Percent Complete Folder |
Valid dimension groups:
|
|
Plan Labor- Billing and Plan Labor - Cost Planned Folder |
Valid dimension groups:
|
|
Plan Labor- Billing and Plan Labor - Cost Planned Folder - EAC |
Valid dimension groups:
|
|
Plan Measures |
Valid dimension groups:
|
|
Plan Totals - Billing and Plan Totals - Cost |
Valid dimension groups:
|
|
Planned Billable Utilize Hours and Planned Utilize Hours |
Valid dimension groups:
|
|
Project Billing Client Measures |
Valid dimension group:
|
|
Project Budgeting |
Valid dimension groups:
|
|
Project Measures |
Valid dimension group:
|
|
Project Primary Client Measures |
Valid dimension group:
|
|
Promotional Spent Billing and Promotional Spent Cost |
Valid dimension groups:
|
|
Received |
Valid dimension groups:
|
|
Revenue - Opportunity |
Valid dimension group:
|
|
Revenue - Plan |
Valid dimension groups:
|
|
Revenue - Project |
Valid dimension groups:
|
|
Time Analysis |
Valid dimensions groups:
|
|
Vendor Measures |
Valid dimension group:
|
|
Vendor Paid |
Valid dimension group:
|