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?
Im thinking in create a new table for manage this part and resolve all this in my custom node.
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.