on 11-09-2011 6:18 PM
I'm trying to write an if/then/else statement similar to the one below for BW OLAP Universe....Please help with the syntax....
<EXPRESSION>
IIF([/CPMB/JKDCC2E].LEVEL01 IN ("D01","D02","D03") AND [/CPMB/JKD4N0F].LEVEL01 = "USD",1,
IIF([/CPMB/JKDCC2E].LEVEL01 IN ("D04","D05","D06") AND [/CPMB/JKD4N0F].LEVEL01 = "Local Currency",2,
IIF([/CPMB/JKDCC2E].LEVEL01 IN ("D07","D08","D09") AND [/CPMB/JKD4N0F].LEVEL01 = "Local Currency",3,4)))
</EXPRESSION>
Hi Andrew,
Looking at your statement I get the feeling you want this as a dimension/characteristic.
Since an expression has to be numeric and a characteristic in BW cannot be numeric, this will not work.
Only measures/keyfigures are possible.
The direction from SAP is to push any modeling to the BW query or even BW itself.
Hope this helps,
Marianne
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.