Embed an EVALUATE_PREDICATE Function in a Filter

You can add an EVALUATE_PREDICATE function as an inline filter clause.

You can use this function when you can’t create the required inline filter clause with filter operators. Use this function only for SQL functions and for database functions with a return type of Boolean. You can’t use this function with hierarchical columns, XML data sources, and all multidimensional data sources. You need the Add EVALUATE_PREDICATE Function privilege granted by an administrator to embed this function in a filter.
  1. Open the analysis for editing.
  2. On the Filters pane of the Criteria tab, click More options and select Add EVALUATE_PREDICATE Function.
  3. Enter the function’s formula in the New EVALUATE_PREDICATE Function dialog.
  4. Click OK to add the EVALUATE_PREDICATE function in the Filters pane.

For example, you can add the following filter clause using an EVALUATE_PREDICATE function to exclude values with less than six letters in the Products.P4 Brand column.

SELECT
0 s_0,
"A - Sample Sales"."Products"."P3 LOB s_1, 
"A - Sample Sales"."Products"."P4 Brand" s_2,
"A - Sample Sales"."Base Facts"."1- Revenue" s_3
FROM "A - Sample Sales"
Where EVALUATE_PREDICATE('length(%1)>6',"A - Sample Sales"."Products"."P4 Brand").
ORDER BY 1,2,3