Assume the data pool contains of AP, AR and O2C three processes. I want to delete AP process data, for that I have added an activity in transformation where I have droped all the tables related to AP process data and I have executed that activity and data load has been done. But no change in studio part and APC Consumption also, data got not reduced. Is there any way to delete the data ?
Page 1 / 1
Hi, what has worked for me is the following piece of code:
DROP TABLE IF EXISTS Table] CASCADE;
Hi, APC consumption page is not real-time, delay about a day or so, If you already delete then you just need to wait for the APC page refresh. Studio data is different - it is store in data model (memory) which is different from the data pool / data scope.
Hi, APC consumption page is not real-time, delay about a day or so, If you already delete then you just need to wait for the APC page refresh. Studio data is different - it is store in data model (memory) which is different from the data pool / data scope.
So for APC consumption part, after deleting the tables for certain process I have done data load. So for reflecting it takes time right?
Yes, APC consumption page has refresh schedule.
Additional tips - while deletion can be your solution, I think ultimately you still need to review your design. Have you apply proper filter and only bring necessary data (eg. records and column)? How about sharing the data across data pool?
Vertica engine work differently for deletion, I recommend the https://academy.celonis.com/learning-paths/get-data-into-the-ems-1 especially "transformation best practice".
Thank you.
Hi, what has worked for me is the following piece of code:
DROP TABLE IF EXISTS Table] CASCADE;
Thank you
So for APC consumption part, after deleting the tables for certain process I have done data load. So for reflecting it takes time right?
Thank you
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.