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

In both retrieval modes, enter member names directly into the worksheet. The following sections

describe the similarities and differences between the two modes.

Using Advanced Interpretation Mode

Essbase Server server contains an advanced spreadsheet interpretation engine that scans a

worksheet and interprets its content when fulfilling retrieval requests. When you construct a

report by entering names directly into a worksheet in Advanced Interpretation retrieval mode,

Essbase interprets the member names and creates a default view that is based on the location of

the labels.

Keep in mind the following guidelines when you are working in Advanced Interpretation mode:

● Precede all member names that consist of numbers with a single quotation mark. For

example, for Product dimension member 100, type '100 in the worksheet.

● If you define a report that does not contain all the database dimensions, you may need to

enter a dummy value, such as 0, in the first data cell. Essbase overwrites this value with the

contents of the database cell upon retrieval. Be sure to use a numeric value as the dummy

value.

➤ To construct a free-form report in Advanced Interpretation retrieval mode:

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

2 Select Essbase > Options and select the Mode tab.

3 In the Retrieval option group, select Advanced Interpretation (the default setting) and click OK.

4 Enter member names and data as shown in Figure 121.

Note:

If a member name consists of a number, such as 100, you must precede the member name with

a single quotation mark (for example, '100). This rule also applies to member names with spaces

between words.

Figure 121 Creating a New Free-Form Report

5 Select Essbase > Retrieve or double-click a data cell.

Essbase retrieves data for the members that you entered into the free-form report and

implements the Use Aliases option that you set in the Essbase Options dialog box in “Setting

Essbase Options” on page 91.

Performing Advanced Retrieval Tasks

123

1 2 ... 118 119 120 121 122 123 124 125 126 127 128 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 123