Hi @richanda.wrigh,

If I understand correctly, you only need help with Configuring the KPI right?

If you want to monitor how many times MATNR is missing, you can use COUNT with a CASE WHEN statement.

It would look like this:

COUNT(CASE WHEN "EBAN"."MATNR" IS NULL THEN 1 else 0 END)

This basically counts the amount of cases that miss a Purchase Req number.

Hopefully this helped you out. Otherwise, let us know if you need more help!

Kind regards,

Sverre Klein

Thank You! I will try this. I appreciate your help

Hi @richanda.wrigh,

I hope it worked for you? Let me know! 😁

Small addition to this one: you should use ‘ "EBAN"."MATNR" IS NULL ‘ (= only works with real values). The other part should do!

Hi guys. I have a related question to the Transformation Center please. During calculation of the AVG why it will not take the weighted AVG? For instance in the above mentioned example: yesterday 1 Material Number was missing in 1 out of 100 Purchase Req and today 1 out of 1. According to Transformation Center logic it wil be (1% + 100%) / 2 However it fact yesterday we had more Purchase Req. Other than that there are lot's of performance issues as well. If you click on a created KPI it jumps to the all Objectives. But the feature itself is good for the upper Management and Process Management.

Thanks @janpeter.van.d, I changed this in my original response. 😎

THANK YOU AGAIN! IT WORKED LAST Question! I am now trying to apply a filter to the KPI but when I add the Vendor filter it errors out. Any idea what I am doing wrong?

Date: FILTER "EBAN"."BADAT" > TO_DATE ('2024-02-23' ,FORMAT ( '%Y-%m-%d' ))

Vendor: FILTER "EBAN"."FLIEF" = ('0010009689','0010007548','0010009755‘)

Thank You for taking the time out to review as well @janpeter.van.d

Hi @richanda.wrigh,

Great to hear to first question is resolved. 🙂

For your filter, I think there are two main issues.

• First, you want to add two filters on the KPI without using a logical AND.
• Second, you don't have an 'IN' predicator for the Vendor filter.
• Third (not sure if it causes problems), you miss an ';' at the end of your filter statement

Try the following:

FILTER  "EBAN"."BADAT" > TO_DATE ('2024-02-23' ,FORMAT ( '%Y-%m-%d' )) AND "EBAN"."FLIEF" IN ('0010009689','0010007548','0010009755‘);

Let me know if this worked for you. 😄

Thanks, for some reason, it's not liking my date filter. Even when I apply the data filer by itself.

Hi @richanda.wrigh,

Is there no value returned? Could you share a screenshot of your KPI configuration in Transformation Center?

No there is no returned value

Hello @sverre.klein11 I think I fixed it. I tried to add each vendor to the line and that seemed to work which is weird

FILTER "EBAN"."FLIEF" = '0010009689';

FILTER "EBAN"."FLIEF" = '0010007548';

FILTER "EBAN"."FLIEF" = '0010009755';

FILTER "EBAN"."BADAT" > TO_DATE ('2024-02-23' ,FORMAT ( '%Y-%m-%d' ))

Hi @richanda.wrigh,

Yes this works as well! Weird that the IN predicator didn't work.

From your above filter statement with the IN predicator, I think you (and also me) used a curly quote (’) instead of a straight quote (') at the end of 0010009755.

Try this

FILTER "EBAN"."BADAT" > TO_DATE ('2024-02-23' ,FORMAT ( '%Y-%m-%d' )) AND "EBAN"."FLIEF" IN ('0010009689','0010007548','0010009755')

Let me if that worked :)

Kind regards,

Sverre Klein

THANK YOU SO MUCH! It worked. I really do appreciate all the time you have spent to help me figure this out. Have a good day