https://communities.sas.com/t5/ODS-and-Base-Reporting/customer-intelligence-and-common-data-model/m-p/52909#M6618 Hello,<BR /> <BR /> I need help with this...<BR /> <BR /> 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.<BR /> <BR /> We are looking for this number in Common Data Model. We cant found it.<BR /> <BR /> We think we can do somethin like <BR /> <BR /> "select count(*) from ci_cell_package where campaign_cd=CAMPAIGN_CODE"<BR /> <BR /> but in each execution, Customer Intelligence UPDATE CI_Cell_Package, dont inser a new row.<BR /> <BR /> How can we resolve this problem?<BR /> <BR /> Any ideas?<BR /> <BR /> Im thinking in create a new table for manage this part and resolve all this in my custom node.<BR /> <BR /> Any better idea?<BR /> <BR /> I hope you can help us.<BR /> <BR /> Thanks very very much!<BR /> <BR /> Jose Mon, 18 Apr 2011 22:42:07 GMT jcasaspe 2011-04-18T22:42:07Z https://communities.sas.com/t5/ODS-and-Base-Reporting/customer-intelligence-and-common-data-model/m-p/52909#M6618 Hello,<BR /> <BR /> I need help with this...<BR /> <BR /> 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.<BR /> <BR /> We are looking for this number in Common Data Model. We cant found it.<BR /> <BR /> We think we can do somethin like <BR /> <BR /> "select count(*) from ci_cell_package where campaign_cd=CAMPAIGN_CODE"<BR /> <BR /> but in each execution, Customer Intelligence UPDATE CI_Cell_Package, dont inser a new row.<BR /> <BR /> How can we resolve this problem?<BR /> <BR /> Any ideas?<BR /> <BR /> Im thinking in create a new table for manage this part and resolve all this in my custom node.<BR /> <BR /> Any better idea?<BR /> <BR /> I hope you can help us.<BR /> <BR /> Thanks very very much!<BR /> <BR /> Jose Mon, 18 Apr 2011 22:42:07 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/customer-intelligence-and-common-data-model/m-p/52909#M6618 jcasaspe 2011-04-18T22:42:07Z https://communities.sas.com/t5/ODS-and-Base-Reporting/customer-intelligence-and-common-data-model/m-p/52910#M6619 Hi:<BR /> 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.<BR /> <BR /> cynthia Mon, 18 Apr 2011 22:46:33 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/customer-intelligence-and-common-data-model/m-p/52910#M6619 Cynthia_sas 2011-04-18T22:46:33Z