About teresa_abbate

teresa_abbate · ‎05-17-2017

Hi All, I'm tryng to create a SAS Macro for implementing the following steps : 1) Read a table (CMS_STG_AGENT) like this: CAMPAIGN_GROUP_CD Agent Capacity GROUP1 1234_1 45 GROUP1 1256_1 60 GROUP1 3421_1 20 GROUP2 1234_1 30 GROUP2 1256_1 10 GROUP2 3421_1 15 Number of distinct values and values for campaign_group_cd are unkwown. For each camapign_group_cd, the agent can have different capacities. ES. Agent 1234_1 has a capacity of 45 for GROUP1 and 30 for GROUP2. 2) Split the CMS_STG_AGENT into N tables, one for each CAMPAIGN_GROUP_CD. In this case 2 tables but we could have more than 2 differend CAMPAIGN_GROUP_CD or in other cases just one. table for GROUP1 Agent Value 1234_1 45 1256_1 60 3421_1 20 table for GROUP2 Agent Value 1234_1 30 1256_1 10 3421_1 15 3) For each table created, the table's name includes the parameter of CAMPAIGN_GROUP_CD.: CMS_<CAMPAIG_GROUP_CD>. Es: The first table's name should be: CMS_GROUP1, for the second one CMS_GROUP2. Can you help me please? 🙂 Thanks, Teresa

teresa_abbate · ‎03-29-2017

Hi Dmitri, thank you for your warnings! yes, the goal is getting "separate log file only for metadata run". I thought about the possibility to modify the CICore logconfig ...as you wrote, maybe it's not the right technical way. Suggestions are welcome! 🙂 Teresa

teresa_abbate · ‎03-28-2017

The aim is to have a more readable log in which, the information about campaign opening and rescue are not showed. We have already desabled the logging properties from the web app interface of CIS but this kind of information are still showed...

teresa_abbate · ‎03-27-2017

The run of infomap's metadata and all other CIS operations are logged in the same log file CICore6.5.log It is possible modify the logconfig in order to have a separate log file only for metadata run? Thanks, Teresa

teresa_abbate · ‎03-10-2017

Very helpful article! Thank you very much!

teresa_abbate · ‎03-06-2017

Hi Erin, thanks for your advice! Unfortunately both thoughts are not usable in my case: 1) Agent Channel Constraints using the communication code --> we don't know the capability of each agent (avery day they change) 2) Define each of the agents as a separate channel --> there are thousands of agents However I found very interesting your suggestion about the value of unit_usage and I would learn more. From the user guide, I understood that this value may represent the average time used by agents for each communication and it may not be null. In the attached picture, my Agent data Input table shows: time_period= today and Capacty=max number of communication for each agent for today. Considering the same example, but with unknown agent's capacity : Camp1 -> COMM1 -> TargetA (Agent1 time_period=today Capacity=X) Camp2 -> COMM2 -> TargetB (Agent1 time_period=today Capacity=X) How can I estimate the unit_usage value for each communication in order to obtain: number of contacts for COMM1= 40% of Agent1 Capacity (40% of X), number of contacts for COMM2= 60% of Agent1 Capacity (60% of X) ? thanks, Teresa

teresa_abbate · ‎03-03-2017

Hi Erin, thank you for your answer! I've tried to change the value of agent communication Unit Usage but nothing changed. I'm not sure I understood how to estimate this value: D In the exemple of Camp1 -> COMM1 -> targeta Camp2 -> COMM1 -> TargetB supposing that the customers of TargetA and TargetB have the same agent "AgentX" with time_period = 03March2017 and capacity = 100, how can I set the unit_usage for COMM1/ COMM2 communications in order to obtain 40 customers of targeta for COMM1 and 60 customers of TargetB for COMM2? Thank you, Teresa

teresa_abbate · ‎02-23-2017

Hi all, i'm optimizing a campaign group made of 2 selection campaigns. CAMP1 --> TargetA CAMP2 -->TargetB I'd like limit the number of contacts of each campaign to a percentage of agent's capacity. Suppose that customers of TargetA use the 40% of their agent's capacity and customers of TargetB use the 60% of their agent's capacity. Where can I define this constrain? Do you have suggestions? Thanks, Teresa

teresa_abbate · ‎11-18-2016

Hi Dimitri, thank you for your answer! 🙂 The missing information is: which of the decision treatment campaign contributes to present the output treatment. I'll try to explain the problem with an example: I have the Decision Campaign "A" ; I assigned in the treatment tab the Decision Treatment Campaign Set "B". B has 3 Decision Treatment Campaigns: Camp1, Camp2, Camp3. Camp1 has the treatments: Treat1,Treat2 Camp2 has the treatment: Treat2 Camp3 has the treatment: Treat3. The final result is that in the CI_PRESENTED_TREATMENT_HISTORY I have the Treat2 with the cell_package_sk generated by campaign A. It's correct but I'd like know if Treat2 comes from the decision treatment campaign Camp2 or Camp1. Ther's a way to have this information in the as-is structure of CDM? thanks, Teresa

teresa_abbate · ‎11-18-2016

Hi @BeverlyBrown , the Tech Support is now helping us to solve the problem! Thenk you! 🙂

teresa_abbate · ‎11-18-2016

Hi, I'm using SAS Customer Intelligence Studio 6.4. My decision campaigns have a decision treatment campaign set with n decision treatment campaigns. Each DTC has 1 or more treatments assigned and it is possible that two or more DTC have the same treatment. When campaign is processed, the eligible treatment is registered in the CI_PRESENTED_TREATMENT_HISTORY and the CELL_PACKAGE_SK recorded is related to the main Decision Campaign. I can't find on the Common Data Model a table/joinable table that allows to relate treatments with their own DecisionTreatmentCampaigns. It is possible with this version of the CDM to have this information? Thank you, Teresa

teresa_abbate · ‎11-14-2016

Hi All, i'm configuring my develope environment for SAS Marketing Optimization. the step done are the creation of a Teradata Library for MO tables (as Campaign, Communication, Customer..), a user group for managing camapign and MO obejcts, and so on... However, every time I try to create an Input Data I display a pop up with an error message related to the library MOMETA. The error in the log is the following: com.sas.rio.MVASQLException: Unable to execute query: SQL passthru expression contained these errors: ERROR: Libref MOMETA is not assigned I found 2 sas note about this: http://support.sas.com/kb/44/546.html# http://support.sas.com/kb/50/121.html# for both I followed the step but nothing changed. Have somebody ever had this problem? If yes, Could you help me in hunting error? Thanks, Teresa

teresa_abbate · ‎10-24-2016

I've found some strange tables on DB. Their name is something like "T2140000119HGEF3WMW2VCMTQKZ" (like metadata tables) and each row represent a subject-id defined in SAS MA. It is possible that SAS during campaign execution creates temporary tables on DB (containing the subjectid selected in the select node) and if something goes wrong it can't delete them? Thanks, Teresa

teresa_abbate · ‎10-17-2016

do you mean that RTDM connection uses only the jdbc connection resource configured on the decision services for reading db tables? In this case, it' enough changing the service_name in the resource's server url.

teresa_abbate · ‎10-17-2016

We work with an Oracle DB which has 3 istances and 3 differents service names. It is possible specify differents service names for outbound campaign connection and inbound campaign connection? thanks, Teresa

Online Status	Offline
Date Last Visited	‎07-04-2018 08:51 AM

Split tables

Re: Log Config CICore6.5

Re: Log Config CICore6.5

Log Config CICore6.5

Re: Limit number of contacts to percentage of agent's capacity

Re: Limit number of contacts to percentage of agent's capacity

Re: Limit number of contacts to percentage of agent's capacity

Limit number of contacts to percentage of agent's capacity

Re: Relationship between registred Treatment and Decision Treatment Ca...

Re: Error in Create Input Data - MO

Re: Log Config CICore6.5

Re: RTDM - Datetime variable for Data Process (insert type)

Managing Common Data Model

Re: RTDM - Datetime variable for Data Process (insert type)

RTDM - Datetime variable for Data Process (insert type)

Split tables

Re: Log Config CICore6.5

Re: Log Config CICore6.5

Log Config CICore6.5

Re: Limit number of contacts to percentage of agent's capacity

Re: Limit number of contacts to percentage of agent's capacity

Re: Limit number of contacts to percentage of agent's capacity

Limit number of contacts to percentage of agent's capacity

Re: Relationship between registred Treatment and Decision Treatment Ca...

Re: Error in Create Input Data - MO

Relationship between registred Treatment and Decision Treatment Campai...

Error in Create Input Data - MO

sasMA creates tables on DB?

Re: Create different db connection for each db partition

Re: Create different db connection for each db partition