The SAS Output Delivery System and reporting techniques

customer intelligence and common data model

Reply
Occasional Contributor
Posts: 8

customer intelligence and common data model

Hello,

I need help with this...

we developed a custom node in Customer Intelligence. This node do many taks. The last task, is create a text file with the data we selected on Communication Node, and put a special name to this text file. In this name we have to put a number, that represents how many times the campaign was executed.

We are looking for this number in Common Data Model. We cant found it.

We think we can do somethin like

"select count(*) from ci_cell_package where campaign_cd=CAMPAIGN_CODE"

but in each execution, Customer Intelligence UPDATE CI_Cell_Package, dont inser a new row.

How can we resolve this problem?

Any ideas?

Im thinking in create a new table for manage this part and resolve all this in my custom node.

Any better idea?

I hope you can help us.

Thanks very very much!

Jose
SAS Super FREQ
Posts: 8,864

Re: customer intelligence and common data model

Hi:
This is not really an ODS and Base Reporting procedure question (PROC PRINT, PROC REPORT, PROC TABULATE). Since your question involves the Customer Intelligence and BI Platform products, you might want to work with Tech Support on this question.

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 231 views
  • 0 likes
  • 2 in conversation