Segregation of dutie

#21

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

#22

Is there still an error?

Best
David

#23

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

#24

Hi Audrey,

does it change when you replace in the first column

“P2P_EKKO”.“EBELN”

with the following:

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

?

#25

Hi,

The OLAP Table never stop loading.

Audrey

#26

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))