How to use Integer Attribute in Attribute As a Key Figure?

[prasad_mandre]

Hello Experts,

I am working on a requirement wherein I would like to use Attribute value in Key figure for a comparison. Below is our requirement -

I would like to raise an alert when attribute value(say X) is more than 7. For this I am bringing attribute value in KF and trying to use that KF in Alert key figure calculation. I tried two ways to achieve this-

1. Firstly,I tried to define Attribute as Key Figure but as attribute X is set up as Integer and not as decimal, I couldn't use attribute X as key figure. I cant change data type of attribute so this option ruled out for me.

2. I tried to use attribute X as constant in key figure calculation using two single quotes to compare X(e.g.. If(''X'' > 7, 1,0) but I am not getting any output. Everything is setup at Product Location level here.

Am I missing something here ? Any idea how to achieve this objective using some other way?

Thanks,

Prasad

[piyush_parekh · Accepted solution]

Hi,

Since your attribute type is integer, use double quote instead of two single quotes for comparison. Refer ADJUSTEDPRODUCTION, for instance in which an attribute FROZENHORIZON (Data Type: Integer) is used in key figure calculation. On similar lines, you can design your calculation definition.

Regards,

Piyush

[prasad_mandre · Accepted solution]

Thanks for the update Piyush. I tried using double quotes. It worked. Data is still not flowing in. I will check it further.

Thanks,

Prasad