Project Data Cube Measures

There are numerous measures provided in the Project data cube. These measures display in the Excel 2007 PivotTable Field List in an Excel worksheet when you connect to the Project data cube to create a Vision custom report.

• The Project measures that you see in Excel may differ from the list in this help topic because:

  • You must purchase and activate the Vision Performance Management module to have access to the new dimensions and measures that were added in the Vision 7.0 release. If you do not purchase this module, you have access to only the dimensions and measures available in prior Vision releases.

  • You must purchase and activate the Vision Performance Management module to have access to the new Vision 7.0 Analysis Cubes Configuration. In Configuration you complete the following tasks:

    • Select which measures display in the Project data cube.

    • Select Vision user-defined fields to populate the Project data cube.

    • Create calculated measures to populate the Project data cube.

• Measures that are currency values display as numeric values. This allows you to apply whatever currency symbol and decimal formatting that you want in Excel.

• All numeric values except currency are rounded and formatted to display two decimals.

• When measures return no value for a record, a zero (0) or an empty cell displays in Excel. If you want these cells to be consistent and display one way in Excel, click the Options tab on the Excel Ribbon. From the PivotTable group, click Options. On the PivotTable Options dialog box, enter the desired formatting for empty cells in the For empty cells show: field.

• Some of the new measures in Analysis Cubes work only if you have Microsoft SQL Server™™ Enterprise Edition installed. These measures are noted in the list below.

• If you use the Multicurrency feature, measures that are located in the main group folders and subgroup folders other than the Multicurrency subfolders are expressed in functional currency. An exception to this is the Compensation – Contract group and the Compensation – Project group. The measures in those main group folders and subfolders other than the Multicurrency subfolders are expressed in project currency.

Measures in the Project Data Cube

Values Group
	Folders Earnings Earnings - Multicurrency Unbilled Unbilled - Multicurrency Valid Dimension and Measure Combinations The following are valid dimension groups that you can use with the Values measures on a report: Fiscal Periods Plans Presentation Currency Projects Transaction Dates
	Earnings Folder Measures: Backlog — (Total Compensation – Job-to-Date Revenue). This is the monetary amount of work that is under contract but has not yet been earned. It is used as an indicator of a firm's business volume. This measure is not applicable when used in conjunction with any of the fiscal period dimensions because Compensation is not broken out and stored in this way in the Vision PR table. If you use the Multicurrency feature, see the Multicurrency note with the Contract Backlog measure. Contract Backlog — (Contract Total Compensation – Total Revenue). The Contract Total Compensation amount is from the Total column in the Contract Details section of the Contract Management tab in the Project Info Center. Total Revenue can be found on the Vision Project Earnings or Office Earnings report. For promotional and overhead projects, the contract backlog amount is blank. Multicurrency: If you use the Multicurrency feature and the Backlog or Contract Backlog amounts are blank or not what you expect, check whether or not amounts were entered in the Compensation, Consultant Fee, Reimb. Allowance fields in the Functional Currency area on the Budget & Revenue tab and in the Compensation, Consultant Fee, Reimbursable Allowance, and Total fields on the Contract Management tab in the Project Info Center for a project. Functional currency amounts must be entered if the functional currency is different than the project currency. This also applies if you use these fields with the Presentation Currency dimension. Effective Multiplier — (Net Revenue/Direct Labor Cost). This is a productivity measure that shows the monetary amount of Net Revenue earned for the monetary amount of Labor Cost expended. Gross Margin — (Revenue – (Labor Cost + Direct Expense Cost + Reimbursable Expense Cost)). Firms that do not allocate overhead show project results on this basis. In Vision 7.0, Gross Margin replaced Profit Excluding Overhead from earlier versions. Gross Margin Percent — (Profit Excluding Overhead/Revenue) In Vision 7.0, Gross Margin Percent replaced Profit Percent Excluding Overhead from earlier versions. Net Revenue — (Revenue – (Non-Labor Direct Expense Cost + Reimbursable Expense Cost)). Net Revenue is used in the Effective Multiplier calculation. Net Revenue @ Billing — (Revenue – (Non-Labor Direct Expense Billing +Reimbursable Expense Billing)). Net Revenue @ Billing is used in the Realization Ratio Calculation. Profit — (Revenue – Spent @ Cost). This amount includes actual (not estimated) Overhead. Profit Excluding Overhead — (Revenue – Spent @ Cost Excluding Overhead). In Vision 7.0, Gross Margin replaced Profit Excluding Overhead from earlier versions. Profit Percent — (Profit/Revenue). This amount includes actual (not estimated) Overhead. Profit Percent Excluding Overhead — (Profit Excluding Overhead/Revenue). In Vision 7.0, Gross Margin Percent replaced Profit Excluding Overhead from earlier versions. Realization Ratio — (Net Revenue @ Billing/Direct Labor Billing). This compares Net Revenue earned to the Labor Billing amount. Spent @ Billing — (Labor Billing + Expense Billing). For overhead or promotional charge type projects, Direct Expense Billing and Reimbursable Expense Billing are not allowed for this measure. The same is true for regular charge type projects and Indirect Expense Billing. Spent @ Cost — (Labor Cost + Overhead + Expense Cost). The Overhead amount is actual, not estimated. For overhead or promotional charge type projects, Direct Expense Cost and Reimbursable Expense Cost are not allowed for this measure. The same applies for the regular charge type projects and the Indirect Expense Cost. Spent @ Cost Excluding Overhead — (Labor Cost + Expense Cost). For overhead or promotional charge type projects, Direct Expense Cost and Reimbursable Expense Cost are not allowed for this measure. The same is true for regular charge type projects and Indirect Expense Cost. Variance — (Revenue – Spent @ Billing). Variance Percent — (Variance/Revenue)
	Earnings – Multicurrency Folder This folder applies if you use the Multicurrency feature. This folder contains some of the same measures described above in the Earnings folder, but they are calculated in a project's billing and project currency. You specify a project's billing and project currencies on the General tab of the Project Info Center. Backlog in Billing Currency Backlog in Project Currency Contract Backlog in Billing Currency Contract Backlog in Project Currency Effective Multiplier in Billing Currency Effective Multiplier in Project Currency Gross Margin in Billing Currency Gross Margin in Project Currency Net Revenue in Billing Currency Net Revenue in Project Currency Profit Excluding Overhead in Billing Currency — In Vision 7.0, Gross Margin in Billing Currency replaced Profit Excluding Overhead in Billing Currency from earlier versions. Profit Excluding Overhead in Project Currency — In Vision 7.0, Gross Margin in Project Currency replaced Profit Excluding Overhead in Project Currency from earlier versions. Profit in Billing Currency Profit in Project Currency Profit Percent Excluding Overhead in Billing Currency — In Vision 7.0, Gross Margin Percentage in Billing Currency replaced Profit Percent Excluding Overhead in Billing Currency from earlier versions. Profit Percent Excluding Overhead in Project Currency — In Vision 7.0, Gross Margin Percent in Project Currency replaced Profit Percent Excluding Overhead in Project Currency from earlier versions. Spent @ Cost in Billing Currency Spent @ Cost in Project Currency Spent @ Cost Excluding Overhead in Billing Currency Spent @ Cost Excluding Overhead in Project Currency
	Unbilled Folder The following revenue category measures are available when you use the revenue categories feature in Vision. You assign labels for revenue categories 1–5 on the Labels tab in Configuration > General > System Settings, so the labels that you see in your software may be different from the default labels identified in this measures list. When you use these measures on a report, run Revenue Generation before you print the report. You can also find these measures on the Office Earnings report in Reporting > Project. Measures: DWO 360 — DWO = Days Work-In-Progress Outstanding. (Unbilled Total/(Revenue Total for the last 360 transaction days/360)). This measure is included in the Project data cube only if you use the Microsoft SQL Server™ Enterprise Edition. DWO 90 — DWO = Days Work-In-Progress Outstanding. (Unbilled Total/(Revenue Total for the last 90 transaction days/90)). This measure is included in the Project data cube only if you use the Microsoft SQL Server Enterprise Edition. Unbilled — If you use revenue categories, this is the grand total monetary amount of unbilled revenue for all revenue categories. If you do not use revenue categories, this is the monetary amount of unbilled revenue. Unbilled - Consultant <Revenue Category 2> — This is the monetary amount of unbilled revenue for revenue category 2. Unbilled - Labor <Revenue Category 1> — This is the monetary amount of unbilled revenue for revenue category 1. Unbilled - Reimb <Revenue Category 3> — This is the monetary amount of unbilled revenue for revenue category 3. Unbilled - <Revenue Category 4> — This is the monetary amount of unbilled revenue for revenue category 4. Unbilled - <Revenue Category 5> — This is the monetary amount of unbilled revenue for revenue category 5. Unbilled - Other — This is the monetary amount of unbilled revenue that is not mapped to a category.
	Unbilled – Multicurrency Folder The measures in this folder: Apply if you use the Multicurrency feature. Allow you to choose to report unbilled revenue amounts in billing and/or project currency. You specify a project's currencies on the General tab of the Project Info Center. The revenue category measures apply if you use the Revenue Categories feature to track multiple unbilled services and uninvoiced revenue accounts. The revenue category labels in the following list may be different than those you see in your software if you changed the labels for the Revenue Method 1–5 system labels on the Labels tab in Configuration > General > System Settings. You can also find these measures on the Office Earnings report in Vision Reporting > Project. On a custom Analysis Cubes report, the total amount for a multicurrency measure includes amounts with different currencies, which results in an incorrect amount. Whereas, on the Vision standard reports, total amounts for multicurrency measures display an "XXXXX.XX" total instead of a number that mixes the currencies together. Measures: DWO 360 in Billing Currency — DWO = Days Work-In-Progress Outstanding. (Unbilled Total /(Revenue Total for the last 360 transaction days/360)) in a project's billing currency. This measure is included in the Project data cube only if you use the Microsoft SQL Server Enterprise Edition. DWO 360 in Project Currency — DWO = Days Work-In-Progress Outstanding. (Unbilled Total/(Revenue total for the last 360 transaction days/360)) in a project's project currency. This measure is included in the Project data cube only if you use the Microsoft SQL Server Enterprise Edition. DWO 90 in Billing Currency — DWO = Days Work-In-Progress Outstanding. (Unbilled Total/(Revenue total for the last 90 transaction days/90)) in a project's billing currency. This measure is included in the Project data cube only if you use the Microsoft SQL Server Enterprise Edition. DWO 90 in Project Currency — DWO = Days Work-In-Progress Outstanding. (Unbilled Total/(Revenue total for the last 90 transaction days/90)) in a project's project currency. This measure is included in the Project data cube only if you use the Microsoft SQL Server™ Enterprise Edition. Unbilled - Consultant < Revenue Category 2> in Billing Currency — This is the monetary amount of unbilled revenue for revenue category 2 that is calculated in the project's billing currency. Unbilled - Consultant < Revenue Category 2> in Project Currency — This is the monetary amount of unbilled revenue for revenue category 2 that is calculated in the project's project currency. Unbilled - Labor < Revenue Category 1 > in Billing Currency — This is the monetary amount of unbilled revenue for revenue category 1 that is calculated in the project's billing currency. Unbilled - Labor < Revenue Category 1 > in Project Currency — This is the monetary amount of unbilled revenue for revenue category 1 that is calculated in the project's project currency. Unbilled - Reimbursable <Revenue Category 3> in Billing Currency — This is the monetary amount of unbilled revenue for revenue category 3 that is calculated in the project's billing currency. Unbilled - Reimbursable <Revenue Category 3> in Project Currency — This is the monetary amount of unbilled revenue for revenue category 3that is calculated in the project's project currency. Unbilled - <Revenue Category 4> in Billing Currency — This is the monetary amount of unbilled revenue for revenue category 4that is calculated in the project's billing currency. Unbilled - <Revenue Category 4> in Project Currency — This is the monetary amount of unbilled revenue for revenue category 4that is calculated in the project's project currency. Unbilled - <Revenue Category 5> in Billing Currency — This is the monetary amount of unbilled revenue for revenue category 5that is calculated in the project's billing currency. Unbilled - <Revenue Category 5> in Project Currency — This is the monetary amount of unbilled revenue for revenue category 5that is calculated in the project's project currency. Unbilled In Billing Currency — This is the monetary amount of unbilled revenue that is calculated in the billing currency. If you use revenue categories, this is the grand total monetary amount of unbilled revenue for all revenue categories (calculated in billing currency). Unbilled In Project Currency — This is the monetary amount of unbilled revenue that is calculated in the project currency. If you use revenue categories, this is the grand total monetary amount of unbilled revenue for all revenue categories (calculated in project currency). Unbilled - Other in Billing Currency — This is the monetary amount of unbilled revenue that is not mapped to a category that is calculated in the project's billing currency. Unbilled - Other in Project Currency — This is the monetary amount of unbilled revenue that is not mapped to a category that is calculated in the project's project currency.
Accounts Receivables Group
	Valid Dimension and Measure Combinations The following are valid dimension groups that you can use with the Accounts Receivable measures on a report: Accounts Fiscal Periods Presentation Currency Projects Transaction Dates Measures The Accounts Receivable measures include any credit memo monetary amounts posted for an invoice. Accounts Receivable Balance — This is the monetary amount that is invoiced or billed (including taxes billed) but not yet received. Credit Memo Amount — This is the monetary amount of credit memos posted for an invoice. DSO 90 — DSO = Days Sales Outstanding. (Accounts Receivable Balance / (Revenue Total for the last 90 transaction days / 90)). This measure is included in the Project data cube only if you use the Microsoft SQL Server Enterprise Edition. DSO 360 — DSO = Days Sales Outstanding. (Accounts Receivable Balance / (Revenue Total for the last 360 transaction days / 360)). This measure is included in the Project data cube only if you use the Microsoft SQL Server Enterprise Edition.
	Multicurrency Folder This folder applies if you use the Multicurrency feature. Measures The Accounts Receivable measures include any credit memo monetary amounts posted for an invoice. Accounts Receivable Balance in Billing Currency — This is the amount that is invoiced or billed (including taxes billed) but not yet received. This is expressed in a project's billing currency. Accounts Receivable Balance in Project Currency — This is the amount that is invoiced or billed (including taxes billed) but not yet received. This is expressed in a project's project currency. Credit Memo Amount in Billing Currency — This is the credit memo monetary amount posted for an invoice for which you have not yet received payment. This is expressed in the project's billing currency. Credit Memo Amount in Project Currency — This is the credit memo monetary amount posted for an invoice for which you have not yet received payment. This is expressed in the project's project currency. DSO 360 in Billing Currency — DSO = Days Sales Outstanding. (Accounts Receivable Balance / (Revenue Total for the last 360 transaction days / 360)) in a project's billing currency. This measure is included in the Project data cube only if you use the Microsoft SQL Server Enterprise Edition. DSO 90 in Billing Currency — DSO = Days Sales Outstanding. (Accounts Receivable Balance / (Revenue Total for the last 90 transaction days / 90)) in a project's billing currency. This measure is included in the Project data cube only if you use the Microsoft SQL Server Enterprise Edition. DSO 360 in Project Currency — DSO = Days Sales Outstanding. (Accounts Receivable Balance / (Revenue Total for the last 360 transaction days / 360)) in a project's project currency. This measure is included in the Project data cube only if you use the Microsoft SQL Server Enterprise Edition. DSO 90 in Project Currency — DSO = Days Sales Outstanding. (Accounts Receivable Balance / (Revenue Total for the last 90 transaction days / 90)) in a project's project currency. This measure is included in the Project data cube only if you use the Microsoft SQL Server Enterprise Edition. A project's project and billing currency are entered on the Budget & Revenue tab of the Project Info Center.
Activities Measures Group
	Valid Dimension and Measure Combinations The Activities measures can be used with the following dimension groups: Activities Employees Opportunities Projects Transaction Date Use Activities dimensions with the Activities Count measure. Measure Activities Count — Use this measure to count the number of activities. For example, you could use this measure to count activities for each employee within a time frame against a client, user-defined field, project, or opportunity. This could be part of an evaluation of how well employees are doing their jobs. The Activities Count measure includes activities created in all of Vision, including activities generated from the Planning module. If you want to exclude Planning activities from the activities count, you must use the Activity is From Planning dimension with the Activities Count measure. Select the No filter for the Activity Is From Planning measure to exclude all activities that are created from the Planning module from the activity count results.
Activity Client Measures Group
	Valid Dimension and Measure Combinations Use this measure with dimensions from the Activity Client folder in the Activities dimension group. Measure Activity Clients Count — This measure counts the number of clients associated with an activity for the dimension that you use it with. For example, if you add this measure and the Activity Client Country dimension from the Activity Client folder in the Activities dimension group to a report, the report displays the number of clients (client records) associated with activities for each country.
AR Balance
	Folders Multicurrency Valid Dimension and Measure Combinations The following are valid dimension groups that you can use with the AR Balance measures on a report: Invoices Presentation Currency Projects
	Measures The measures in this group display the outstanding invoice amounts (including taxes billed) that fall between the specified range of aging days in the measure name. An invoice's date is compared with the current fiscal period end date to determine the aging measure in which the invoice amount is included. You cannot use a prior fiscal period to see an aging from that point of time. If invoices are dated in the future (beyond the end date of the current fiscal period) they are included in the AR Balance 0-30 measure. Example: An invoice date is March 31, 2012. The current fiscal period = April 1 – April 30. The report data is refreshed April 1. The invoice amount is included within the AR Balance 31-45 measure because March 31 is 31 days from April 30. Measures: AR Balance 0-30 AR Balance 31-45 AR Balance 46-60 AR Balance 61-90 AR Balance 91-120 AR Balance over 120 Total Outstanding AR — This is the sum of all the AR Balance aging measures. Multicurrency folder This folder contains the same measures described above for AR Balances, but they are calculated in a project's billing and project currencies. You specify a project's billing and project currencies on the General tab of the Project Info Center. AR Balance 0-30 in Project Currency AR Balance 31-45 in Project Currency AR Balance 46-60 in Project Currency AR Balance 61-90 in Project Currency AR Balance 91-120 in Project Currency AR Balance over 120 in Project Currency AR Balance 0-30 in Billing Currency AR Balance 31-45 in Billing Currency AR Balance 46-60 in Billing Currency AR Balance 61-90 in Billing Currency AR Balance 91-120 in Billing Currency AR Balance over 120 in Billing Currency
AR Trending Group
	These dimensions are included in the Project data cube only if you use the Microsoft SQL Server™ Enterprise Edition. Valid Dimension and Measure Combinations The AR Trending measures can be used with the following dimension groups: Fiscal Periods Invoices Presentation Currency Project Transaction Date AR Trending measures can be combined with the Project and Project Billing Client dimensions in the Project dimension group. Measures Use these measures to view Accounts Receivable Aging information. A fiscal period's end date is compared with an invoice's invoice date to determine which AR trending category applies to an invoice. Fiscal periods vary in their number of days. However 30-day increments are used to determine the AR Trending categories within each fiscal period. Example Periods: Period 01/2012 is January 1–31, 2012, which is 31 days. Period 02/2012 is February 1–29, 2012, which is 29 days. Period 03/2012 is March 1–31, which is 31 days. Period 04/2012 is April 1–30, which is 30 days. Invoices: Invoice #1 for $2,000 is dated 1/1/2011. Invoice #2 for $10,000 is dated 1/31/2012. Invoice #3 for $5,000 is dated 2/25/2012. All invoices were unpaid as of May 1, 2012. The invoice amounts appear in the following Fiscal Period/AR Trending columns on a report: Description (Period end date is compared with the invoice dates) Fiscal Period / AR Trending Column Invoice Amount As of January 31: Invoice #1 is 30 days old. Invoice #2 is 0 days old. Invoice #3 is 0 days old. 01/2012 / AR Over 30 $2,000 (Invoice #1) Description (Period end date is compared with the invoice dates) Fiscal Period / AR Trending Column Invoice Amount As of February 29: Invoice #1 is 59 days old. Invoice #2 is 29 days old. Invoice #3 is 4 days old. 02/2012 / AR Over 30 $2,000 (Invoice #1) Description (Period end date is compared with the invoice dates) Fiscal Period / AR Trending Column Invoice Amount As of March 31: Invoice #1 is 90 days old. Invoice #2 is 60 days old. Invoice #3 is 35 days old. 03/2012 / AR Over 30 03/2012 / AR Over 60 03/2012 / AR Over 90 $17,000 (Invoices #1, #2, and #3) $12,000 (Invoice #1 and #2) $2,000 (Invoice #1) Description (Period end date is compared with the invoice dates) Fiscal Period / AR Trending Column Invoice Amount As of April 30: Invoice #1 is 120 days old. Invoice #2 is 90 days old. Invoice #3 is 65 days old. 04/2012 / AR Over 30 04/2012 / AR Over 60 04/2012 / AR Over 90 04/2012 / AR Over 120 $17,000 (Invoices #1, #2, and #3) $17,000 (Invoices #1, #2, and #3) $12,000 (Invoice #1 and #2) $2,000 (Invoice #1) AR Over 30 — This is the outstanding amount (including taxes billed) of invoices that are 30 or more days old when you compare invoice dates with the fiscal period end date. AR Over 45 — This is the outstanding amount (including taxes billed) of invoices that are 45 or more days old when you compare invoice dates with the fiscal period end date. AR Over 60 — This is the outstanding amount (including taxes billed) of invoices that are 60 or more days old when you compare invoice dates with the fiscal period end date. AR Over 90 — This is the outstanding amount (including taxes billed) of invoices that are 90 or more days old when you compare invoice dates with the fiscal period end date. AR Over 120 — This is the outstanding amount (including taxes billed) of invoices that are 120 or more days old when you compare invoice dates with the fiscal period end date. Total Outstanding AR — This is the total monetary amount that is invoiced or billed (including taxes billed) that is not yet received. It includes all invoices that are not yet due and all invoices that are overdue. Multicurrency Folder This folder applies if you use the Multicurrency feature. Measures: The following measures are the same as those listed directly in the AR Trending group folder, but these are calculated in a project's billing and project currency. These currencies are entered on the Budget & Revenue tab of the Project Info Center. AR Over 30 in Billing Currency AR Over 30 in Project Currency AR Over 60 in Billing Currency AR Over 60 in Project Currency AR Over 90 in Billing Currency AR Over 90 in Project Currency AR Over 120 in Billing Currency AR Over 120 in Project Currency
Billed Group
	Folders Billed by Category Billed by Category - Multicurrency Multicurrency Valid Dimension and Measure Combinations The following are valid dimension groups that you can use with the Billed measures on a report: Accounts Fiscal Periods Opportunities Presentation Currency Projects Transaction Dates
	Measures When you use these measures on a report, run Revenue Generation before printing the report. You can also find these measures on the Office Earnings report in Reporting > Project. The billed measures include any credit memo monetary amounts posted for an invoice. Billed — (Labor Billed + Fee Billed + Consultant Billed + Expense Billed + Unit Billed + Interest Billed). This measure does not include Taxes Billed; the Accounts Receivable Balance and Received measures include Taxes Billed. Billed Add Ons — This is the monetary amount billed for add-ons. Billed Consultants — This is the monetary amount billed for consultant expenses. Billed Fees — This is the monetary amount billed for fees. Billed Interest — This is the monetary amount billed for interest. Billed Labor — This is the monetary amount billed for labor. Billed Other — This is the monetary amount billed for charges that are not assigned to a specific category. This amount is based on how you set up your revenue accounts on the Accounts tab of the Billing Setup form (Configuration > Billing > General) if you use Interactive Billing or on the Invoice Mapping Accounts tab of the Accounts Receivable Configuration form (Configuration > Accounting > Accounts Receivable) if you do not use Interactive Billing. Billed Reimbursables — This is the monetary amount billed for reimbursable expenses. Billed Taxes — This is the monetary amount billed for taxes. Billed Units — This is the monetary amount billed for units.
	Billed by Category Folder The following revenue category measures are available when you use the revenue categories feature in Vision. Because you assign labels for revenue categories 1–5 on the Labels tab in Vision Configuration > General > System Settings, the labels that you see in your software may be different from the default labels identified in this measures list. When you use these measures on a report, run Revenue Generation before printing the report. Billed amounts for each category are based on the following formula: Billed= Revenue minus Unbilled The billed measures include any credit memo monetary amounts posted for an invoice. Measures: Billed - Consultant (Revenue Category 2) — This is the monetary amount billed for revenue category 2, whose default label is Consultant. Billed - Labor (Revenue Category 1) — This is the monetary amount billed for revenue category 1, whose default label is Labor. Billed - Other Category — This is the monetary amount billed for charges that are not assigned to a specific category. Billed - Reimb (Revenue Category 3) — This is the monetary amount billed for revenue category 3 whose default label is Reimb. Billed - <Revenue Category 4> — This is the monetary amount billed for revenue category 4. Billed - <Revenue Category 5> — This is the monetary amount billed for revenue category 5.
	Billed by Category - Multicurrency Folder The measures in this folder: Apply if you use the Multicurrency feature and the Revenue Categories feature. Allow you to choose to report project amounts in the billing or project currency. For each project, you specify the project and billing currencies on the General tab of the Project Info Center. Are based on the following formula for each category: Billed = Revenue – Unbilled. Because you assign labels for revenue categories 1–5 on the Labels tab in Configuration > General > System Settings, the labels that you see in your software may be different from the default labels identified in this measures list. The billed measures include any credit memo monetary amounts posted for an invoice. On a custom Analysis Cubes report, the total amount for a multicurrency measure includes amounts with different currencies, which results in an incorrect amount. Whereas, on the Vision standard reports, total amounts for multicurrency measures display an "XXXXX.XX" total instead of a number that mixes the currencies together. Measures: Billed - Consultant (Revenue Category 2) In Billing Currency — This is the monetary amount billed for revenue category 2 that is calculated in the billing currency. The default label for revenue category 2 is Consultant. Billed - Consultant (Revenue Category 2) In Project Currency — This is the monetary amount billed for revenue category 2 that is calculated in the project currency. The default label for revenue category 2 is Consultant. Billed - Labor (Revenue Category 1) In Billing Currency — This is the monetary amount billed for revenue category 1 that is calculated in the billing currency. The default label for revenue category 1 is Labor. Billed - Labor (Revenue Category 1) In Project Currency — This is the monetary amount billed for revenue category 1 that is calculated in the project currency. The default label for revenue category 1 is Labor. Billed - Other Category In Billing Currency — This is the monetary amount billed for charges that are not assigned to a specific revenue category that is calculated in the billing currency. Billed - Other Category In Project Currency — This is the monetary amount billed for charges that are not assigned to a specific revenue category that is calculated in the project currency. Billed - Reimb (Revenue Category 3) In Billing Currency — This is the monetary amount billed for revenue category 3 that is calculated in the billing currency. The default label for revenue category 3 is Reimb. Billed - Reimb (Revenue Category 3) In Project Currency — This is the monetary amount billed for revenue category 3 that is calculated in the project currency. The default label for revenue category 3 is Reimb. Billed - <Revenue Category 4> In Billing Currency — This is the monetary amount billed for revenue category 4 that is calculated with the billing currency. Billed - <Revenue Category 4> In Project Currency — This is the monetary amount billed for revenue category 4 that is calculated with the project currency. Billed - <Revenue Category 5> In Billing Currency — This is the monetary amount billed for revenue category 5 that is calculated with the billing currency. Billed - <Revenue Category 5> In Project Currency — This is the monetary amount billed for revenue category 5 that is calculated with the project currency.
	Multicurrency Folder The measures in this folder: Apply if you use the Multicurrency feature. Allow you to choose to report project amounts in the billing or project currency. A project's billing and project currencies are specified on the General tab of the Project Info Center. Are also found on the Office Earnings report in Vision Reporting > Project. Include any credit memo monetary amounts posted for an invoice. On a custom Analysis Cubes report, the total amount for a multicurrency measure includes amounts with different currencies, which results in an incorrect amount. Whereas, on the Vision standard reports, total amounts for multicurrency measures display an "XXXXX.XX" total instead of a number that mixes the currencies together. Measures: Billed Add Ons in Billing Currency — This is the monetary amount billed for add-ons that is calculated in the billing currency. Billed Add Ons in Project Currency — This is the monetary amount billed for add-ons that is calculated in the project currency. Billed Consultants in Billing Currency — This is the monetary amount billed for consultant expenses that is calculated in the billing currency. Billed Consultants in Project Currency — This is the monetary amount billed for consultant expenses that is calculated in the project currency. Billed Fees in Billing Currency — This is the monetary amount billed for fees that is calculated in the billing currency. Billed Fees in Project Currency — This is the monetary amount billed for fees that is calculated in the project currency. Billed in Billing Currency — This is the monetary amount of (Labor Billed + Fees Billed + Consultants Billed + Expenses Billed + Units Billed + Interest Billed + Taxes Billed + Add Ons Billed + Other Billed) calculated in billing currency. Billed in Project Currency — This is the monetary amount of (Labor Billed + Fees Billed + Consultants Billed + Expenses Billed + Units Billed + Interest Billed + Taxes Billed + Add Ons Billed + Other Billed) calculated in project currency. Billed Interest in Billing Currency — This is the monetary amount billed for interest that is calculated in the billing currency. Billed Interest in Project Currency — This is the monetary amount billed for interest that is calculated in the project currency. Billed Labor in Billing Currency — This is the monetary amount billed for labor that is calculated in the billing currency. Billed Labor in Project Currency — This is the monetary amount billed for labor that is calculated in the project currency. Billed Other in Billing Currency — This is the monetary amount billed for charges that are not assigned to a specific category. It is calculated in the billing currency. This amount is based on how you set up your revenue accounts on the Accounts tab of the Billing Setup form (Configuration > Billing > General) if you use Interactive Billing or on the Invoice Mapping Accounts tab of the Accounts Receivable Configuration form (Configuration > Accounting > Accounts Receivable) if you do not use Interactive Billing. Billed Other in Project Currency — This is the monetary amount billed for charges that are not assigned to a specific category. It is calculated in the project currency. This amount is based on how you set up your revenue accounts on the Accounts tab of the Billing Setup form (Configuration > Billing > General) if you use Interactive Billing or on the Invoice Mapping Accounts tab of the Accounts Receivable Configuration form (Configuration > Accounting > Accounts Receivable) if you do not use Interactive Billing. Billed Reimbursables in Billing Currency — This is the monetary amount billed for reimbursable expenses that is calculated in the billing currency. Billed Reimbursables in Project Currency — This is the monetary amount billed for reimbursable expenses that is calculated in the project currency. Billed Taxes in Billing Currency — This is the monetary amount billed for taxes that is calculated in the billing currency. Billed Taxes in Project Currency — This is the monetary amount billed for taxes that calculated in the project currency. Billed Units in Billing Currency — This is the monetary amount billed for units that is calculated in the billing currency. Billed Units in Project Currency — This is the monetary amount billed for units calculated in the project currency.
Compensation - Contract Group
	Folders Multicurrency Phase (Work breakdown structure (WBS) level 2) Project (Work breakdown structure (WBS) level 1) Task (Work breakdown structure (WBS) level 3) Valid Dimension and Measure Combinations The following are valid dimension groups that you can use with the Compensation Contract measures on a report: Fiscal Periods Opportunities Plans Presentation Currency Projects Project Contracts
	Measures The following measures are the sum of contract amounts from all projects that make up a contract. The amounts are retrieved from fields in the Contracts grid on the Contract Management tab of the Project Info Center. If you use the Multicurrency feature, these measures are expressed in the contract's project currency. Contract Compensation — This is the sum of a contract's compensation amount from all projects that make up a contract. The compensation amount is retrieved from the Compensation field on the Contracts grid. Contract Consultant Fee — This is the sum of a contract's consultant fee from all projects that make up a contract. The consultant fee amount is retrieved from the Consultant Fee field on the Contracts grid. Contract Reimbursable Allowance — This is the sum of a contract's reimbursable allowance from all projects that make up a contract. The reimbursable allowance amount is retrieved from the Reimbursable Allowance field on the Contracts grid. Contract Total Compensation — This is the sum of a contract's total compensation from all projects that make up a contract. The total compensation amount is retrieved from the Total field on the Contracts grid.
	Multicurrency Folder This folder applies if you use the Multicurrency feature. Measures: The following measures are the sum of contract amounts from all projects that make up a contract. The amounts are retrieved from the Compensation, Consultant Fee, Reimbursable Allowance, and Total fields in the Contracts grid on the Contract Management tab of the Project Info Center. These measures are expressed in billing currency and functional currency. Contract Compensation in Billing Currency Contract Compensation in Functional Currency Contract Consultant Fee in Billing Currency Contract Consultant Fee in Functional Currency Contract Reimbursable Allowance in Billing Currency Contract Reimbursable Allowance in Functional Currency Contract Total Compensation in Billing Currency Contract Total Compensation in Functional Currency The following measures are contract amounts for each project. They are retrieved from the Compensation, Consultant Fee, Reimbursable Allowance, and Total fields in the Contracts grid on the Contract Management tab of the Project Info Center for a project (WBS 1 level).These measures are expressed in billing currency and functional currency. Project Contract Compensation in Billing Currency Project Contract Compensation in Functional Currency Project Contract Consultant Fee in Billing Currency Project Contract Consultant Fee in Functional Currency Project Contract Reimbursable Allowance in Billing Currency Project Contract Reimbursable Allowance in Functional Currency Project Contract Total Compensation in Billing Currency Project Contract Total Compensation in Functional Currency The following measures are contract amounts for each phase of a project. The amounts are retrieved from the Compensation, Consultant Fee, Reimbursable Allowance, and Total fields in the Contracts grid on the Contract Management tab of the Project Info Center for a phase (WBS 2 level).These measures are expressed in billing currency and functional currency. Phase Contract Compensation in Billing Currency Phase Contract Compensation in Functional Currency Phase Contract Consultant Fee in Billing Currency Phase Contract Consultant Fee in Functional Currency Phase Contract Reimbursable Allowance in Billing Currency Phase Contract Reimbursable Allowance in Functional Currency Phase Contract Total Compensation in Billing Currency Phase Contract Total Compensation in Functional Currency The following measures are the contract amounts for each task for a project. The amounts are retrieved from the Compensation, Consultant Fee, Reimbursable Allowance, and Total fields in the Contracts grid on the Contract Management tab of the Project Info Center for a task (WBS 3 level).These measures are expressed in billing currency and functional currency. Task Contract Compensation in Billing Currency Task Contract Compensation in Functional Currency Task Contract Consultant Fee in Billing Currency Task Contract Consultant Fee in Functional Currency Task Contract Reimbursable Allowance in Billing Currency Task Contract Reimbursable Allowance in Functional Currency Task Contract Total Compensation in Billing Currency Task Contract Total Compensation in Functional Currency
	Phase Folder Measures: The following measures are the contract amounts for each phase for a project. These measures are retrieved from fields in the Contracts grid on the Contract Management tab of the Project Info Center for a project's phase (WBS 2 level): If you use the Multicurrency feature, these measures are expressed in the contract's project currency. Phase Contract Compensation Phase Contract Consultant Fee Phase Contract Reimbursable Allowance Phase Contract Total Compensation
	Project Folder Measures: The following measures are the contract amounts for each project. The measures are retrieved from fields in the Contracts grid on the Contract Management tab of the Project Info Center for a project (WBS 1 level):