Using Criteria Builder - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
How Do I
Reference
Overview
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552
You need to have a transformation defined to build a criteria.
  1. On the Create Mapping <logical model name> page, select the required logical entity, and click the Criteria Builder icon on the tool bar . Alternatively, click the Entity Transformation icon of the required logical entity.
  2. Select a grouping method for the criteria from the Group satisfying criterion drop-down list. Specify whether it is necessary to fulfill Any, All, or None of the criteria defined in the criteria group.
  3. To add a criterion to a group, hover the mouse on the parent group, and click the Add Comparison icon . The added criterion shows below the group.
  4. To build the criteria:
    1. Click <Column 1> and select the column to which the criteria is to be applied.
    2. Click the <Comparison> drop-down list to select the required logical operator.
      Note: You can add multiple criteria to one criteria group. Use the Add Comparison icon to add another criteria to this group, and repeat steps a and b to build the criteria.
  5. To add a child to this criteria group, click the Add group icon , and repeat steps 3 and 4 to build criteria.
  6. Click OK.
    The defined criteria are saved and is used to retrieve data from the mapped tables and columns to the logical model.