Arrow Storage Products EN106 Guia do Utilizador descarregar pdf (Página 155)

Working with Currency Conversions

Organizations with offices in different countries generally do business in the currency of the host

country (known as the local currency). Such organizations must convert data entered in local

currencies to a common currency for consolidation and analysis.

The Essbase Currency Conversion product can be purchased separately for Essbase. If your

organization purchased this product and implemented a currency conversion application, you

can take advantage of the capabilities of Essbase Currency Conversion. The Hyperion Essbase -

System 9 Database Administrator's Guide describes how to design and implement a currency

conversion application.

The following topics provide a brief tutorial for working with currency conversions:

● “Retrieving Currency Conversion Data” on page 155

● “Connecting to the Sample Currency Databases” on page 156

● “Performing Ad Hoc Currency Reporting” on page 157

Retrieving Currency Conversion Data

This topic focuses on basic currency conversion concepts, including the Currency Report

command.

A currency conversion application consists of two databases:

● A main database that contains data in local and converted values

● A currency rates database that contains exchange rates

Apply exchange rates from the currency rates database to local values from the main database

to derive converted values. The Essbase Server product installation includes a sample currency

conversion application (installation options) that consists of two sample databases: a main

database called Interntl and a currency rates database called Xchgrate.

The Sample Interntl database consists of five dimensions: Year, Measures, Product, Market, and

Scenario. All but the Market and Scenario dimensions are identical to the Sample Basic database.

The Market dimension includes Toronto, Vancouver, Montreal, Germany, Sweden,

Switzerland, and the UK. The Scenario dimension handles different currency types (such as

Actual and Budget) in both local and converted currencies. In this database, all local currencies

are converted to the common currency of U.S. dollars.

The Sample Xchgrate database, which is a subset of the main database, contains four dimensions:

● The CurTime dimension accommodates different exchange rates by month.

● The CurName dimension contains names of currencies from their respective markets.

● The CurCategory dimension contains the names of the various currency categories that may

be applied to the categories of Measures. For example, one rate is applied to Profit and Loss

items and another rate is applied to Balance Sheet items.

● The CurType dimension enables a currency database to contain rates for different scenarios,

such as Actual and Budget.

Working with Currency Conversions

155

1 2 ... 150 151 152 153 154 155 156 157 158 159 160 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 155