Database Reference
In-Depth Information
Why could this pattern be wrong? It might be correct in some cases, but it might be
wrong for a variety of reasons. For example, the date used to link the exchange rate
value to a transaction might not be the right one because the date of payment is not
recorded in the transaction itself. In another example, if the payment has been made
to a foreign currency bank account, the conversion to a different currency should be
made using a fixed exchange rate instead of a daily changing exchange rate.
Therefore, before making any decisions on how to implement currency conversion,
it is necessary to have very good and detailed business specifications. When they are
not available, sit down with a business user who has the necessary knowledge of the
data and work through the issues with him or her.
More often than not, decisions about currency conversion
are not technical issues but business decisions.
After we defined the requirements for currency conversion, we probably might find
that they resemble one of the following three scenarios:
Data is collected in a single currency and we need to display the results
using multiple currencies. For example, a company has a list price defined
using Euros and they want to show a product catalog on the Web using
different currencies.
Data is collected in several different currencies and we always need
to display the results using just one currency. For example, different
subsidiaries of a company operate in different countries using different
currencies, but all data must be converted into a reference currency for
reporting at the company's headquarters.
Data is collected in several different currencies and we need to display the
results using multiple currencies. For example, an international corporation
wants to publish balance sheets of its various subsidiaries on its intranet, and
allow users to select the currency to be used to show the data.
We will describe these scenarios in more detail and provide guidance on the use of
currency conversion related features in Analysis Services.
 
Search WWH ::




Custom Search