When you publish a campaign containing a backslash character ( \ ) in SAS Customer Intelligence, the backslash is lost when the common data model is stored in an Amazon Redshift database.

For example, when a campaign is stored in the Campaigns\Test folder, the value of the CAMPAIGN_FOLDER_TEXT column in the common data model should be Campaigns\Test. However, the value that is published to the common data model is CampaignsTest, where the backslash character ( \ ) is lost.

To work around this behavior, add the following logic that replaces a single backslash with two backslashes to the MAPUB.SAS macro:

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 6.5 is available at: