SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 62601: You cannot delete multiple campaigns quickly in SAS® Customer Intelligence Studio

DetailsHotfixAboutRate It

SAS® Customer Intelligence utilities do not provide the functionality to delete multiple campaigns or campaign groups or other Customer Intelligence Public Object Types quickly.

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

After you apply the hot fix, a new utility (-useraction DeleteAssetsQuickly) is introduced. To run the utility, locate the folder where the utilities are stored (typically in SASHOME\SASCustomerIntelligenceUtilities\6.5). If you run the command line in default mode without the -delete parameter, the command lists all campaigns and groups that it will delete.

Notes:

  • Any user who has permissions for the SAS Customer Intelligence public object types can delete those objects.
  • Using this utility does not update the SAS Customer Intelligence Common Data Model DELETED_FLG column  to a value of Y.

The following examples illustrate how to use the new utility to delete SAS Customer Intelligence public object types.

Example 1

In this example, all campaigns in the folder /Campaigns/Examples/ are listed when you submit the following command:

./sasciutils_console -useraction DeleteAssetsQuickly -userid sasdemo -password {your-password} -bcname "your-business-context" -bclocation /Campaigns/Examples/ -metaserver {fully-qualified-target-host-name} -verbose

Important: To actually delete campaigns, campaign groups, or any other SAS Customer Intelligence public object types, you need to add the -delete option at the end of the command, as shown below:

./sasciutils_console -useraction DeleteAssetsQuickly -userid sasdemo -password {your-password} -bcname "your-business-context" -bclocation /Campaigns/Examples/ -metaserver {fully-qualified-target-host-name-delete

Example 2

When you submit the following command, you create a file (in this example, Treatments.txt) where you can list all treatments that you want to delete:

./sasciutils_console -useraction DeleteAssetsQuickly -userid sasdemo -password {your-password} -bcname "your-business-context" -filetype CICTreatment,c:/temp/Treatments.txt  -metaserver {fully-qualified-target-host-name} -verbose

Adding the -delete option, as shown below, removes the treatments that you list in the file that you created.

./sasciutils_console -useraction DeleteAssetsQuickly -userid sasdemo -password {your-password} -bcname "your-business-context" -filetype CITreatment,c:/temp/Treatments.txt  -metaserver {fully-qualified-target-host-name-delete

In this command, -filetype specifies a file (UTF-8) that contains a list of paths within the business context for the given type. For example, the type can be any SAS Customer Intelligence public object types. These types are listed in Chapter 11, Command-Line Utilities of the SAS® Marketing Automation 6.5: Administrator's Guide.

Note: The text file needs to contain the path and the object name (for example, Definitions\Treatments\TestOne). The path and names are case-sensitive.

Example 3

This example illustrates how to delete campaign groups:

./sasciutils_console -useraction DeleteAssetsQuickly -userid sasdemo -password {your-password} -bcname "your-business-context" -metaserver -metaserver {fully-qualified-target-host-name} -filegroups d:/temp/Groups.txt -verbose
 
./sasciutils_console -useraction DeleteAssetsQuickly -userid sasdemo -password {your-password} -bcname "your-business-context" -metaserver -metaserver {fully-qualified-target-host-name} -filegroups d:/temp/Groups.txt -delete

Example 4

This example illustrates how to delete selection campaigns (by including the whole campaign path):

./sasciutils_console -useraction DeleteAssetsQuickly -userid sasdemo -password {your-password} -bcname "your-business-context" -metaserver -metaserver {fully-qualified-target-host-name} -filecampaigns CICampaign_Selection,d:/temp/Campaigns.txt -verbose
 
./sasciutils_console -useraction DeleteAssetsQuickly -userid sasdemo -password {your-password} -bcname "your-business-context" -metaserver -metaserver {fully-qualified-target-host-name} -filecampaigns CICampaign_Selection,d:/temp/Campaigns.txt -delete

 


 


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Customer Intelligence UtilitiesSolaris for x646.56.69.4 TS1M6
Linux for x646.56.69.4 TS1M6
HP-UX IPF6.56.69.4 TS1M6
64-bit Enabled Solaris6.56.69.4 TS1M6
64-bit Enabled AIX6.56.69.4 TS1M6
Microsoft® Windows® for x646.56.69.4 TS1M6
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.