Multi-Currency Conversion Rate Tables reference data

Edit online

The tasks below can only be performed by users assigned to the Admin or Budget Process Owner roles. For additional information on roles, see Frontdoor permissions and roles.

Dimensions are the essential data categories in budget line items. Many built-in dimensions have dependencies on other dimensions (see Reference data attribute and dimensions dependencies for more information). You can import dimensions reference data from a .csv file or from Costing Standard and export dimensions reference data templates and table data (see Manage dimensions).

Watch this video from Apptio Education Services: Configuring Reference Data: Multi-Currency Dimensions.

Or see all Apptio planning video and training resources

Manage Actuals Currency Rate reference data

Actuals Currency Rate reference data defines the currency conversion rates used to convert multiple currencies to a common currency. This allows you to see summarized views of actuals.

  1. Enable support for multiple currencies in the Company Profile (see Edit the Company Profile).
  2. In the navigation menu, select Configuration > Reference Data.
  3. In the Standard Dimensions table, select Actuals Currency Rate.
  4. Select > Export.
  5. In the Export file window, under Format options, you can change the format of the exported data.
  6. Select Export.

    The reference data is exported as a .csv file.

  7. Open and edit the exported .csv file.

    Do not change the column headings or data structure of the file.

    The From Currency column should contain the tenant currency code.

    The Effective From column should use the YYYY-MM-DD or MM-DD-YYYY date format.

  8. Save the file in the .csv format.
  9. Now, select Configuration > Reference Data > Actuals Currency Rate. Then, select> Import.
  10. Drag and drop the file with the data onto the highlighted area of the Import File window.
  11. Select Import.
  12. To publish the changes, select > Publish > Publish.
  13. To cancel the changes, select > Revert > Revert.

Manage Plan Currency Rate reference data

Plan Currency Rate reference data defines the currency conversion rates used to convert multiple currencies to a common currency in budget plans and forecasts.

  1. Enable support for multiple currencies in the Company Profile (see Edit the Company Profile).
  2. In the navigation menu, select Configuration > Reference Data.
  3. In the Standard Dimensions table, select Plan Currency Rate.
  4. Select > Export.
  5. In the Export file window, under Format options, you can change the format of the exported data.
  6. Select Export.

    The reference data is exported.

  7. Update the file as required.

    The From Currency column should contain the tenant currency code.

    The Effective From column should use the YYYY-MM-DD date format.

  8. Now, select Configuration > Reference Data > Plan Currency Rate. Then, select> Import.
  9. Drag and drop the file with the data onto the highlighted area of the Import File window.
  10. Select Import.
  11. To publish the changes, select > Publish > Publish.
  12. To cancel the changes, select > Revert > Revert.