How do I create an outer join filter in a report?

Environment

Analytics
Oracle B2C Service

Resolution

When you create an outer join, you can add join filters to filter the data returned from the secondary table without filtering the data from the primary table.

To create a join filter within a report that utilizes an outer join, use the steps below:

1. Open the report for editing.
2. On the Home tab on the ribbon, click Tables
3. In the pop-up window, click the secondary table
4. Click Join Filters to expand the filter window and click Add Filter
5. In the Add Filter window, define the name, expression, operator, value type, and value for the join filter
6. Click OK on both pop-up windows
7. Save the report

Note: Join filters cannot be used as a run-time filter.

For additional information, refer to the 'Create outer join filter' section in the Online Help User Guide documentation. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.

See also:

Answer ID 1839: Types of table joins used with reports

Answer ID 5612: Best practices for table joins in Analytics