Filter Cases on multiple activities and conditions

@dennis.albre 

This filter does not work because you are filtering on activity A at first and then afterwards the change activities. I believe both are mutually exclusive which is why you are getting an empty OLAP. You need to use PU Functions to classify one case which is what you want to do I believe.

So sth like PU_COUNT(case_table, ACTIVITIES.ACTIVITY, ACTIVITIES.ACTIVITY LIKE %Change% AND ACTIVITIES.DIVISION = Division B)

counts how many activities meet the condition per case. You need to do the same with the other statement and then combine the two in a filter.

FILTER PU_COUNT(case_table, ACTIVITIES.ACTIVITY, ACTIVITIES.ACTIVITY LIKE %Change% AND ACTIVITIES.DIVISION = Division B) > 0 AND [other PU_COUNT] > 0; should do the job

Best,

Kevin

Hello Dennis,

You need to use a pull up function in this case.

Full syntax:

FILTER

PU_COUNT(case_table, ACTIVITIES.ACTIVITY, ACTIVITIES.ACTIVITY ='Activity_1' AND ACTIVITIES.DIVISION = 'Division A' >0 AND

PU_COUNT(case_table, ACTIVITIES.ACTIVITY, ACTIVITIES.ACTIVITY LIKE %Change% AND ACTIVITIES.DIVISION = 'Division B') > 0 ;

Best,

Gabriel