Customer Intelligence Studio 6.3

GerdaNaude — Tue, 14 Jan 2020 05:57:18 GMT

Good morning ..

I would like to clean up our Oracle datamart (customer and account tables)

Kindly advise which log files would indicate what fields are being used,

and what my logging setting should be to get the necessary information ?

Thanks for your help

Gerda

Re: Customer Intelligence Studio 6.3

Sunshine_sas — Wed, 15 Jan 2020 20:11:58 GMT

Hi Gerda,

Unfortunately we don't have a log file that does that

Some additional things that might help - looking in the SASCustIntelCore6.3.log and parse out the data items that are there

SAS-configuration-directory\Lev1\Web\Logs\SASServer6_1\

Using the sasmaextract utility to create an xml file

http://support.sas.com/documentation/solutions/ci/6.5/en/PDF/ciintutilug.pdf

From there it will requires manipulation of XML to get the data you want - you could use something like the SAS XML Mapper to translate into a SAS dataset and then query that dataset.

Sincerely, Sunshine_sas

topic Re: Customer Intelligence Studio 6.3 in SAS Customer Intelligence

Customer Intelligence Studio 6.3

Re: Customer Intelligence Studio 6.3