topic Re: Current Campaign Version flag in CI_CAMPAIGN table in CDM table in SAS Customer Intelligence

Current Campaign Version flag in CI_CAMPAIGN table in CDM table

JM_VFAU — Tue, 07 Apr 2020 22:18:23 GMT

If we save campaign by retaining campaign code in SAS CI, it creates multiple records in CI_CAMPAIGN table in CDM database.

Is there a way where to change the current version flag value in this table for the non current campaigns using SAS CI gui? Currently we update the value manually in the table.

Re: Current Campaign Version flag in CI_CAMPAIGN table in CDM table

JamesAnderson — Tue, 07 Apr 2020 23:40:00 GMT

HI JM_VFAU,

This isn't exposed in the GUI - presumably you are asking this to empower the end users, rather than a support request back to the IT team ? If so you could wrap the update sql into a Stored Proc, and then create a "utility" custom node and give the users instructions to add it to the diagram of the new campaign on first use and execute it to update the flag.

Regards
James

Re: Current Campaign Version flag in CI_CAMPAIGN table in CDM table

JM_VFAU — Tue, 07 Apr 2020 23:51:10 GMT

Thanks James.