Importing Currency Conversion Data
Instead of copying and pasting currency data into a currency conversion table, you can import currency data from supported data sources, and schedule updating of the currency data.
- Go to the Currency Conversion tab: select .
Or select
. - Select New Currency Conversion Table.
- Select New Currency Conversion Table.
- Provide a name for your table, and select Create.
- Save the empty table.
- Switch back to the Currency Conversion tab, and select the check box beside the empty table.
- Select Import Data.
- Choose one of the supported data sources; for example, Google Drive.
- Select the target currency table, and choose a file or data source to import the
currency data from.
For SAP BW, the Build SAP BW Query dialog appears. You'll need to include the Source Currency, Target Currency, Valid From Date, and Exchange Rate columns to import data into a currency table.
- Select OK or Create to import the
data.
The imported data appears in the data integration view, where you can map the imported columns to the currency conversion attributes: Source Currency, Target Currency, and so on.
- If necessary, you can also cleanse and prepare your currency data. For details, see Preparing Data.
- When your currency conversion table is finished, select Finish
Mapping.
The new table appears in the list on the Currency Conversion tab.
- Go to the Currency Conversion tab: select .
Or select
. - Select Import Currency Conversion Table From SAP BPC.
- Choose a BPC connection type, and select a BPC system from the list of
connections.NoteYou can create a new connection on the fly by selecting Create New Connection and following the instructions in Import Data Connection to an SAP BPC System.
- When importing a currency table from BPC, you are now only allowed to create a new query. The option Create a new query is selected by default. Select Next.
- Enter a name and description for the currency conversion table and choose Next.
- Specify the source BPC rate model by choosing the environment and model. Then name the query, and choose Next.
- In the Data Selection page, filter the source BPC dimension members to be imported for each dimension, and choose Next.
- In the Member Mapping page, map the source BPC rate account members and category members to the corresponding SAP Analytics Cloud rate type and version members, respectively.
- When you've finished mapping, select Finish.
The new conversion table is created. Save the table, and view it in the list on the Currency Conversion tab.
- Switch to the Currency Conversion tab.
Currency conversion tables that can be scheduled appear with a View More link in the Data sources column.
- Select the View More link for the table that you want to schedule.
- Point to the currency table that you want to schedule, and select View Schedule Detail.
- Choose schedule settings.
- Select .