Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
Creating join filters in Analytics
Answer ID 8969 |
Last Review Date 11/18/2018
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:
- Open the report for editing.
- On the Home tab on the ribbon, click Tables
- In the pop-up window, click the secondary table
- Click Join Filters to expand the filter window and click Add Filter
- In the Add Filter window, define the name, expression, operator, value type, and value for the join filter
- Click OK on both pop-up windows
- 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: