Activity filter function on a date

Good day, I need to set a filter at column level to get the release date of the PO.
This would be on a TABLE OLAP and the filter does not have to be at component level.

In case I do it in a single table, I apply
FILTER “_CEL_P2P_ACTIVITY_MASTER_DATA” “ACTIVITY_EN” = 'Release Purchase Order '.

I imagine that a PU_FUNCTION is used to set the ROUND_DAY("_CEL_P2P_ACTIVITIES". “EVENTTIME”) that affects only one activity.

Thank you very much.

Hi Thomas,

welcome to the Celonis Community!

You can apply a filter condition in the PU function. I imagine you want to do something like

PU_FIRST("EKKO", ROUND_DAY("Activities"."Eventtime"), "Activities"."Activitiy" = 'Release Purchase Order')

Best
David