Insert Filter dialog

Use this dialog to add a SQL FILTER function to a column formula in the "Edit Column Formula dialog: Column Formula tab".

For more information, see:

• "Editing the Formula for a Column"

Components

Filter Function Area

Displays the SQL function in the form:

FILTER(expr USING filter_expressions)

Where:

• expr is an expression that contains at least one measure column. For example, the expression "sales + 1" is allowed if "sales" is a measure column. The expression "productid" is not allowed if "productid" is a scalar attribute.

• filter_expressions is a Boolean expression (evaluates to TRUE or FALSE) and does not contain any measure columns. Also, this expression cannot contain any nested queries.

  
  

  Note: If you selected some text in the Formula area before clicking Filter, then it is incorporated in the inserted SQL function, replacing the expression token (expr). For example, if you had selected "Sales Measures".Dollars before clicking Filter, then the SQL function would look like this: FILTER("Sales Measures"."Dollars" USING filter_expressions). A complex filter statement might replace the filter_expressions token as follows: FILTER("Sales Measures".Dollars USING ((Periods."Year" = '1999') AND ((Markets.District = 'CINCINNATI DISTRICT") OR (Markets.District = 'DENVER DISTRICT'))))

  
  

Use this area to define filter_expressions by adding a single filter expression or building a complex filter statement using multiple filter expressions.

For each filter expression to add, select a column from the Subject Areas pane. The "New Filter dialog" is displayed where you create the filter to add to the filter expression.

As you define the filter_expressions, you can use the following:

• Operator to toggle between AND and OR to specify the relationship between multiple filter expressions.

• Filter item toolbar to manage a filter expression. The filter item toolbar is the collection of buttons that displays when you mouse over a filter expression. It includes the following buttons:

  • Edit Filter — Use this button to display the "Edit Filter dialog", where you edit the filter expression's criteria.

  • Copy Filter — Use this button to copy the filter expression. When you click this button, a copy of the filter expression is displayed below the original filter expression.

  • Delete— Use this button to delete the filter expression.

Subject Areas

Use the "Subject Areas pane" to select columns to add to the filter expression.

Catalog

Use the "Catalog pane" to select filters from the catalog to add to the filter expression.