BI Composer wizard -- Create Analysis: Sort and Filter panel

Use this panel of the "BI Composer wizard" to:

Specify sorting for the results that are displayed in graphs, pivot tables, and tables. You can sort attribute and measure columns. You cannot sort hierarchical columns. For more information on the types of columns, see "What Are the Types of Columns?"
Create filters on attribute and measure columns. You cannot create filters on hierarchical columns.

For more information on filters, see "What are Filters and Selection Steps?"
Preview results.

For more information, see:

This panel is also displayed as:

Edit Analysis Analysis_Name: Sort and Filter panel

Components

Expand Sort or Collapse Sort

Use this button to expand or collapse the Sort area.

Sort

Use this area to specify and manage sorting. This area contains the follow components:

Add Sort — Use this button to select the column on which to specify a sort order and to add a sort order entry to the Sort table.
Sort Table — Displays an entry for each column that is to be sorted. You manage each entry as follows:
- To specify the sort order, click a sort order option, for example, Ascending, or Low to High.
- To prioritize the sort entries, use the up and down arrows to reorder the entries in the table.
- To delete an entry, click Delete.

Expand Filter or Collapse Filter

Use this button to expand or collapse the Filter area.

Filter

Use this area to specify and manage filters. This area contains the follow components:

Add Filter — Use this button to select the column on which to filter and to add a filter entry to the Filter table. When selecting the column on which to filter you can select one of the columns in the analysis or one of these options:
- More Columns — Use this option to display the Select Column dialog, where you select a column from the same subject area as the columns in the analysis but is not included in the analysis.
- Saved Filters — Use this option to display the Saved Filters dialog, where you can select a filter that has been saved to the catalog.
Show — Use this box to select one of the following options to combine filters:
- Data Satisfying All Filters — Use this option to specify that the criteria specified in each filter must be met.
- Data Satisfying Any Filter — Use this option to specify that the criteria that is specified in at least one of the column filters must be met.
Filters Table — Displays an entry for each column that is to be filtered. You manage each entry as follows:
- To specify the operator for the filter, select the operator in the Operator box. The operator list from which you can select is populated based on the type of column. For more information about each operator, including the is prompted operator option, see "Operators."
- To specify one or more values to use when applying the filters, enter or select the value or values in the Value field. Use a semicolon to separate multiple values.
  
  You can use the Search button (available only for certain operators) to display the "Select Values dialog," where you can search for a value. (Note that this version of the Select Values dialog contains only a limited number of the components of the standard version.)
- To delete an entry, click Delete.
Saved Filters Table —Displays an entry for each saved filter that you added using the Save Filters option. You manage each entry as follows:
- To delete an entry, click Delete.

Preview

Use this box to specify whether to display a preview of the results:

Select this box to display a preview of the actual analysis and data.

Note:

Selecting this box might impact performance if the query for data results in very large data sets.
Deselect this box to display an image that represents each view in the analysis.

Show how results will look on a dashboard

Use this button to show a fully interactive view where you can page through large result sets, drill, and so on.

Report XML

Use this button to show the XML code for the analysis. This information is helpful for debugging purposes.