Segregation of dutie

Hi David,

Thanks a lot for the explication.

The filter did nothing on my OLAP table.

But I’ve use : “P2P_EKKO”.“EBELN” on my first column and not the Casekey suggerated by mfroehlich.

Thanks
Audrey

Is there still an error?

Best
David

No error, but my database always contains different people who have done the actions ex:
Bob did the creation and Guy did the reception.
I do not want to see them.

Thanks
Audrey

Hi Audrey,

does it change when you replace in the first column

“P2P_EKKO”.“EBELN”

with the following:

“P2P_EKPO”.“EBELN” || “P2P_EKPO”.“EBELP”

?

Hi,

The OLAP Table never stop loading.

Audrey

Hi Audrey,

does the error still occur? Also, for how long did you let the table load?

Does it change anything when you add the Case-When-Statement from your second column to the target column (column number 5)? That would ensure, all of your targets run through the same “filter”. This would like the following:

Fifth column : TARGET( “_P2P_ACTIVITIES”.“ACTIVITY_EN” , (CASE WHEN “_P2P_ACTIVITIES”.“ACTIVITY_EN” = ‘<%=myActivity %>’ THEN ‘<%=myActivity %>’
WHEN “_P2P_ACTIVITIES”.“ACTIVITY_EN” = ‘<%=myActivity2 %>’ THEN ‘<%=myActivity2 %>’
ELSE NULL END))