Select this option to choose exactly one output audience
record for each input audience record (for example, to choose one
email address per customer).
About this task
You must specify a business rule to indicate how the single entity should be selected
(min/max/median of some field) or choose AnyOne (in this case, no field
choices are available).
This
option is available only if the input audience level is not normalized
(that is, the record ID is not unique in the selected Choose
Level table).
In addition to creating a query, the Based on criterion also supports
keywords allowing the functional equivalent of a GROUPBY macro function to be
performed.
Procedure
- Select an input source for Input and
an output audience for the Audience process.
The Select
options become available.
- Select One <Output Audience Level> per <Input
Audience Level>.
-
Select a value from the Based on drop-down list.
(Field selection, using the drop-down list to the right, becomes inactive when you select
Any One. If this is your selection, skip to step 5.)
-
Select a field in the next drop-down list to which the Based on
function relates:
-
Click in the Based on text box.
The Select Field window appears. All fields from the table selected in the Choose
audience drop-down list appear, including any mapped dimension tables.
You can expand a table by clicking the "+" sign. Created derived fields are listed at the
bottom.
-
Select a field and click OK.
-
(Optional) Create derived fields by clicking Derived fields.
- (Optional) To filter records before performing the Based
On computation, use Filter.
- Click OK.