Symptom
Why is all our source system data still in Process Intelligence, even after we have deleted all table data? We followed the user guide section below, but after when we run the Source Data table previews, the same data is still available:
- How to delete table data in standard extraction: https://help.sap.com/docs/signavio-process-intelligence/user-guide/data-deletion-standard-extraction?locale=en-US&
- How to delete table data in advanced extraction: https://help.sap.com/docs/signavio-process-intelligence/user-guide/data-deletion-advanced-extraction?locale=en-US&
Cause
The Source Data table 'Preview' is not actually a preview of the data extracted into Process Intelligence, but rather a direct preview of the connected source system
Resolution
If you want to test whether all the data was deleted from Process Intelligence, you can create a Data View for each table, add the following code, and run a preview:
SELECT *
FROM <table_a>
The preview should show a result of 'No data' if the data has been deleted.
Keywords
process, intelligence, data, delete, preview, signavio, source, system , KBA , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , Problem