Salesforce Docs Portal

Create a Semantic Model with a Currency Field

Create a semantic model with a currency field to convert the values into the corporate currency. To preserve the original value of the measure before conversion, clone the Currency field as a Number data type field.

Required Editions

Available in: All editions supported by Data 360. See Data 360 edition availability.
User Permissions Needed
To create a semantic model with a currency field:

Permission set:

  • Data Cloud Architect

AND

Semantic Models object
  1. In Data Cloud, on the Semantic Layer tab, create a semantic model.
  2. In the Select Data Objects for Semantic Model window, select the data model object that contains a field of type Currency.
  3. Under Field Name, select the currency field that you want to add.
    A Currency ISO Code field that matches the currency is selected automatically.
  4. Click Create.
  5. To view the field's original value (unconverted currency), select the currency field, then from the options menu, select Clone as Original Value.
    A new field appears with the suffix "(Original)", showing the unconverted value as a Number data type.