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: Fiscal Periods Plans Presentation Currency Projects Transaction Dates
Accounts Receivables	Valid dimension groups: Accounts Fiscal Periods Presentation Currency Projects Transaction Dates
Activities Measures	Valid dimension group: Activities Employees Opportunities Projects Transaction Date
Activity Client Measures	Valid dimension group: Activity Client folder in the Activities dimension group
AR Balance	Valid dimension groups: Invoices Presentation Currency Projects
AR Trending	Valid dimension group: Fiscal Periods Invoices Presentation Currency Project Transaction Date
Billed	Valid dimension group: Accounts Fiscal Periods Opportunities Presentation Currency Projects Transaction Dates
Compensation - Contract	Valid dimension groups: Fiscal Periods Opportunities Plans Presentation Currency Projects Project Contracts
Compensation - Plan	Valid dimension groups: Plans Projects Transaction Dates (The Calendar dimension only; plans do not have transaction dates or fiscal periods.)
Compensation - Project	Valid dimension groups: Opportunities Plans Presentation Currency Projects
Employee Measures	Valid dimension group: Employees
Employees Contract Credits	Valid dimension group: Employees Presentation Currency Project Contracts Projects Transaction Dates (When you combine the Transaction Date dimension with Employees Contract Credits measures, Vision uses the Approved Date from the Contract tab of the Project Info Center as the transaction date.)
Expenses - Billing and Expenses - Cost	Valid dimension groups: Accounts Billing Status Employees Expense Types Fiscal Periods Opportunities Plans Presentation Currency Projects Transaction Dates Transaction Types Units Vendors
Labor - Billing and Labor - Cost and Labor - Employee	Valid dimension groups: Billing Status (for the Labor - Billing and Labor - Cost measures only) Employees Fiscal Periods Labor Categories Labor Codes Opportunities Plans Presentation Currency Projects Transaction Dates Transaction Types
Opportunity Client Measures	Valid dimension group: Opportunity Client folder in the Opportunity dimension group
Opportunity Measures	Valid dimension group: Opportunities
Overhead	Valid dimension groups: Fiscal Periods Opportunities Plans Presentation Currency Projects
Plan Client Measures	Valid dimension group: Plan Clients folder in the Plans dimension group
Plan Expenses - Billing and Plan Expenses - Cost Baseline folder	Valid dimension groups: Accounts Plans Presentation Currency Projects Transaction Dates Units Vendors
Plan Expenses - Billing and Plan Expenses - Cost Baseline - EAC folder	Valid dimension groups: Plans Presentation Currency
Plan Expenses - Billing and Plan Expenses - Cost EAC folder	Valid dimension groups: Plans Presentation Currency
Plan Expenses - Billing and Plan Expenses - Cost ETC folder	Valid dimension groups: Plans Presentation Currency Transaction Date
Plan Expenses - Billing and Plan Expenses - Cost Percent Complete folder	Valid dimension groups: Plans
Plan Expenses - Billing and Plan Expenses - Cost Planned folder	Valid dimension groups: Accounts Plans Presentation Currency Projects Transaction Dates Units Vendors
Plan Expenses - Billing and Plan Expenses - Cost Planned - EAC folder	Valid dimension groups: Plans Presentation Currency
Plan Labor - Billing and Plan Labor - Cost Baseline Folder	Valid dimension groups: Employees Labor Categories Labor Codes Plans Presentation Currency Projects Transaction Dates (The Calendar dimension only; plans do not have transaction dates or fiscal periods.)
Plan Labor - Billing and Plan Labor - Cost Baseline - EAC Folder	Valid dimension groups: Labor Codes Plans Transaction Dates (The Calendar dimension only; plans do not have transaction dates or fiscal periods.)
Plan Labor - Billing and Plan Labor - Cost EAC Folder	Valid dimension groups: Employees Labor Categories Labor Codes Plans Presentation Currency Projects Transaction Dates (The Calendar dimension only; plans do not have transaction dates or fiscal periods.)
Plan Labor - Billing and Plan Labor - Cost Earned Value Folder BCWP and BCWS dimensions	Valid dimension groups: Labor Codes Plans Transaction Dates (The Calendar dimension only; plans do not have transaction dates or fiscal periods.)
Plan Labor - Billing and Plan Labor - Cost Earned Value Folder ACWP dimension	Valid dimension groups: Employees Labor Categories Labor Codes Plans Projects
Plan Labor - Billing and Plan Labor - Cost ETC Folder	Valid dimension groups: Employees Labor Categories Labor Codes Plans Presentation Currency Projects Transaction Dates (The Calendar dimension only; plans do not have transaction dates or fiscal periods.)
Plan Labor- Billing and Plan Labor - Cost Percent Complete Folder	Valid dimension groups: Labor Codes Plans Transaction Dates (The Calendar dimension only; plans do not have transaction dates or fiscal periods.)
Plan Labor- Billing and Plan Labor - Cost Planned Folder	Valid dimension groups: Employees Labor Categories Labor Codes Plans Presentation Currency Projects Transaction Dates (The Calendar dimension only; plans do not have transaction dates or fiscal periods.)
Plan Labor- Billing and Plan Labor - Cost Planned Folder - EAC	Valid dimension groups: Labor Codes Plans Transaction Dates (The Calendar dimension only; plans do not have transaction dates or fiscal periods.)
Plan Measures	Valid dimension groups: Plans
Plan Totals - Billing and Plan Totals - Cost	Valid dimension groups: Plans
Planned Billable Utilize Hours and Planned Utilize Hours	Valid dimension groups: Employees Labor Categories Labor Codes Plans Transaction Dates
Project Billing Client Measures	Valid dimension group: Project Billing Client folder in the Projects dimension group
Project Budgeting	Valid dimension groups: Accounts Labor Codes Projects Vendors
Project Measures	Valid dimension group: Projects
Project Primary Client Measures	Valid dimension group: Project Primary Client in the Projects dimension group
Promotional Spent Billing and Promotional Spent Cost	Valid dimension groups: Fiscal Periods Presentation Currency Projects
Received	Valid dimension groups: Accounts Fiscal Periods Opportunities Plans Presentation Currency Projects Transaction Dates
Revenue - Opportunity	Valid dimension group: Opportunities Transaction Date
Revenue - Plan	Valid dimension groups: Plans Projects Transaction Dates
Revenue - Project	Valid dimension groups: Accounts Fiscal Periods Opportunities Plans Presentation Currency Projects Transaction Dates
Time Analysis	Valid dimensions groups: Employees Transaction Dates
Vendor Measures	Valid dimension group: Vendors
Vendor Paid	Valid dimension group: Vendors Paid