BookmarkSubscribeRSS Feed

How Cell Nodes affect query results in SAS Customer Intelligence

Started ‎02-01-2017 by
Modified ‎02-01-2017 by
Views 1,733

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.

Version history
Last update:
‎02-01-2017 12:17 PM
Updated by:
Contributors

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Tags