topic CI 6.4. Communication node custom details in SAS Customer Intelligence

CI 6.4. Communication node custom details

Incin — Thu, 25 Aug 2016 07:49:29 GMT

Dear SAS experts,

I am looking for your help with SAS Customer Intelligence studio 6.4!

Campaign custom details can be accessed by &matableformacro variable using sas code.

data test;

set &matableformacro;

run;

What about communcation node custom details? Can it be accessed same way? I mean can it be accessed before it is published to common data model?

Best regards,

Sergey

Re: CI 6.4. Communication node custom details

jpsm70 — Thu, 25 Aug 2016 13:15:37 GMT

Hi,

Page 359 of the MA user guide has the following:

The following macro variables are available only if a Communication node is upstream from a Process node. The values are derived from Communication nodes that are directly linked to the Process node. The communication code is exported along with the following macro variables.

UDF_NAME Communication user-defined field. The name of the macro variable is the name of the field.
UDF_TYPE CAMPAIGNUDF

Answer is yes if process node is after communication node.

-Juan P.

Re: CI 6.4. Communication node custom details

Incin — Thu, 25 Aug 2016 13:35:45 GMT

I checked it and it worked like a charm! 😃

Thank you for your fast reply!

Re: CI 6.4. Communication node custom details

Incin — Tue, 30 Aug 2016 06:16:37 GMT

Dear SAS experts,

Here is a case:
I have to use custom library in the export definition.
In order to do that I modified mausrexp.sas.

Then I put export defition to communication node with custom details.

I am wondering is it possible to get access to custom details via mausrexp.sas from matables?

Do you have any clue?

Regards,

Sergey

Re: CI 6.4. Communication node custom details

jpsm70 — Tue, 30 Aug 2016 20:41:49 GMT

Hi Sergey,

Perhaps I am not understanding your question.

1. mausrexp.sas is where you define libraries used by export definitions.

2. Once a campaign executes the custom details values (if configured properly) are stored in the common data model tables. Since the CDM is on database you can use a libname to access the CDM.

-Juan P.

Re: CI 6.4. Communication node custom details

Incin — Tue, 30 Aug 2016 22:08:37 GMT

Hey Juan,

Thank you for your fast reply!
You understood me right. It is true that this kind of data can be accessed from the CDM.

I know that mausrexp code executes each time (update or execute) when custom export definition is used in communcation node.

My question is:
Can communication node custom details be accessed from mausrexp.sas besides CDM? I am trying to find a way without using CDM.

I was trying to execute %maspinit macro (in mausrexp.sas) to get macrovar table. However, I wasn't able to get xml data which can be easily accesed with stored procces.

I belive it can be accessed from MAIntegrationUtilities, but it takes time to build and parse xml file with all campaign data.

Regards,
Sergey

Re: CI 6.4. Communication node custom details

jpsm70 — Wed, 31 Aug 2016 10:04:52 GMT

Hi Sergey,

if you are running a campaign with select -> cell -> communication -> process node then the process node can access the campaign's communication custom details fields.

If you are trying to access custom details fields for campaigns outside of CI Studio execution you have to use a libname against CDM or use the MA integration utilities (sasmaexport) to get the XML.

I guess I am somewhat still confused by your question.

>> Can communication node custom details be accessed from mausrexp.sas besides CDM?

No because to me the question does not make sense.

-Juan P.

Re: CI 6.4. Communication node custom details

irinaia — Fri, 26 Jan 2018 17:08:13 GMT

How can i access MatableforMarco.I run comnaign in SAS CI Studio and then i what look at the table in SAS Base f.eks and run the same code as you but get macro can't be resolved. What i'm doing wrong. What is another way i can get information from matablemacro?