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

c. To pick the second generation of the Market dimension, in the Member list box, select

Region, right-click, and select Add to Selection Rules. Alternatively, double-click Region

to add it to the selection rules.

Region is displayed in the Selection Rules list box.

d. To view the list of members that will be retrieved into the worksheet, in the Selection

Rules list box, select Region, right-click, and select Preview.

As shown in Figure 61, Essbase displays East, West, South, and Central, which are members

of generation two in Market, in the Member Selection Preview dialog box.

Figure 61 Generation Name Selection

e. Click Close to close the Member Selection Preview dialog box.

You have now defined a basic query. The outline of the query is displayed in the navigation

panel.

The next topic describes how to save this query.

Saving Queries

➤ To save a query in Essbase Query Designer:

1 In the navigation panel, select [Book1]Sheet1, Query1, and then right-click and select Save Query.

The Essbase Query Designer Save As Query dialog box is displayed, as shown in Figure 62. You

can save your query to the server or to your own client machine. To save to the server, you must

have a security level of database designer or higher. Contact the Essbase system administrator

for more information.

2 In the Location group box, select Client.

Basic Tutorial

1 2 ... 69 70 71 72 73 74 75 76 77 78 79 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 74