Hello Jenea,

I think your approach is very close to the answer you are looking for, have you tried to set a filter statement that affects only to your OLAP table using the same CASE WHEN condition to bring in the values that in the Parameter column are different from null?

Please let me know if you have already tried this approach. 

Thanks for your reply Andre!

In fact I have a mistake in my post. So I need to get just the rows with the Case Keys where the parameter is null. The output should be like this:

Case Keys 1 & 3 should not be in the Olap Table, as they have a "non null" parameters.

And, yes, I tried your suggestion but instead of having my desired output (2 Case Keys) I am getting 4 Case Keys:

Why? Because it is just filtering based on the Case Key + Parameters Columns and is not filtering based on the Case Key + Activity + Parameters Columns.

Any ideas on how it should be solved?

In the end I've solved my issue by using the following Filter at the component level:

FILTER ("CASES", Table1.CASE_KEY, ISNULL(TABLE1.PARAMETER)=0)=0

This way, I am limiting my rows just to have the CASE KEYs with 0 Count of Values in the column "Parameter". When I have a value in the column "Parameter" automatically the count is 1 and as a result this row will be restricted.

Actually this:

FILTER PU_COUNT_DISTINCT ("CASES", Table1.CASE_KEY, ISNULL(TABLE1.PARAMETER)=0)=0