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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.