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

● “Deleting Queries” on page 77

● “Viewing Messages and Confirmations” on page 77

● “Accessing Help” on page 78

Note:

Excel query functionality is not supported in Spreadsheet Add-in. Use the Essbase Query

Designer to define database queries.

About Creating and Changing Queries

To access any of the Essbase Query Designer panels, select the appropriate feature listed in the

navigation panel.

As you create a query or make changes to an existing query, the changes are reflected in the

navigation panel. To view a dimension or a member of an open query, click on the specific

dimension or member in the query outline that is displayed in the navigation panel. Selected

members are displayed in the member selection panel on the right.

You can also revise an existing query in the member selection panel. For example, you can delete

a member or add a member to the query by selecting a member in the navigation panel and

making the appropriate changes in the properties panel.

Note:

Files created using the obsolete Retrieval Wizard feature can be opened in Essbase Query

Designer. If, however, a query contains more than two member filters per selection rule or more

than two data restrictions, the member filters may be out of order. To ensure correct results,

rearrange the member filters in the navigation panel, if necessary.

For complete information on Essbase Query Designer options, see the Spreadsheet Add-in online

help.

Caution!

Manipulation of worksheets in VBA such as naming worksheets or moving worksheets may not

work when EQD is running.

Creating Queries

➤ To create a query using Essbase Query Designer:

1 Select Essbase > Query Designer.

Essbase displays the Essbase Query Designer welcome panel, as shown in Figure 54.

Basic Tutorial

1 2 ... 63 64 65 66 67 68 69 70 71 72 73 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 68