Hello,
In a use case we have 4 activities where we are trying to find the throughput time between 2 events from 2 different activities tables , when we used event log merger it pops up an error message showing the row limit exceeds to 5 billion rows , though we have 6.11 million in one and 29 million in one event count (Distinct event) .
Hi @sankalp.malag,
Are there any other events in your event logs next to 'Create Sales Order' and 'Status: Material Committed' that are filtered out in your analysis? It can be that the total sum of rows in your data model is therefore above 5 billion.
If this is the case, you could create a new Event Log manually with only these two activities and add it to your data model using UNION in SQL.
The syntax would be (assuming that the columns and their order of both activity tables are exactly the same!) :
CREATE TABLE "_CEL_O2C_PP_ACTIVITIES" AS
SELECT *
FROM "_CEL_O2C_ACTIVITIES"
WHERE "ACTIVITY_EN" = 'Create Sales Order'
UNION
SELECT *
FROM "_CEL_PP_ACTIVITIES"
WHERE "ACTIVITY_EN" = 'Status: Material Committed'
;
If you link this event log to your case table, you could create a FLAG or FILTER per case, using the code in your second screenshot and this temporal event log.
Using this FLAG/FILTER, you could see the process behavior using the other O2C or PP event logs that are also linked to the case table.
I hope this helps.
Best regards,
Jan-peter
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
