Question:
Hello BW gurus,
I am facing a problem. I need to create an exception on a characteristic attribute "sales area". If sales area is say "ABC", the color should be red, if it is "DEF", it should be green and all the rest should be yellow. I know that exceptions are created on key figures. I do not know if exceptions can be created on characteristics. Is this possible and can somebody provide some advise?
Thank you,
BIGuy
Answer:
Can someone help me please?
Answer:
create a restricted KYF 1 that is restricted to chars ABC only;
same with restricted KYF 2 ;
Create your color conditions based on those restricted KYF
if keyfig 1 is > 0, color is red
if keyfig 2 is > 0, color is green
and so on
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.
Answer:
Thank you CHC. I will give it a try. But one doubt I have is, there may be a step missing. Once I kreate a restricted KYF based on the sales area, don't I have to create a formula so that I can set the values "ABC", "DEF" etc. to numbers? Otherwise how will I get values 1 and 2 when I create the exception?
BIGuy
Answer:
I think what CHC means is that the suggested restricted keyfigures will use the normal reporting keyfigures only they will be restricted according to 'ABC' 'DEF' etc. So you can now make all your ABC keyfigures red and DEF yellow etc. You don't need new keyfigures.