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

Creating Queries Using Essbase Query Designer

So far, you have discovered how to retrieve data and navigate through Spreadsheet Add-in in

an ad hoc fashion. Essbase also provides a query designer so that you can define a database query

for retrieving dimensions and database members into the worksheet.

Before Essbase actually retrieves data, Essbase Query Designer provides a series of panels so that

you can request the data that you want to view in the worksheet. It is particularly helpful when

you know exactly which data you want to retrieve from the server. In addition, you can save a

query and use it again.

The Essbase Query Designer window (shown in Figure 54 on page 69) consists of the following

panels:

● The navigation panel at the left of the window provides access to the various features in

Essbase Query Designer. You can display all the dimensions used in a particular query and

access the various properties of each dimension member.

● The hint panel at the top right of the window provides a brief description of the feature that

is selected from the navigation panel.

● The properties panel at the bottom right of the window provides access to the following

functions:

❍ Layout: Design the layout of the spreadsheet report. To change the default layout, select

a dimension tile and drag it to one of the other dimension boxes. To access the member

select panel and to define a member for a query, double-click a dimension tile.

❍ Member Select: Select members that you want to display in the rows of the spreadsheet

report. To select a member, right-click the member, and select Add to Selection Rules.

You can also double-click a member to add it to the selection rules.

❍ Member Filter: Filter the member selection by attribute, generation name, level name,

pattern string, or UDA.

❍ Data Filter: Retrieve rows of data. The retrieval is based on the ranking of the rows within

certain columns. Use this panel to access the data restriction panel.

❍ Data Restriction: Filter data by comparing it to a fixed data value (including a negative

value), a set of data values, or #Missing data values.

❍ Data Sort: Sort rows in ascending or descending order. The sort is based on column data

values.

❍ Messages and Confirmation: Turn on and turn off certain messages from Essbase Query

Designer.

❍ Help: Access documentation about Essbase Query Designer.

See “About Creating and Changing Queries” on page 68 for an overview of Essbase Query

Designer. The portions of the tutorial that follow step you through the following query design

procedures:

● “Creating Queries” on page 68

● “Saving Queries” on page 74

● “Applying Queries” on page 76

Creating Queries Using Essbase Query Designer

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 67