BookmarkSubscribeRSS Feed
Will_F_SAS
SAS Employee

 

In the 22.07 release of SAS Customer Intelligence 360, the Unified Data Model (UDM) will be updated to use the data model for schema 9. Schema 9 introduces enhancements to usage metrics for REST APIs, cross-table information, and new tables for cost-center budgeting in SAS 360 Plan.

 

These are updates to the existing tables in the UDM:

 

Table Name

Updates

EMAIL_OPEN

One column was added: prefetched_flg

 

This column indicates whether the email open event was triggered automatically (prefetched) by the mail provider.

 

Prefetching email information is common if the email recipient is using an iOS device and has activated Apple’s Mail Privacy Protection feature (MPP).

DAILY_USAGE

One column was added: api_usage_cnt

 

This column contains information about the calls to REST API endpoints in SAS Customer Intelligence 360.

MONTHLY_USAGE

One column was added: api_usage_cnt

 

This column contains information about the calls to REST API endpoints in SAS Customer Intelligence 360.

MD_SEGMENT_MAP_X_SEGMENT

One column was added: segment_version_id

 

This column contains the version ID for a segment. You can use this new column to join records from the CDM_SEGMENT_DETAIL table in the CDM.

PLANNING_INFO

One column was added: parent_id

 

This column contains the ID of the record’s parent item.

 

These are the new tables for SAS 360 Plan:

 

Table Name

Updates

CC_BUDGET_BREAKUP_CCBDGT

This table contains information about cost-center budgets when you are using cost-center based budgeting.

COMMITMENT_LINE_ITEMS_CCBDGT

This table contains information about line items in commitments that are used in cost-center budgeting.

FISCAL_CC_BUDGET

This table contains information about fiscal periods that are used for cost-center budgeting.

INVOICE_LINE_ITEMS_CCBDGT

This table contains information about line items in an invoice that is used in cost-center budgeting.

MD_FISCAL_PERIOD

This table contains metadata about fiscal periods for SAS 360 Plan.

 

How to improve email deliverability

SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • 3400 views
  • 4 likes
  • 1 in conversation