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

Figure 131 Result of Using Attributes in Free-Form Reports

4 You can drill down to data on the level 0 attribute members of the Caffeinated attribute dimension. The

results should look like Figure 132.

Figure 132 Drilling Down on Attributes in Free-Form Reports

5 To drill down further for data on profits for the first quarter for all members of the East base dimension,

double-click cell E1. The results should look like Figure 133.

Figure 133 Result of Drilling Down on East

Entering Generation and Level Names

In addition to entering database member names into a free-form report, you can enter generation

or level names directly into a worksheet to retrieve specific members. The Essbase application

designer defines generation and level names for database dimensions in the database outline.

Two options enable you to determine which generation and level names are defined in the

database:

● View generation and level names in the Essbase Member Selection dialog box or through

Essbase Query Designer.

● Contact the Essbase application designer to see which generation and level names are defined

in the database outline.

➤ To enter generation and level names directly into a free-form report:

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

128

Advanced Tutorial

1 2 ... 123 124 125 126 127 128 129 130 131 132 133 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 128