Gap Analysis Filters

Gap Analysis Filters

Gap Analysis Filters are used to show differences that match some specific criteria. In other words, discard the differences which doesn’t match these criteria.

It could be used, for instance, to show only differences where the Field is Required in the Receiving Application but Optional (or Missing) in the Sending Application.

 

Add Filters

  1. Click the [empty] filter buttonFilterEmpty within the section that you want to filter differences. A filter dialog will be shown.
  2. Click the Add… button  to add a new filter.
  3. Edit filter settings.
  4. Click the OK button when you’re done editing your filters. The filters will be applied, showing only differences which match your criteria.

 Gap Analysis Filter Dialog

 If a section contains active filters, the filter button will be shown as a full filter FilterFull

 

Filter Settings

Basic Settings 

Source:  Select a side from which you want to perform a filter.
Column:  Select the column from which you want to get the value to be compared.
Is/Is Not:  Include/Exclude differences that match the filter.
Operator:  Select the operator that you want the criteria and the column’s value to match.
Criteria:  Enter the criteria that you want to compare with the column’s value.

 

 Advanced Settings

Checkbox:  Activate or deactivate filter (toggle on or off).
And/Or: 

AND: applies both these filters.

OR: applies either of these filters.

Parentheses:  Used for nested filters.

 

Operators

= Covers value with an exact match to this data (this is like putting quotation marks around a search engine query)
> Greater than. Covers filtering on numeric values.
>= Greater than or equal to. Covers filtering on numeric values.
< Less than. Covers filtering on numeric values.
<= Less than or equal to. Covers filtering on numeric values.
containing Covers messages that include this value. 
present Looks for the presence of a particular column.
empty Looks for an unpopulated column.
matching regex Use .NET regular expression syntax to build filters. For advanced users with programming backgrounds. Learn more about regular expressions here: 

in Builds a filter on multiple data values rather than just one value.
= Other Specification Value Exact match to the other profile’s column value.
> Other Specification Value Greater than the other profile’s column value. Covers filtering on numeric values.
>= Other Specification Value Greater than or equal to the other profile’s column value. Covers filtering on numeric values.
< Other Specification Value Less than the other profile’s column value. Covers filtering on numeric values.
<= Other Specification Value Less than or equal to the other profile’s column value. Covers filtering on numeric values.

 

Basic/Advanced Mode

While editing your filters, you can switch between Basic and Advanced Mode. Advanced Mode will show you advanced settings for your filters. These settings will help you to construct more complex filters using AND/OR operators and parentheses for nesting. Otherwise, each filter will be applied one after the other.

If your filters contains advanced settings and you switch back to the Basic Mode, these settings will be lost.

 

Gap Analysis Filter Template

Gap Analysis Filters Template are re-usable filters that can be applied to many Gap Analysis.

You can select a built-in template from the drop-down list at the top-left of the filters dialog, or, you can create your own and share it through a file.

Gap Analysis Filters icon: DocumentPackageTypeGapAnalysisFilters 

 

Import from File

There are three different ways to import Gap Analysis Filters.

  1. The first way is to import them with the File menu. To do so, click  FileGap Analysis FiltersImport from File… . The application opens a dialog box to select a Gap Analysis Filters file (*.cxgf).
  2. The second way is to import them from the Recent File list. To do so, click FileGap Analysis Filters[File name].
  3. The third way is to import them directly from the filter dialog. To do so, open a filter dialog, then click the Actions [Action] menu and Import from File… .The application opens a dialog box to select a Gap Analysis Filters file (*.cxgf).

 The first two ways will import filters for each sections (Trigger Event, Segment, Field and Table). The third way will only import filters for the related section.

 

Export to File

 There are two different ways to export Gap Analysis Filters.

  1. The first way is to export them with the File menu. To do so, click FileGap Analysis FiltersExport to File… . The application opens a dialog box to save a Gap Analysis Filters file (*.cxgf). If you select an existing file, the entire file will be replaced.
  2. The second way is to export them directly from the Filters dialog. To do so, open a Filters dialog, then click the Actions [Action] menu and Export to File… . The application opens a dialog box to save a Gap Analysis Filters file (*.cxgf). If you select an existing file, you will be asked to replace the existing filters for the selected section only.