7. Field selection to sort the query.

In this section you can specify how you want to order the database query. It isn't necessary to order the data for the cube creation, but you can order the data for the See data dialog in section Optional modification of generated Sql .

Use the following buttons to:

• Add : Let's you add a field to sort the query. The dialog  Select fields appear.
• Remove: select a field from the list and press this button to remove it.
• U: Permit you  rise one registration according to where being positioned.
• D: Permit you  descend one registration according to where being positioned.
• Back: If you choose this button you will return to the previous page.
• Next: If you choose this button you will advance to the next page.

The information shown in the list of fields is the same as shown in section Select fields from database , so it will not be explained here.

If you decide to order your query with a field that uses the aggregate function, the sort will be made by the field, but without the aggregation function, so maybe the sort won't bring the records in the way you expect. You can use the dialogo See data to order your query output by the field that you want.

Press the Next button to proceed to section 8. Optional modification of generated Sql .

Press the Back button to go to section  6. Search criteria creation.