Working with the EVALUATE_PREDICATE Function

How Can I Use the EVALUATE_PREDICATE Function with a Filter?

You can add an EVALUATE_PREDICATE function as an inline filter clause. You cannot use this function with hierarchical columns. Use this function when you cannot create the appropriate filter clause with the Oracle BI EE filter operators. This function is intended for database functions with a return type of Boolean, and can be used only for SQL functions. Support for EVALUATE_PREDICATE does not extend across all multidimensional data sources. Also, you cannot use EVALUATE_PREDICATE with XML data sources.

To add an EVALUATE_PREDICATE function as an inline filter clause, you must have been granted the Add EVALUATE_PREDICATE Function privilege by the administrator.

Example

The following is an example of how you can use the EVALUATE_PREDICATE function. This example requests that Products.P4 Brand values be greater than 6 characters. After it is run, this example returns any rows where the length of the data in the P4 Brand column is greater than 6 characters (for example, "BizTech" and "HomeView").

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

Adding the EVALUATE_PREDICATE Function to an Inline Filter

Use the following procedure to add the EVALUATE_PREDICATE function to an inline filter. Note that you cannot use this function with hierarchical columns. For more information see "How Can I Use the EVALUATE_PREDICATE Function with a Filter?" and "EVALUATE_PREDICATE."

To add the EVALUATE_PREDICATE function to an inline filter:

1. Go to the Analysis Editor's "Filters pane" and click the More Options toolbar button, and select the Add EVALUATE_PREDICATE function option.

   The "New EVALUATE_PREDICATE Function dialog" is displayed.

2. Enter the function's formula.

   For an example of entering correct syntax, see "How Can I Use the EVALUATE_PREDICATE Function with a Filter?"

3. Click OK.

   The EVALUATE_PREDICATE function is displayed in the Filters pane.