Question

Activity filter function on a date

+14

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.

+2

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

Sign up