Question:
Can an attribute be displayed as the product of an If/Then analysis in BEX?
Such as IF(ATTR=1,"OK","NOT OK")?
Answer:
When you say attribute, do you really think attribute, of Key Figure ?
If KF, use boolean functions (KF == Value) * (Formula if OK) + (KF <> Value) * (Formula if not OK)
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
In this case I mean attribute, not a KF.
Such as if the attribute currently displays a key of 1, then can IF/Then be applied to display "OK", 2 / "NOT OK", Etc.
Can a logical statement be applied? How?
Answer:
You can build a formula variable which retrieves the attribute value, and then create a formula using this.
It's very usefull, for example when you have billed quantities, and volume of 1 piece in the master data, to calculate cubic meters
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
How is this done?
Answer:
Depends on the BW version
2.0-2.1 : use transaction RSZV
3.0 : create variable in formula screen in the Query Builder.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.