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

2. Select Essbase > Options.

3. In the Essbase Options dialog box, select the Zoom tab.

4. In the Sampling Percentage text box, type an integer between 1 and 100 to represent the approximate percentage

amount of the Essbase cube to query during a Zoom In operation.

The default value is 100.

Note: If Hybrid Analysis is enabled and in use, the sampling percentage also applies to queries on the underlying

relational database.

5. Click OK to save the sampling percentage integer that you entered and any other Zoom options that you have set.

The Essbase Options dialog box is closed and you are returned to the spreadsheet.

6. In the spreadsheet, select the member on which you want to drill down.

7. Select Essbase > Zoom In or double-click the primary mouse button.

For example, if you typed 50 in the Sampling Percentage text box, approximately 50 percent of the members

from your Essbase database and, if applicable, from the specified columns of the relational database are

queried when you select Essbase > Zoom In.

Notes on Sampling

● When drilling down on Hybrid Analysis, the following limitations apply:

❍ Sampling with the All Levels option is not supported with Hybrid Analysis members.

❍ Sampling with Same Level and Same Generation options are not supported.

● When sampling is enabled, a combination of the algorithms used by Essbase and the

sampling percentage you set sometimes makes the following scenarios possible:

❍ During a Zoom In operation, no members are retrieved. This can happen in some cases

where a dimension is small.

❍ During a Zoom In operation, all members are retrieved. This can happen in some cases

where the sampling percentage is very small.

Working with Formatted Worksheets

In addition to providing flexible, ad hoc retrievals, Essbase supports retrieving data into

formatted worksheets. A worksheet can contain the following formats:

● Spaces between rows and columns

● Cell values that contain text or data that is not defined in the database outline

● Member names in noncontiguous locations at the top of a worksheet

● Spreadsheet formulas (see also “Preserving Formulas When Retrieving Data” on page

109)

● Visual cues (styles)

After you format and save a worksheet, you may want to retrieve and navigate through new data

in the existing worksheet format. These topics provide the following information on working

with formatted worksheets:

● “Observing the Rules for Working with Formatted Worksheets” on page 105

104

Advanced Tutorial

1 2 ... 99 100 101 102 103 104 105 106 107 108 109 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 104