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

594 Views Last edit Jan 23, 2020 at 12:00 AM 4 rev

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