Importing Preconverted Actuals from a File

Import preconverted actuals from a file, and use them in a story.


For information about currency conversion, see Currency.


  1. Create a new model from an existing data file; for example an Excel worksheet.
    The data should not yet contain preconverted actuals, because the model is not yet configured to accept preconverted actuals. If the Excel worksheet contains a column of preconverted actuals data, temporarily delete that column before importing the file.

    Creating a Model from a File

  2. During data integration, before saving your model, select Enable Planning if you want the option to add Currency Conversion later, in stories.
  3. Select Create Model before doing any mapping.
  4. Switch to the Model view.
  5. Select (Delete Facts), select all members, and then select OK.
    This temporarily clears the model data so that you can switch on currency conversion.
  6. Select the dimension that separates the data into different currencies, and then in the Dimension Settings panel, under System Properties, switch on Enable Currency.
    For example, this dimension could be an Organization dimension, or a generic Source Currency dimension. For more information, see Dimension Settings.
  7. Open the model preferences, and on the Currency tab, switch Currency Conversion ON.
    You can change this setting only when no data is loaded into the model.
  8. Set the model's Default Currency.
    Choose the currency that your preconverted actuals have been converted to.
  9. Choose a currency rates table.
  10. Switch Preconverted Actuals ON, and select OK.
  11. Select the Account dimension, and choose values for the Account Type, Rate Type, and Units & Currencies properties, for all members in the dimension.
    Set the value for Units & Currencies to Currency.
    If you have many members in the Account dimension, it can be impractical to set the Currency value for each member individually.

    An alternative method is to prepare your data file by adding Account Type, Rate Type, and Units & Currencies columns in your file, and then when you import the file, map those columns to the Account dimension. As long as the Update dimension with new values mapping option is selected (it's selected by default when importing data), you can load those values for all members at once. For more information, see Preparing Data.

  12. Select the Organization dimension, and fill in the values for the Currency property for all members in the dimension.
  13. Save the model.
  14. Import the data from the file again.
    Choose the data file that contains the preconverted currency data.
  15. Select the imported data from the Draft Sources list, and map the data to the model's dimensions.

    First, map the account dimension (must be actuals). After you've mapped the account dimension, the Measures card can be expanded to two cards: Local Currency (also known as source currency) and Default Currency. Drag the preconverted actuals data to the Default Currency card, and the standard measure data to the Local Currency card.

    See Preparing Data for details on mapping data.

  16. Select Finish Mapping, and then save your model.
    After creating the model, you'll typically create a story with a table to include the preconverted actuals.
  17. From the () Main Menu, select Start of the navigation path Create Next navigation step  StoryEnd of the navigation path.
  18. Add a canvas to the story, and add a table to the canvas.
  19. Choose your new model as the data source for the table, and select OK.
  20. Select the table, and then open the (Builder) panel.
  21. Under Start of the navigation pathTable Structure Next navigation step ColumnsEnd of the navigation path, select Add Measures/Dimensions.
  22. Select Cross Calculations.
  23. Point to the calculation you just added, and select (Manage Filters).
  24. In the Available Members list, you can select both the source currency and preconverted data members to include both in your table.