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

Figure 94 Result of Filtering and Sorting Data

Note:

The values that you are ranking and sorting must be the same. For example, you cannot specify

Product in the “Dimension being ranked” drop-down list box and Market in the “Dimension

being sorted” drop-down list box. If you specify different values, Essbase Query Designer

automatically changes both values to the last specified value.

10 To close the worksheet, select File > Close.

You do not need to save the worksheet.

Retrieving Data into Asymmetric Reports

When you retrieve data into a worksheet, the resulting report can be either symmetric or

asymmetric. Symmetric reports are characterized by repeating identical groups of members. For

example, Figure 94 on page 101 shows a symmetric report that contains Actual and Budget

members nested below Year members (Qtr1, Qtr2, Qtr3, and Qtr4).

An asymmetric report is characterized by groups of nested members that differ by at least one

member. There can be a difference in the number of members or in the names of members.

You can create asymmetric reports in one of the following ways:

● Enter member names into the worksheet in free-form retrieval mode.

● Use a drill action with the Within Selected Group option selected from the Zoom tab of the

Essbase Options dialog box.

● Suppress rows that contain missing values, zero values, or underscore characters during data

retrievals.

Performing Advanced Retrieval Tasks

101

1 2 ... 96 97 98 99 100 101 102 103 104 105 106 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 101