Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Installation and Configuration Guide > Siebel Analytical Applications Metadata > Metadata Requirements for Sales Analytics Applications >

Currency Conversion

---

In order to facilitate real-time analysis, Siebel Sales Analytics provides for currency conversion for all data from the relational database. This allows users to see all metrics in a single currency, and facilitating meaningful aggregation and comparison of all revenue-based metrics. The system converts all currencies into the default currency used by the Siebel Data Warehouse, so that data from the relational database can be meaningfully compared to data coming from the data warehouse.

NOTE:  The system administrator must work with the business analysts to determine the appropriate currency conversion.

Accurate currency conversion requires that the currency to be converted have two attributes:

• A currency code that represents its current currency
• A conversion date that represents the date for which the currency is to be converted

Any revenue information that lacks one of these attributes will be converted using ETL Unknown Exchange Rate. In the standard product, this Initialization Block variable is defined as 1, meaning that unknown currencies are not converted. It is recommended that you use 1 or 0 for this variable so that currencies with unknown current currencies or conversion dates are not converted (ETL Unknown Exchange Rate = 1) or are ignored (ETL Unknown Exchange Rate = 0).

Bookshelf Home | Contents | Index | Search | PDF