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

Figure 125 Typing Member Names In a Free-Form Report

7 Select Essbase > Retrieve.

Essbase retrieves data for the members and creates a default view according to the location of

the labels. Note that in Figure 126, three members were pivoted from row groups to column

groups.

Figure 126 Result of Retrieving in Free-Form Retrieval Mode

8 Select File > Close to close the worksheet.

You do not need to save the worksheet.

➤ To create a report by entering member names and a report script command:

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

2 Enter the member names into the blank worksheet as shown in Figure 127.

Figure 127 Typing Member Names in a Free-Form Report

3 In cell A3, type <IDESCENDANTS Product and press Enter.

Figure 128 Typing a Report Script Command in a Free-Form Report

4 Select Essbase > Retrieve.

Essbase retrieves data into the worksheet for all descendants of Product and for the members

that you entered in the worksheet. The result is shown in Figure 129.

126

Advanced Tutorial

1 2 ... 121 122 123 124 125 126 127 128 129 130 131 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 126