Assigning Currency Names to Country Members

When preparing a main database outline for currency conversion, you must assign currency names to the country dimension and its members (for example, assigning dollars to the U.S., Euro to Germany, and so forth). Because many members can have the same currency name, the number of currency names is typically less than the total number of members in the dimension.

Assigning currency names to country members creates a member in the currency database for each individual currency. The top-level dimension member name in the country dimension should be given the currency name of the base currency (e.g., US$) to ensure that the base currency is inherited down the country dimension hierarchy. When the children of a given member share a single currency, you only need to define a currency name for the parent member.

  To assign currency names to members of a country dimension:

  1. If you have not already tagged a member as country, see Tagging a Country Dimension.

  2. Select the dimension tagged as Country, right-click and select Edit member properties.

  3. Select the Information tab and find the Currency name node.

  4. Specify a currency name for the country dimension; for example, US$.

  5. Repeat this procedure to define currency names for each appropriate member of the country dimension.

Related Information