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

Connecting to the Sample Currency Databases

To complete the following exercises, the Sample Interntl and Sample Xchgrate databases must

be installed on the server. Contact the Essbase system administrator if these application and

database pairs are unavailable.

➤ To retrieve data from the Sample Interntl database:

1 Select Essbase > Connect.

2 Select the Sample Interntl database and click OK to complete the connection.

The Essbase installation also includes sample spreadsheet files that illustrate currency conversion

concepts.

3 From the \AnalyticServices\client\sample directory, open Local.xls.

The worksheet contains actual (Act) and budget (Bud) data entered in local currencies for New

York and Germany, as shown in Figure 166.

Figure 166 Retrieving Local Data

4 From the \AnalyticServices\client\sample directory, open Convert.xls.

5 Select Essbase > Retrieve.

The worksheet contains values for Actual and Budget as they are displayed after conversion.

Figure 167 Retrieving Converted Data Values

156

Advanced Tutorial

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 156