Updating the Data Load Mappings of the Member Name and Base Currency Dimensions
To set up your application to work with a single currency, update the data load mappings for the Member Name and Base Currency dimensions. Make these updates in the following data load rules:
-
MD_Currency
-
MD_Subsid
For these data load rules, update the existing Like mapping and create a new Explicit mapping for your base currency.
To update the data load mappings of the Member Name and Base Currency dimensions:
-
Click the Navigator icon
, and under Integration, click Data Management.
-
The Data Management window opens. Click the Workflow tab, and then under Data Load, click Data Load Mapping.
-
To define the data load mappings for MD_Currency, in the POV bar, click the link next to Location.
The Select Point of View window opens.
-
In the Location field, enter MD_Currency, and then click OK.
-
From the Dimensions list, select Member Name.
-
Click the Like tab.
-
To update the existing mapping, in the Target Value field, delete the existing value and enter Ignore.
-
Click the Explicit tab.
-
Click Add.
-
In the new row, enter your base currency's three-letter currency code in the Source Value and Target Value fields. For example, if your base currency is USD, enter USD in both fields.
-
Click Save.
-
-
To define the data load mapping for MD_Subsid, in the POV bar, click the link next to Location.
The Select Point of View window appears.
-
In the Location field, enter MD_Subsid, and then click OK.
-
From the Dimensions list, change the value to Base Currency.
-
Repeat steps 3c – 3h.
-