SAC analytic models can easily handle most currency scenarios without a separate currency dimension by using the model and story currency conversion measures.
New Models users can enable a currency variable in the model preferences to set a default target currency for conversions measures.
- Flat files
- BPC rate models
- BW Queries
SAC Currency Translation - Key Points
- Exchange rates are stored in the SAC currency translation table.
- Exchange rates originate from financial institutions and are automatically or manually updated into SAC.
- Currency use case examples include:
- Display corporate (group) and local operating currencies in stories.
- Import and Plan in local currency and immediately translate to group currency.
- Translate with category-specific exchange rates.
- Import both local and group currency actual values.
- Analyze trends in constant currency.
The term Local Currency (LC) refers to the functional or operating currency of a company, for example. A company in the US has an LC of USD, and so on.
The term Group Currency refers to the corporate level currency. A company in the US that has a German parent therefore has a group currency of EUR, for example.
The term Translation is being used interchangeably with conversion.
The concepts in this lesson concern planning concepts only, not month-end closing currency translation.
Displaying the local currency (property) in the columns is optional.
In the figure entitled Currency Translation Results in a Story, the new model is demonstrated. You can access the example above in the U00S_Currency story in the SACP20 → Solutions folder.
The Booking Date, for example, is determined through the date dimension (specified in the currency setting) in the model.
If a currency conversion is added and there are no exchange rates, the system will direct you to the currency table (to add the missing rates).