PaPM Cloud SM - Selective Deletion in an Executable Function

[edwiromero_s]

Hi Masters, 

How are you doing?

I have a theoretical case that we don't know how to solve yet in PaPM Cloud SM.

This is the case: 

I have a process template with an executable function at the end (Join function) and all the reports attached (Queries). The Selection field is "Period".

By mistake, a second process template with the same period was executed and this created a second set of data, therefore data is duplicated. What we need is to remove the set of data from the process duplicated. Either the process is removed, data persist in the function. 

Graphically would be something like this: 

We have set the parameter :l_proc_id  as a field and we can filter them, but in the end, this is functionally but not practical as there is data that we know is duplicated. 

I know that PaPM is not a DW, but we are not using PaPM to store data, we are going to store it for 3 months and then move to a DW. 

One option is to erase all data from the function but when we are at the third month this would be a problem as we would have to run the two previous months.  

Is there a way to achieve this?

Regards

[ZYT]

Hi @edwiromero_s ,

 I was wondering if you have tried to store the result in a (model) table in your environment, then use a writer to delete the unwanted result?

Best regards,

Zhiyi Tang