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

To delete a particular data restriction, select the data restriction in the query outline, right-click,

and select Delete Data Restriction. Alternatively, select the data restriction in the Data Restriction

box, right-click, and select Delete Data Restriction.

Sorting Data

In the data sort panel, you can sort the output from the Basic1 query in ascending or descending

order.

➤ To sort the query:

1 From the navigation panel, select the Data Sorting icon.

As shown in Figure 92, the data sorting settings are displayed in the properties panel. You can

specify data sorting criteria that affect the order in which the selected rows are retrieved in the

data sorting panel.

The data sorting panel contains the following items:

● A “Dimension being sorted” drop-down list box that lists the dimensions specified in row

format in the query.

● A “Column used for sort” drop-down list box where you select one or more dimensions to

be specified in column format in the query.

● An Ordering drop-down list box where you apply an ascending or descending sort order

for the selected column.

You can also specify sorting to occur over a specific row dimension group. For example, you

can sort by Product or by Market.

Figure 92 Data Sorting Panel

2 Double-click on the statement (double click to create a new sort rule).

Performing Advanced Retrieval Tasks

1 2 ... 94 95 96 97 98 99 100 101 102 103 104 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 99