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?