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

Figure 68 Results of Query with Options Applied

5 Select File > Close to close the worksheet.

You do not need to save the worksheet.

Selecting Members

An Essbase database may contain hundreds or even thousands of members, making it difficult

to remember each member name. You can use the Essbase Member Selection dialog box to find

and select members and to define the layout of members in the worksheet. In addition, you can

use Boolean operators, such as AND, OR, and NOT, or other search parameters to specify criteria

and conditions that members must meet for the member selection. Member selection is an

important method of creating a spreadsheet report for the data that you want to retrieve.

For complete information on the Essbase Member Selection dialog box, see the Spreadsheet

Add-in online help.

➤ To view specific members from the Product dimension:

1 Select File > New or click to open a new worksheet,

Note:

You should be connected to the Sample Basic database. If you are not connected, follow the steps

in “Connecting to a Database” on page 33.

2 Select Essbase > Retrieve.

3 Select Product and select Essbase > Pivot to display Product as a row, rather than a column, dimension.

Figure 69 Initial Worksheet for Member Selection

Basic Tutorial

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 80