SAP Intelligence - Delete processes, but that the pipelines remain.

[CP_PL]

Dear all, 

I would like to reduce the number of our cases in SAP Intelligence. However, I would like to delete the processes, but in such a way that the pipelines continue to exist.
To do this, I wanted to select the processes to be deleted and delete the process under Settings. I seem to have two options here. Which option would be correct to reduce the number of cases but keep the pipelines? Is there a possibility?

Thanks in advance. 
Best regards, 
Christine

[Samuel_Gosling_Product_at_SAP]

---

I would like to reduce the number of our cases in SAP Intelligence. However, I would like to delete the processes, but in such a way that the pipelines continue to exist.
To do this, I wanted to select the processes to be deleted and delete the process under Settings. I seem to have two options here. Which option would be correct to reduce the number of cases but keep the pipelines? Is there a possibility?

Hello, as you want to reduce the number of cases in the Process Analysis layer, but keep the remaining pipelines in the Data Management layer, my suggestion would be the following:

1. Inside of the Business Objects SQL scripts in Process Data Management, I would recommend to add a SQL filter that none of the business objects would fulfil. 
   1. E.g. a WHERE statement at the end of the Case Attributes script that says " WHERE c_caseid = '123' ", or some combination that is similar to this.
   2. Note: If c_caseid is not yet materialized, you may need to reference other fields that are used to make up the case id column.
2. Run the T&L
   1. If successful, your process in the Process Analysis layer should reveal 0 cases.

If you follow this approach, this would also ensure that your dashboards and other process analysis configurations remain in tact, whilst you can modify the SQL scripts in Process Data Management to bring back more cases incrementally.

[Ascha]

Hello @CP_PL ,

thanks for your request! My name is Ascha and I am part of the virtual Customer Success Team at SAP Signavio.

To reduce the cases, you would need to:
Delete source data by going to Process Data Pipeline → Source data → Select one of all tables then "Delete only extracted data and keep the tables".
User guide:
https://help.sap.com/docs/signavio-process-intelligence/user-guide/data-deletion-standard-extraction
Remove delta/Partition strategy configuration if you had any.

Configuration phase to configure following:
Set new SQL filter.
SQL filter: this is where you can define a filter that would result in reduced amount of cases: https://help.sap.com/docs/signavio-process-intelligence/user-guide/refine-extraction-with-sql-filter...
Then you can setup the initial partition strategy and then extract the initial load.
Once the extraction of all the tables that require data reduction for is complete, you can proceed with the T&L so that the reduced data set overwrites the existing dataset in the process.

Hope this help!

If you need further assistance, please let us know. 

Kind regards

Ascha ( as part of the virtual Customer Success Team)

[CP_PL]

In addition, is it possible to reduce the number of cases in a process, e.g. by filtering out certain activities or possibly shortening the time period queried?