Filters are created in the Master File through the Synonym Editor and can be used in a Business View file or in reporting tools. You can also use filters to perform other data checking and validation, and sort data based on the conditions that you create.
Filters are created under a specific segment and, by default, they have association with the selected segment. Filters can also be created without segment association.
The Synonym Editor opens.
The Filter Calculator opens, as shown in the following image.
Note: It is recommended that filters have a descriptive name to help identify the filter action during reporting.
Note: The Format field cannot be changed. Values for filters return 0 for false and 1 for true.
Tip: From the Properties Pane in the Synonym Editor, click the browse (...) button at the right of the TITLE and DESCRIPTION value fields to specify multiple language titles.
Use the Relational Expression tab to build the expression.
Note: Parameters are not supported with Master File Filters.
The Value Selection dialog box opens, as shown in the following image.
The expression is added to the value field.
The filter is added to the Relational Expression tab where you can add the expression value.
The expression is removed from the Relational Expression tab.
Note: To edit the Filter, Title, or Expression, you may do so directly from the Properties Pane in the Synonym Editor or you may click the browse (...) button at the right of the EXPRESSION value field to relaunch the Filter Calculator.
Filters are created under a specific segment and by default they have association with the selected segment. Filters can also be created without segment association.
Note: If you are using a field that appears in multiple segments, the WITH segment associated should be the lowest level segment or it should be left empty to prevent errors.
In addition, if no fields from the synonym are used in the expression or have not been computed, you can use the WITH option to identify the logical home of the filter calculation. You can also use the WITH option to move the logical home for the filter field to a lower segment than it would otherwise be assigned (for example, to count instances in a lower segment).
The filter is saved as part of the synonym.