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

● A “Dimension being ranked” drop-down list box to specify the dimension to which ranking

should be applied.

● A “Column used for ranking” drop-down list box to specify the data column on which data

values are based.

● A “Data Restrictio ns ” list box to specify standard data comparison operations, su ch as greater

than, less than, and equal to.

You can apply the comparison operator to data values, including negative data values, in

one or more data columns; you can even apply criteria to compare values between two

columns.

● Buttons for OR and AND operators.

If you define more than one criterion for a column, you can use these operators to link the

criteria.

7 Select the Top check box, and enter a value of 30 in the Rows text box.

When you apply the query, Essbase retrieves the top thirty rows of the dimension.

8 From the Dimension being ranked drop-down list, select Product.

Product is the dimension to which ranking should be applied.

9 From the Column used for ranking drop-down list, select Qtr1, Actual.

Qtr1, Actual is the column on which data values are based.

10 In the navigation panel, select the Data Filtering icon. Right-click and select Apply Query.

Your query results should look like Figure 89.

Figure 89 Data Filtering Query Results

Advanced Tutorial

1 2 ... 91 92 93 94 95 96 97 98 99 100 101 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 96