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

Note:

The book may be a number other than 1. For example, it may be [Book5], if four worksheets

are already open.

4 Type your password, and click OK. Select Sample Basic, and click OK.

5 Select [Book1]Sheet2 (or Sheet3), right-click, and select Connect.

The Essbase System Login dialog box is displayed.

6 Type your password, and click OK. Select Samppart Company, and click OK.

Note:

You are restricted to one connection per worksheet. The connection information is displayed

in the query information panel of the Essbase Query Designer only when you open an existing

query or create a new query.

7 Select [Book1]Sheet1, right click, and select New > Query to create a new query based on Sample Basic.

8 Select [Book1]Sheet2, right-click, and select New > Query to create a new query based on Samppart

Company,

9 To open an existing query, right click, and select Open Query.

You are now ready to create queries or to open existing queries.

Applying Worksheet Options to Essbase Query Designer

Results

You can apply any of the worksheet options that you previously set from the Essbase Options

dialog box to the results of a query created in Essbase Query Designer.

➤ To enable Essbase Query Designer to use your previously set worksheet options:

1 Select Essbase > Options.

2 In the Essbase Options dialog box, select the Display tab.

3 Select the Use Sheet Options with Query Designer check box, and select OK.

4 Select Essbase > Retrieve to refresh the worksheet.

Essbase displays the results of the query that you created in Essbase Query Designer and

implements your previously set worksheet options. For example, in Figure 68, aliases, instead

of the numeric codes, are now displayed for the Product dimension.

Creating Queries Using Essbase Query Designer

1 2 ... 74 75 76 77 78 79 80 81 82 83 84 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 79