Creating Currencies

You can create members in the Currency dimension for each currency needed in your application.

Select from a predefined list or create your own. You can specify:

The three-letter code
The symbol
A description of up to 256 characters
The scaling factor to use when values are displayed
The alias table to use to display aliases
Number formatting, including thousands separator, decimal separator, negative sign, and color
Whether it is a reporting currency

Note:

The Triangulation currency to use for currency conversion is set from the application currency.

To create currencies:

Click the Navigator icon .
Under Create and Manage, click Dimensions.
Select Currency.
Click Add.
From Create Currency:
- To add a predefined currency, select Select standard Currencies.
- To create a currency, select Create new currency and specify properties:
  - For Code, enter an abbreviation or identifier of up to three characters.
  - Optional: For Description, enter a name, such as Japanese yen.
  - For Symbol, enter a symbol or select a symbol from the list.
  - Optional: For Scale, select how to enter and display the currency. For example, 3 yen represents 3000 yen if scaling is set to thousands.
  - Optional: For Alias Table, select the alias table to use.
  - Optional: For Alias, enter a name for the currency alias.
Optional: Select Reporting Currency.
Optional: For Thousands Separator, select how to display the thousands separator (it must differ from the decimal separator).
Optional: For Decimal Separator, select how to display numbers with decimal values (it must differ from the thousands separator).
Optional: For Negative Sign, select how to display negative numbers:
- Prefixed minus: -1000.
- Suffixed minus: 1000-
- Parentheses: (1000)
Optional: For Negative Color, select the display color.
Optional: Select the type of Data Storage.
Optional: Select Two Pass Calculation.
Optional: Select the Data Type.
Optional: Select a Smart List.
Click Save.