We’re smarter together. Learn from this collection of community knowledge and add your expertise.

How Cell Nodes affect query results in SAS Customer Intelligence

by SAS Super FREQ on ‎02-01-2017 12:17 PM (965 Views)

Did you know how Cell Nodes affect query results in SAS Customer Intelligence?

 

First let me explain some Key Terms:

 

Subject List:
A list of subjects. There is no context associated with this list.  All we know is whether or not a given Subject_ID is in the list.

 

Select and Cell Nodes:
A Customer Intelligence Selection Node that represents a Subject List.  Nodes downstream from a Cell Node see only the Subject List. They don't know why the Subjects are in that list.

 

MATable:
The Table that Customer Intelligence creates containing the physical Subject List.  Represented by a Cell Node in the Campaign.

 

Example Data:

list_1.JPG

 

Diagram Use Case:

Select Node(Type='VISA') ---> AND(meets all) Select Node(Balance>=1000)

 

Question being asked:

Which Subjects have 'VISA' accounts with a Balance >= 1000.

The result of this query is:    

SUBJECT_ID = { 2 } because only SUBJECT_ID 2 has a VISA account with a Balance >= 1000:

list_2.JPG

 

Diagram Use Case:

Select Node(Type='VISA') --> Cell --> AND(meets all) Select Node(Balance>=1000)

 

Question being asked:

Which Subjects that have 'VISA' accounts also have any other account with a Balance > = 1000.

 

The result table and the Use Case have been highlighted in yellow to show the source of the final result. This case is the same as the previous case, except that there is now a Cell between Select Node(Type='VISA') and the AND node.

The Cell creates a MATable that contains this list of subjects: { 1, 2 } because both SUBJECT_IDs 1 and 2 have VISA accounts.

 

The AND node then combines this list of SUBJECT_IDs with the criteria Balance>=1000.

The result of the AND query is now:    

SUBJECT_IDs = { 1, 2 } because both subjects were in the Cell's List of SUBJECT_IDs and they had an account with a Balance

>= 1000.
list_3.JPG

 

Summary:

Dropping Cells into a diagram can change the question that's being asked. When formulating the Natural Language Question that represents the 'AND' result, one must remember that the AND node does not know why SUBJECTs are in the list.

It only knows that the list exists and that the result needs to consider membership in this list as one of its criteria.

Contributors
Your turn
Sign In!

Want to write an article? Sign in with your profile.