Rate Set
The Rate Set dimension members identify groups of exchange rates such as Actual exchange rates. All applications must include a Rate Set member named Untranslated with an ID of 0 to indicate reported, untranslated data. This member is included in the starter database. It must be added to shell databases.
| Property or Attribute | Required | Required by the Import Wizard when Adding Members | Required by the Import Wizard when Updating Members | Notes | Default set by Import Wizard if value is missing from import file |
|---|---|---|---|---|---|
| ID | Required | Optional | Required (if Name not provided) | A member named Untranslated with an ID of 0 must be defined. | The ID is automatically generated if not included. |
| Name | Required | Required | Required (if ID not provided) | The name can have up to 40 characters. Must be unique within the dimension. | No default. User must supply. |
| Description | Optional | Optional | Optional | The description can have up to 255 characters. | If not specified, defaults to the name. |
The minimum format to add members to this dimension is:
- Name
- Untranslated
- Actual Rate
- Budget Rate
- Best Case Scenario
- Worst Case Scenario